Exam 15: Microsoft Excel Basics

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.

Text is any combination of letters and numbers and symbols, such as headings, labels, or explanatory notes.

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. Nicole notices that the point changes shape to become a ____ when it is in the worksheet.

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

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 ____.

You can use wildcard characters in the Find what box to search for data that matches a particular pattern. Use ____ for two or more characters.

In the Zoom dialog box, click the ____ option button to zoom the worksheet so the selected range fills the worksheet window.

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.

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.

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

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

A group of selected cells is called a(n) ____________________.

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.

To use the Replace command, in the ____ group on the Home tab of the Ribbon, click the Find & Select button, and then click Replace.

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 cell in the worksheet in which you can type data is called the open cell.

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

The name of each worksheet appears in the ____ at the bottom of the worksheet window.

Case EX 1-2 Donovan is starting to use the keyboard to navigate around an Excel spreadsheet. To move down one window, Donovan presses the ____.