Excel Module 1

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

Which of the following options is not a file extension for any type of Microsoft Excel workbook?

• .xltx

• .csv

• .xltm

• .txt

A workbook that is saved as an Excel 97-2003 workbook has a ____ file extension.

You access the Find command via the ________ group on the Home tab.

You can use the keyboard shortcut ___ to save a workbook in a different location, or with a different name.

Where will you find the Convert command?

• File > Info

• File > Options

• Insert > Tables

• Page Layout > Page Setup

Why might you use the ribbon display options?