How2Excel 3 - Basic functions

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

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

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

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)