Term
| 1.At any point while working with an Excel worksheet, a task pane can be opened or closed by clicking the Task pane command on the _____. |
|
Definition
|
|
Term
| 2.The active cell can be identified in all of the following ways except _____. |
|
Definition
| d.a block arrow displays in the center of the cell |
|
|
Term
| 3.When both the Standard toolbar and Formatting toolbar display on the same row, all of the buttons on either toolbar can be displayed by _____. |
|
Definition
| c.double-clicking the move handle on the left of each toolbar |
|
|
Term
| 4.When the Language bar is _____, it means it is displayed on the Windows taskbar. |
|
Definition
|
|
Term
| 5.The easiest way to select a cell (make it active) is to _____. |
|
Definition
| d.use the mouse to move the block plus sign to the cell and then click |
|
|
Term
| 6.To complete an entry into a cell, click the _____. |
|
Definition
|
|
Term
| 7.In Excel, a number can contain the characters _____. |
|
Definition
0 1 2 3 4 5 6 7 8 9 . + - ( ) , /
. $ % E e
d. all of the above |
|
|
Term
| 8.When proposing a range of cells to sum using the SUM button, Excel first looks for a range of cells with numbers _____. |
|
Definition
| b.above the active cell and then to the left |
|
|
Term
| 9.The _____ is the small black square located in the lower-right corner of the heavy border around the active cell. |
|
Definition
|
|
Term
| 10.When one range is copied to another, Excel displays the _____ that can be used to choose whether to copy the value with formatting, without formatting, or only copy the format. |
|
Definition
| c.Auto Fill Options button |
|
|
Term
| 11.The _____ defines the appearance and shape of letters, numbers, and special characters. |
|
Definition
|
|
Term
| 12.A character with a point size of 10 is about _____ of an inch in height |
|
Definition
|
|
Term
| 13.To display the AutoFormat dialog box shown in the accompanying figure and format a range automatically, use the AutoFormat command on the _____. |
|
Definition
|
|
Term
| 14.In the AutoFormat dialog box shown in the accompanying figure, the Close button or the _____ terminates the current activity and closes the AutoFormat dialog box. |
|
Definition
|
|
Term
| 15.In the AutoFormat dialog box shown in the accompanying figure, the _____ allows additional formats, such as fonts or borders, to be deselected within an autoformat. |
|
Definition
|
|
Term
| 16.The small _____ at the corners and along the sides of the rectangle that encloses an embedded chart indicate the chart is selected. |
|
Definition
|
|
Term
| 17.The small box to the right of an embedded column chart contains the legend, which _____. |
|
Definition
| b.identifies the colors assigned to each bar in the chart |
|
|
Term
| 18.When Excel is installed on a computer, the default chart type is the 2-D (two-dimensional) _____. |
|
Definition
|
|
Term
| 19.When you click the Tools button in the Save As dialog box, the _____ in the list that displays allows you to save a backup copy of the workbook, create a password to limit access to the workbook to be created, and carry out other functions. |
|
Definition
| d.General Options command |
|
|
Term
| 20.A password entered in the Save As dialog box is _____ and can be up to 15 characters long. |
|
Definition
|
|
Term
| 21.The _____ can be used to quit Excel |
|
Definition
| c.Close button and Control-menu icon on the title bar |
|
|
Term
| 22.Clicking None at the top of the AutoCalculate shortcut menu _____. |
|
Definition
| a.turns off the AutoCalculate area |
|
|
Term
| 23.When a cell containing an error is double-clicked, Excel switches to _____, the active cell contents display in the formula bar, and a flashing insertion point displays in the active cell. |
|
Definition
|
|
Term
| 24.Excel provides the Undo command on the _____ and the Undo button on the Standard toolbar, both of which can be used to erase the most recent cell entries. |
|
Definition
|
|
Term
| 25.To clear an entire worksheet, click the _____ and then press the DELETE key. |
|
Definition
| d.Select All button on the worksheet or press CTRL+A |
|
|
Term
| 1._________________________ is a powerful spreadsheet program that allows users to organize data, complete calculations, make decisions, graph data, develop professional looking reports, publish organized data to the Web, and access real-time data from We |
|
Definition
|
|
Term
| 2.When Excel starts, a(n) _________________________, which is a separate window that enables users to carry out some Excel tasks more efficiently, displays on the screen. |
|
Definition
|
|
Term
| 3.A new blank _________________________ called Book1, such as that illustrated in the accompanying figure, is like a notebook and is created when Excel starts. |
|
Definition
|
|
Term
| 4.Inside a workbook, such as that shown in the accompanying figure, are _________________________ each of which has a name that displays on a sheet tab at the bottom of the workbook. |
|
Definition
|
|
Term
| 5.The intersection of a row and column in the worksheet in the accompanying figure is a(n) _________________________, which is the basic unit into which data is entered. |
|
Definition
|
|
