Excel Functions and Features Assessment

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

• Formula bar

• Dialog box

• Worksheet tab

• Cell name box

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

• Graphs

• Worksheets

• Formulas

• Table guides

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

• Normal

• Page Break Preview

• Gridline

• Page Layout

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

• Insert

• Page Design

• Home

• File

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

• Page Layout tab, Paragraph group

• Home tab, Editing group

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

• A1+B2

• =$A1,$B2

• =A1+B2

• SUM(A1:B2)

Which of the following is an absolute cell reference?

• $A$1

• A$1

• $A1

• A1

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

• AutoComplete

• Conditional formatting

• FillComplete

• AutoFinish

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

• Icon set

• Data bar

• Comment

• Highlight

Which of the following can be used to copy the formatting applied to a cell?

• Format bar

• Format painter

• Format cell

• Format handle