Spreadsheets Formulas and Functions Quiz

Which of the following is the correct formula for adding B6 and B7 (mark all that apply)?

• =B5+B6

• =B6+B7

• =ADD(B6:B7)

• =SUM(B6:B7)

What is the correct function for adding the range B3:B24.

• =ADD(B3:B24)

• =COUNT(B3:B24)

• =MAX(B3:B24)

• =SUM(B3:B24)

The function that will give you the biggest item in the range is

• AVERAGE

• COUNT

• MAX

• MIN

What is the function needed to tell you how many students took the exam?

• AVERAGE

• COUNT

• MAX

• MIN

The function that will give you the smallest item in the range is

• AVERAGE

• COUNT

• MAX

• MIN

What is the spreadsheets first order of operations in math.

• Addition and subtraction, whichever comes first

• Exponential calculations

• Multiplication and division, whichever comes first

• Operations enclosed in parenthesis

What is the spreadsheets second order of operations in math.

• Addition and subtraction, whichever comes first

• Exponential calculations

• Multiplication and division, whichever comes first

• Operations enclosed in parenthesis

What is the spreadsheets third order of operations in math.

• Addition and subtraction, whichever comes first

• Exponential calculations

• Multiplication and division, whichever comes first

• Operations enclosed in parenthesis

What is the spreadsheets forth order of operations in math.

• Addition and subtraction, whichever comes first

• Exponential calculations

• Multiplication and division, whichever comes first

• Operations enclosed in parenthesis

Critical thinking question: In the spreadsheet above, what should the sales column formula be? Hint: We need to multiply the large price by the large servings and the small price by the small servings, and then add the two sales together. Write the formula you think would do this.