MS Excel Quiz

Sum, average, count, and maximum value are examples of what?

• Formulas

• Functions

• Calculations

• Spreadsheet Data

The COUNT function counts the number of cells that contain a number

• True

• False

Which symbol is used to start a formula?

• +

• -

• =

• >

When a formula contains several operations, which of the following operations would be performed first?

• Subtraction and Multiplication

• Division and Addition

• Addition and Subtraction

• Multiplication and Division

Which of the following formulas show the correct use of the SUM function?

• -SUM(H3-H10)

• =SUM(H3:H10)

• =SUM(H3...H10)

• +SUM(H3:H10)

Which character is used in a spreadsheet formula to represent multiplication?

• /

• ^

• =

• *

Which character is used in a spreadsheet formula to represent division?

• !

• -

• /

• *