Excel Modules 1.1 and 1.2 Review

If you've opened the desired workbook recently, you can browse your (a)   Workbooks rather than search for the file.

• Print

• Account

• Publish

• Recent

Compatibility Mode ______________ certain features, so you'll only be able to access commands found in the program that was used to create the workbook. For example, if you open a workbook created in Excel 2003, you can only use tabs and commands found in Excel 2003.

• disables

• enables

• hides

• creates

In order to exit Compatibility Mode, you'll need to ______________ the workbook to the current version type. However, if you're collaborating with others who only have access to an earlier version of Excel, it's best to leave the workbook in Compatibility Mode so the format will not change.

• convert

• rename

• delete

• lock

Whenever you create a new workbook in Excel, you'll need to know how to __________ it in order to access and edit it later.

• save

• print

• delete

• close

Save As: You'll use this command to create a ________________ of a workbook while keeping the original. When you use Save As, you'll need to choose a different name and/or location for the copied version.

• copy

• shortcut

• template

• link

You can also access the Save command by pressing Ctrl+ (a)   on your keyboard.

• S
• O

• Z

• P

By default, Excel workbooks are saved in the (a)   file type. However, there may be times when you need to use another file type, such as a PDF or Excel 97-2003 workbook. It's easy to export your workbook from Excel to a variety of file types.

• .docx

• .xlsx
• .pptx

• .xls

If you frequently work with the same workbook, you can ___ it to Backstage view for faster access.

How many worksheets are included in a new blank workbook?

• 1

• 3

• 0

• 6

Match the term with the correct definition:

• worksheet

• A small, onscreen rectangle that displays descriptive text when you rest the pointer on a command or control.

• Screen Tips

• A page in a workbook that consists of a grid of rows and columns in which you can enter text, values, and formulas, and perform calculations.

• Keytips

• A collection of worksheets in a single file.

• workbook

• A toolbar that gives you fast and easy access to the tools you use most often in Excel.

• Quick Access Toolbar

• Pressing the ALT key will display keyboard shortcuts on the ribbon.