Excel Basics Quiz

Which of the following is used to begin a formula in Excel?

• *

• /

• =

• $

What function would you use to add up a range of cells?

• AVERAGE

• SUM

• COUNT

• MAX

How do you start creating a new workbook in Excel?

• File>Open

• File>Save

• File>New

• File>Print

Which of the following is NOT a mathematical operation in Excel?

• Addition

• Subtraction

• Concatenation

• Multiplication

Which function is used to find the highest value in a range of cells?

• MIN

• MAX

• LARGE

• SUM

What is the cell reference for the cell located in the third column and fourth row?

• C4

• 3D

• 4C

• D3

Which of the following functions is used to count the number of cells that contain numbers?

• COUNT

• COUNTA

• COUNTIF

• COUNTBLANK

What function would you use to calculate the average of a range of cells?

• AVERAGE

• SUM

• MEDIAN

• COUNT

Which tab on the Ribbon contains the option to insert a chart?

• Home

• Insert

• Data

• Review

Which of the following is used to merge and center cells?

• Home>Format>MergeCells

• Home>Alignment>Merge&Center

• Insert>Cells>Merge

• View>Merge&Center