Microsoft Excel Formulas & Functions

All formulas must begin with

• equal sign
• plus sign
• minus sign
• asterisk

What symbol means to multiply?

• equal sign
• asterisk
• diagonal
• minus 

What symbol means to divide?

• equal sign
• asterisk
• slash (diagonal)
• minus 

This instructs the software to perform a calculation.

• value
• label
• formula
• text box

Which is the correct formula to add cells A1 to A5?

• =SUM(A2+A5)
• =SUM(A1:A5)
• =A1+A2+A3
• =SUM(A1:A4)

What symbol prepares a cell for the entry of a formula?

• +
• -
• /
• =

Groups of cells are called:

• list
• range
• set
• None of these

Formulas cannot contain spaces.

• True
• False

You can enter formulas into the Name box.

• True
• False

Counts the cells containing numbers in a range of cells

• COUNT( )
• COUNTA( )
• NUMBER( )
• SUM( )