Microsoft Excel 2019 Final Exam Review

Which of the following keyboard shortcuts will help you replace data?

• Ctrl+F

• Ctrl+G

• Ctrl+H

• Ctrl+R

The word Jan was entered in cell A1, Apr was entered in cell B1, and you then used AutoFill to automatically fill cells C1 and D1. What would cell D1 contain?

• Oct

• May

• Jun

• Jul

In which of the following tabs will you find the Insert Function command?

• Home

• Insert

• Page Layout

• Formulas

Where on screen will you find the Formula bar?

• On the Formulas tab

• In the Status bar

• In the Title bar

• Underneath the ribbon

Where will you find AutoSave?

• On the ribbon

• File > Save

• File > Save As

• The Quick Access Toolbar

To paste data so that the formula is removed leaving the result only, which Paste option would you use?

• Transpose

• Formulas

• Values

• Formatting only

Altering column widths to the exact size needed to display all the cell contents in that column is known as which of the following?

• AutoFill

• AutoFit

• AutoCalculate

• Automatic update

Most formatting options are available for use from which tab on the ribbon?

• Page Layout

• Insert

• Home

• Review

Which built-in cell style would you use to apply a dark green font color with a light green fill color to selected cells?

• Title

• Good

• Calculation

• Hyperlink

Which command can you use to hide column or row data that doesn't match the defined criteria?

• Sort

• Filter

• Conditional Formatting

• Custom Sort