SPREADSHEET PACKAGE 1 - (ADVANCED - BASIC ARITHMETIC OPERATORS AND FUNCTIONS) (SS2 NOTES)

-

 


SPREADSHEET PACKAGE 1 -

 (ADVANCED - BASIC ARITHMETIC OPERATORS AND FUNCTIONS)



MEANING OF A FUNCTION

A function is a predefined formula that performs calculations using specific values in a particular order. All spreadsheet programs include common functions that can be used for quickly finding the sum, average, count, maximum value, and minimum value for a range of cells. In order to use functions correctly, you'll need to understand the different parts of a function and how to create arguments to calculate values and cell references.

THE PARTS OF A FUNCTION

In order to work correctly, a function must be written a specific way, which is called the syntax. The basic syntax for a function is an equals sign (=), the function name (SUM, for example), and one or more arguments. Arguments contain the information you want to calculate. The function in the example below would add the values of the cell range A1:A20.


FUNCTIONS                                         EXAMPLES/ARGUMENTS

1. SUM                         -                     = SUM (B2:G2)

                                                          = SUM (A2:A7, A9, A12, A15)

2. AVERAGE                -                   = AVERAGE (NUMBER1, NUMBER2)

                                                         = AVERAGE (B2:B11)

3. COUNT                   -                   = COUNT (A1:C1), = COUNTA (C2:C13)                

- This count all values that are

  numerical

4. IF                           -                      = IF (C2<D3, "TRUE", "FALSE")

                                                   IF (SUM (C1:C10)> SUM (D1:D10), SUM (C1:C10), SUM (D1:D10)

5. MAX & MIN       -                  = MIN (Number1, Number2)

* This finds the maximum and    = MIN (B2:C11)

minimum number in a range of   = (B2:C11)

 values

6. PRODUCT     -                        =PRODUCT(A1, A2) 

                                       = PRODUCT (A1:A5)

                                       = A1*A2

7. DIFFERENCE          "=A1-B1"


CLASS ACTIVITY

* PRACTICAL

Comments

Post a Comment

Popular posts from this blog

COMPUTER STUDIES JS2 _ SECOND TERM - MID TERM PROJECT

-
Image
  MID TERM PROJECT MARKS OBTAINABLE: 50 MARKS Use Basic 256 app to write/run BASIC programming language to : 1. Find the area of a triangle 2. Find the perimeter of a rhombus 3. Area of a trapezium 4. Volume of a cuboid Steps: (a) Download and Install BASIC 256 on your laptop. (b) Run your project and screenshot your result (c) Submit your project to : sunlitedigitalhub@gmail.com
Read more

COMPUTER STUDIES _ MID TERM PROJECT –JS3 (SECOND TERM)

-
Image
  MID TERM PROJECT –JS3    (40MARKS) 1. Create a spreadsheet document (i.e using Microsoft Excel) for company payroll as shown below: (a)   Find the   basic pay for each staff by using the formula: BASIC PAY = HOURS WORKED * PAY PER HOUR (b) Add five (5) names of your choice, hours worked, and pay per hour to make the records 10. (c) Find the total BASIC PAY on row 11   S/N NAMES OF STAFF HOURS WORKED PAY PER HOUR (N) BASIC PAY (N) 1 IJILUSI OPEYEMI 2 400   2 OMONIYI SOLA 3 200   3 AGATI FATGAN 4 100   4 UMAR ABDULAHI 3 100   5 IBEKWE EBUKA 2 200   6       ...
Read more

JS3 CLASS - ONLINE CLASS TASK_COMPUTER VIRUS (COMPUTER STUDIES)

-
Image
  ASSESSMENT TASK PART A 1. What is a computer virus? a) A program designed to protect your computer b) A program designed to improve computer performance c) A program designed to harm or disrupt computer operation d) A program designed to enhance internet speed 2. Which of the following is NOT a common way computer viruses spread? a) Email attachments b) Social media posts c) USB flash drives d) Voice commands 3. What is the primary purpose of a computer virus? a) To make your computer run faster b) To steal personal information c) To damage or corrupt data d) To improve internet security 4. Which of the following is an example of a preventive measure against computer viruses? a) Regularly updating antivirus software b) Sharing passwords with friends c) Downloading files from unknown sources d) Ignoring software updates 5. What is the term for a program that appears legitimate but performs malicious activities? a) Trojan horse b) Spyware c) Firewall d) Antivirus 6. Which of the fo...
Read more