Microsoft Excel Final Exam Review

Which of the following shows the location of the cell which you have selected?

• Formula bar

• Cell name box

• Worksheet tab

• Dialog box

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

• File

• Home

• Insert

• Page Design

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 CANNOT be used as a math operator in a formula?

• * asterisk

• + plus sign

• : colon

• / slash

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

• Normal

• Page Layout

• Page Break Preview

• Gridline

Which of the following formulas returns the current date and time?

• =DATE( )

• =TIME( )

• =NOW( )

• =TODAY( )

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 group on the Page Layout tab contains the commands to adjust the margins and page orientation of a worksheet?

• Themes

• Page Setup

• Scale to Fit

• Sheet Options

Which tab and group contains the option for adding conditional formatting?

• Home tab, Font group

• Insert tab, Illustrations group

• Data tab, Data Tools group

• Home tab, Styles group

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

• =AVG( )

• =MAX( )

• =LOW( )

• =MIN( )