Excel Worksheet Quiz

Which of the following shows the location of the cell which has been selected?

• Formula bar

• Cell name box

• Worksheet tab

• Dialog box

Which of the following are composed of a grid system of rows and columns which cross to make cells?

• Worksheets

• Table guides

• Graphs

• Formulas

Which of the following is NOT a viewing option for a worksheet?

• Normal

• Page Layout

• Page Break Preview

• Gridline

Backstage View can be reached by clicking on which tab of the Ribbon?

• File

• Home

• Insert

• Page Design

Which tab and group on the Ribbon holds the command to change the font of the text of the cells of a worksheet?

• Home tab, Paragraph group

• Home tab, Font group

• Home tab, Editing group

• Page Layout tab, Paragraph group

Which of the following is the correct formula to add cells A1 and B2?

• A1+B2

• = A1+B2

• SUM(A1:B2

• =$A1,$B2

Which of the following is an absolute cell reference?

• A1

• A$1

• $A1

• $A$1

Which of the following finishes an entry based on previous entries made in the column containing the active cell?

• AutoFinish

• FillComplete

• Conditional formatting

• AutoComplete

Which of the following is NOT a type of conditional formatting?

• Data bar

• Icon set

• Highlight

• Comment

Which of the following functions finds the lowest value in a range of cells?

• =AVG( )

• =MAX( )

• =LOW( )

• =MIN( )