Exam 7: Excel Lesson 1: Microsoft Excel Basics

You can also close the workbook and leave Excel open by clicking the Close Window button located below the sizing buttons in the status bar.

Case EX 1-1 Nicole has not used Excel before and is getting used to the different pointer shapes that Excel shows, depending on the action you are taking. When Nicole moves the pointer to a button on the Ribbon, the pointer changes to a ____.

When Excel starts, the program window displays a blank workbook titled Book1 , which includes ____ blank worksheets.

After you have saved the workbook, you can use the Save command in ____________________ view or the Save button on the Quick Access Toolbar to periodically save the latest version of the workbook with the same name in the same location.

The easiest way to change the active cell in a worksheet is to click Cell on the Ribbon and type in the cell's location.

A formula is the intersection of a row and a column.

____ appear horizontally and are identified by numbers on the left side of the worksheet window.

After you type data in a cell, the active cell changes, depending on how you enter the data. Please describe what happens if you click the Enter button on the Formula bar, if you press the Enter key, and if you press the Tab key. Also, give an example of when you would use each method of entering data.

You can change the active worksheet in a workbook to next worksheet by pressing the ____+Page Down keys.

To edit the data directly in a cell, make the cell active and then press the ____ key or double-click the cell.

The Excel program window has the same basic parts as all Office programs: the title bar, the Quick Access Toolbar, the Ribbon, Backstage view, and the status bar.

FIGURE EX 1-1 Referring to Figure EX 1-1 above, if you entered an incorrect value in one of the cells and wanted to find it, you would choose cell contents as your place to search in the ____ option box.

Numbers that extend beyond a cell's width appear as ____ in the cell.

You can create a new folder in which to save a file by clicking the New folder button in the Save As ____________________. Type a name for the new folder, and then press the Enter key.

When you press and hold down a(n) ____________________ key, the active cell shifts in that direction repeatedly and quickly.

The ____ tab enables you to select the number of copies to print, a printer, the parts of the worksheet to print, and the way the printed worksheet will look.

Microsoft Office Excel 2010 is the presentation program in Microsoft Office 2010.

The cell in the worksheet in which you can type data is called the open cell.

To replace cell contents, you can select the cell, type the new data, and then enter the data by ____.

The Formula Bar appears to the right of the Name Box and displays a formula when the cell of a worksheet contains a calculated value.