Microsoft Excel® 2019 Basics - Review

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

• File

• Home

• Insert

• Page Design

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

• Format bar

• Format handle

• Format painter

• Format cell

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

• =AVG()

• =MAX()

• =LOW()

• =MIN()

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 NOT a viewing option for a worksheet?

• Normal

• Page Layout

• Page Break Preview

• Gridline

Which group on the Formulas tab holds the command to show the formulas in formula view?

• Function Library

• Defined names

• Formula Auditing

• Calculation

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 comparison operator?

• > greater than arrow

• < less than arrow

• / slash

• = equals sign

Which of the following cell references is read as "cell A1 and D6?"

• A1,D6

• A1!D6

• A1:D6

• A1-D6

Which of the following CANNOT be used as a math operator in a formula?

• asterisk

• + plus sign

• : colon

• / slash