Exam 3: Excel Lesson 1: Understanding Excel Fundamentals

A footer refers to text that appears in the bottom margin of a worksheet when printed.

The AutoRecover feature is designed to save your work so you don't have to use the Save command.

An Excel file is called a worksheet .

The name of a worksheet is displayed on the ____.

Case EX 1-1 Clyde is using Excel to create a client invoice for the event-planning business that he operates from his home office. If Clyde wants to enter a number as text, he can type a(n) ____ before the number to signal that it is not to be used in calculations.

If you enter text in a cell that is longer than the cell can display, the remaining text will be stored in the adjacent cell.

Case EX 1-2 In her position as a financial advisor, Mallory frequently works with workbooks containing multiple worksheets. To rename a worksheet with a descriptive name that better identifies the data, Mallory would double-click the ____.

Press Ctrl+Home to move to the first cell of a row.

To select all cells on the worksheet, click the Select All button, located ____.

When you choose Print in Backstage view, you can click the ____ button to display the worksheet at larger magnification.

Entering data and then pressing the Tab key selects the cell below the it, making it the active cell.

If you had a budget that you had created on paper, describe the process you would take to transfer the data to a worksheet. What would be the advantages of using spreadsheet software such as Excel for your budget?

By default, a workbook contains ____ worksheets.

You can open an existing workbook using the Office dialog box.

To close a workbook without closing Excel, you select the Close command on the ____.

When you ____ a sheet tab, the sheet name is selected and you can type a new name.

After you save a file for the first time, you can use the ____ button on the Quick Access Toolbar to update it as you make changes to it.

____________________ are displayed horizontally and have numbered headings running consecutively down the left side of the worksheet.

You can also edit or delete data directly in the cell by selecting the cell and pressing ____.

____________________ software is used to calculate, analyze, and visually represent numerical data.