Excel Formulas

Which operator is used to multiply in Excel?

• +

• -

• /

• *

All formulas begin with a(n) _______________.

• &

• =

• +

• #

Excel will display _______________________ if the cell is not wide enough.

• ******

• ^^^^^

• ######

• >>>>>

To update data in a worksheet, you have to rewrite the formula.

• True

• False

Formulas can be copied to adjacent cells with the ____________.

• Fill handle

• PgDn Key

• Function key F4

• None of the above

To edit a formula you

• Double-click the cell

• Click in the formula bar

• Press Esc

• Both A & B

To show formulas use the following speed command.

• Ctrl + *

• Ctrl + `

• Alt + Ctrl

• Shift + #

Answer =2+3*3-2

• 9

• 10

• 11

• 12

Answer =3+5*(6-2)

• 23

• 32

• 31

• 64

__________________is an alphanumeric value used to identify a specific cell in a spreadsheet.

• Formula

• Calculation

• Cell address

• None of the above