Utilizing Formulas and Functions Review

To create a formula, you first:

• Select the cell you want to place the formula into
• Type the equals sign (=) to tell Excel that you're about to enter a formula
• Enter the formula using any input values and the appropriate mathematical operators that make up your formula
• Choose the new command from the file menu

What would be a correct formula for SUM in excel?

• =SUM(B3:B9)
• =SUMB3+B9
• SUM(B3:B9)
• =ADD(B3:B9)

Which button can you click to add up a series of numbers?

• The autosum button
• The Formula button
• The quicktotal button
• The total button

Which formula gets the biggest value of a range of cells?

• MAX
• MIN
• LARGE
• SUM

Which formula gets the smallest value of a range of cells?

• MAX
• MIN
• SMALL
• SUM

Which symbol must all formula begin with?

• =
• +
• (
• @

Which of these symbols is used for divide on a computer?

• \

• *

• /

• |

Which of the following is an example of an absolute cell reference?

• A9
• A$9
• $A$9
• A9:E9

Which of the following is an example of a mixed cell reference?

• A9
• A$9
• $A$9
• A9:E9

Regarding a named range, the scope of a name is the location within which Excel recognizes the name without qualification.

• TRUE
• FALSE