Excel Quiz

What function would you use to add up all the numbers in a row or column?

• SUM

• =SUM

• COUNT

• =COUNT

• =SOME

Columns are named with....?

• Letters

• Numbers

• Arrows

• Cells

• Anything

If you are changing the color of the font in a cell, what menu are you using?

• Format

• Change

• Bold

• Cell

• Function

What format would you use to change the number in a cell to have a $ (dollar sign)?

• Currency

• Percent

• Color

• Dollars

• Decimal

When you are working in an Excel workbook, does Excel automatically show when you spell something wrong right after you type it?

• Yes

• No

When printing a workbook, which feature would you use to change the page to landscape?

• A

• B

• C

• D

• E

Formulas always begin with which symbol?

• =

• $

• %

• +

• -

Excel always follows which rule in math?

• PEMDAS

• Start left and work right

• Addition and subtraction are always first

• Numbers must always be formatted

• You can divide by zero

Which symbol do you use to create an absolute cell reference?

• $

• =

• #

• /

• -

Is AutoSum a function?

• Yes

• No