Excel Quiz

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

• Currency

• Percent

• Color

• Dollars

• Decimal

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

What would be a correct formula for SUM in excel?

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

You can edit a cell by...

• Clicking the formula button
• Double clicking the cell
• Selecting Edit>Edit Cell from the menu
• None of above

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

• MAX
• MIN
• SMALL
• SUM

Columns go...

• Across
• Down

Rows go...

• Across
• Down

What do you want to do to combine cells to create one heading? 

• Merge
• Label
• Align
• Format

What does this button do? 

• adds cells together
• multiplies cells together