Font size
WorksheetsHow2Excel 3 - Basic functions
Total questions: 10
Worksheet time: 7mins
What function needs to be typed into A4 to add up of all the values in cell range A1:A3?
=SUM(A1,C3)
=ADD(A1:C3)
=SUM(A1:C3)
=(A1:C3)
What function needs to be typed into A4 to find the largest value in cell range A1:A3?
=SUM(A1:A3)
=MAX(A1:A3)
=MAX(A1,A3)
=MAX(A4)
What function needs to be typed into B4 to count all the values in cell range A1:C3 that contains NUMBERS?
=COUNTA(A1:C3)
=COUNT(A1:C3)
=COUNTIF(A1:C3)
=SUM(A1:C3)
What function needs to be typed into A4 to find the average of all the values in cell range A1:A3?
REMEMBER: Use only capital letters. No spaces in between characters
(a)
What function needs to be typed into A4 to find the smallest of all the values in cell range A1:C3?
REMEMBER: Use only capital letters. No spaces in between characters
(a)
What function needs to be typed into B4 to count all the values in cell range A1:C3 that contains ANYTHING (eg. are not empty)?
REMEMBER: Use only capital letters. No spaces in between characters
(a)
What function needs to be typed into B4 to count all the cells that contain the number 3 in cell range A1:C3?
=COUNTA(A1:C3,3)
=COUNT(A1:C3)
=COUNTIF(A1:C3)
=COUNTIF(A1:C3,3)
What function needs to be typed into B4 to count all the cells that contain the name "Bob" in cell range A1:C3?
=COUNTIF(A1:C3,Bob)
=COUNTIF(A1:C3,"Bob")
=COUNTA(A1:C3,"Bob")
=COUNT(A1:C3,Bob)
What function needs to be typed into B4 to count all the empty cells in cell range A1:C3?
=COUNTIF(A1:C3,Empty)
=COUNTIF(A1:C3,"Empty")
=COUNTBLANK(A1:C3)
=COUNTEMPTY(A1:C3)
What function needs to be typed into B4 to count all the cells in cell range A1:C3, that are NOT empty?
=COUNTA(A1:C3)
=COUNTIF(A1:C3,"not empty")
=COUNTBLANK(A1:C3,FALSE)
=COUNT(A1:C3)
