SPREADSHEET FUNCTIONS

In a spreadsheet, all formulae must begin with _______ sign.

• #

• =

• $

• &

To count only numerical data's, _________ function is used.

• COUNTIF

• COUNTA

• COUNTBLANK

• COUNT

Which function is correct for adding up a selection of numbers?

• sum(A1+A10)

• =sum(A1+A10)

• sum(A1:A10)

• =sum(A1:A10)

What two operations does the AVERAGE function perform?

• Addition and Multiplication

• Multiplication and Division

• Addition and Subtraction

• Addition and Division

What function should be entered to calculate the total budget?

• =AVERAGE(B3:B6)

• =SUM(B3:B6)

• =SUM(B3-B6)

• =TOTAL(B3:B6)

Which formula will find the minimum value in the range C1 to C4 if the values are 7, 2, 9, and 5?

If the values in cells D1, D2, and D3 are 15, 25, and 10 respectively, which formula will find the maximum value?

Which of the following formulas correctly calculates the average of the values in cells F1 through F3?