Ex - Basic Functions 2

Which of the following is an example of a spreadsheet function?

• =sum(A2:A10)

• Function(Sum(A2:A10))

• sum=(A2:A10)

• =(A2:A10)Sum

The __________ function is used to determine the number of cells that contain NUMBERS/VALUES.

• =SUM( )

• =COUNT( )

• =COUNTA( )

• =AVERAGE( )

Which function will display the number of cells that have TEXT or NUMBERS in them?

• =COUNTA( )

• =SUM( )

• =AVERAGE( )

• =COUNT( )

_________ functions is used to determine the number of cells that are NOT EMPTY.

• =AVERAGE( )

• =SUM( )

• =COUNT( )

• =COUNTA( )

All functions have three parts: Equal Sign, Function Name and __________________.

• Argument

• Formula

• Relational Operators

• Logical Operators

B5:G10 is best described as a_____________.

• Cell References

• Value

• Range

• Formula

Which expression will determine the number of numeric values in the range, B2:B6?

• =COUNT(B2:B6)

• =COUNTA(B2:B6)

• =COUNT(B2-B6)

• =COUNTA(B2-B6)

Which expression will determine the lowest GPA?

• =MAX(C2:C6)

• =MIN(C2:C6)

• =LOWEST(C2:C6)

• =AVERAGE(C2:C6)

Which expression will compute the average GPA of the students?

• =SUM(C2:C6)

• =AVG(C2:C6)

• =COUNTA(C2:C6)

• =AVERAGE(C2:C6)

What will the return value/answer be if =COUNT(B2:B9) is entered in B10?

• 8

• N/A

• 9

• 6