Excel Ch. 1
An Excel ________ allows data easily to be summarized and charted.
The person or persons requesting the worksheet should supply their requirements in a ________ document.
understand what is required
The first step in creating an effective worksheet is the make sure you ________.
To enter data in a cell, you must first select or activate the ________.
________ is/are used to add worksheet, column, and row titles on a worksheet.
To cancel an entire entry before entering it into the cell, press the ________ key.
Clicking the _______ box completes an entry.
The ________ is a blinking vertical line that indicates where the next typed character will appear.
The ________ feature works behind the scenes, fixing common typing or spelling mistakes when you complete a text entry.
Pressing the ________ key to complete an entry activates the adjacent cell to the right.
By default, text is ________ in a cell.
0 1 2 3 4 5 6 7 8 9 . $ % E e + - ( ) , /
In Excel, a number can contain the characters ________.
To enter a number such as 6,000,000,000,000,000 you can type 6,000,000,000,000,000 you can type ________.
A ________ is a series of two or more adjacent cells in a column or row or a rectangular group of cells.
You can enter the correct range in a function by typing the beginning and ending cell references separated by a ________.
To enter a number as a text, precede it with a(n) ________.
destination area (or paste area)
The cell being copied is called the source area (or copy area). The range of cells receiving the copy is called the ________.
A ________ reference is an adjusted cell reference in a copied and pasted formula.
The ________ is the small black square located in the lower right corner of the heavy border around the active cell.
Auto Fill Options
The ________ allows you to choose whether you want to copy the values from the source area to the destination area with formatting.
You ________ a worksheet to emphasize certain entries and make the worksheet easier to read and understand.
In general, use no more than ________ font types in a worksheet.
You can apply the Bold font style by pressing the ________ keyboard shortcut keys.
Combining two or more selected cells is called ________ cells.
(Home tab | Styles group)
What is the Ribbon path to the Cell Styles button?
Displays cell contents with two decimal places that align vertically.
What effect does the Accounting Number Format have on the selected cells?
Displays cell contents with two decimal places and commas as thousands separators.
What effect does the Comma Style format have on the selected cells?
Pressing the ________ keyboard shortcut key(s) selects the cell A1.
How many chart types does Excel offer?
A(n) ________ chart is drawn on the same worksheets as the data.
In the accompanying figure, the ________ identifies the colors assigned to each bar in the chart on a worksheet.
________ properties are associated with all Microsoft Office documents and include author, title, and subject.
The ________ area on the status bar displays common calculations, such as SUM or AVERAGE, for selected number in the worksheet.
Which key toggles between Insert mode and Overtype mode?
Which key moves the insertion point to the beginning of data in a cell?
Which key moves the insertion point to the end of data in a cell?
Which key is an alternative to double-clicking the cell to edit it?
The ________ button is located on the Quick Access Toolbar.
Excel remembers the last ________ actions you have completed.
To remove an embedded chart, you should ________ it and press the DELETE key.