Functions In Spreadsheets

Question 1

Today Function (Function in Spreadsheets)

Answer 1

• used to add today’s date to a spreadsheet
• Syntax: = Today()

Question 2

Now Function (Function in Spreadsheets)

Answer 2

• returns both the current date and time
• Syntax: = NOW ()

Question 3

Sum Function (Function in Spreadsheets)

Answer 3

• used to add all cells in a range.
• uses a comma, the plus & the colon
• Syntax: = SUM(_ _)

Question 4

Average Function (Functions in Spreadsheets)

Answer 4

• This function is used to find the arithmetic mean of a series of numbers or in other words used to calculate the average of the cells in a given range
• the division sign is used as / when dividing
• The syntax can contain
  • the function for finding the mean
  • the cell address of the data in the worksheet
  • a range of cells references & cell addresses

Question 5

Minimum Function (Functions in Spreadsheets)

Answer 5

• used to find the lowest or smallest value in a range

Question 6

Maximum Function (Functions in Spreadsheets)

Answer 6

• used to find the highest or largest value in a range

Question 7

Count Function (Functions in Spreadsheets)

Answer 7

• used to find the number of cells that contain a numerical value within a range

Question 8

Count A Function (Functions in Spreadsheets)

Answer 8

• not only does spreadsheets allow you to count with numbers but also text data such as names, items, etc
• the syntax can contain:
  • the function for finding the number of text or words
  • the cell addresses of the location of the data in worksheet
  • a range of cell references & cell addresses

Question 9

IF Function (Functions in Spreadsheets)

Answer 9

-A conditional function
- tests a certain argument in a spreadsheet to see if it is true or false
- operates similar to the IF statement in programming

Question 10

Count IF Function (Functions in Spreadsheets)

Answer 10

• used to count the number of cells in a spreadsheet that contains a particular value or a set of values
• allows us to to do this by counting only those cells in the range that meets the criteria that you set