How can we help?

You can also find more resources in our Help Center.

40 terms

Excel Ch. 1

STUDY
PLAY
worksheet
An Excel ________ allows data easily to be summarized and charted.
requirements
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 ________.
cell
To enter data in a cell, you must first select or activate the ________.
Text
________ is/are used to add worksheet, column, and row titles on a worksheet.
ESC
To cancel an entire entry before entering it into the cell, press the ________ key.
enter
Clicking the _______ box completes an entry.
insertion point
The ________ is a blinking vertical line that indicates where the next typed character will appear.
AutoCorrect
The ________ feature works behind the scenes, fixing common typing or spelling mistakes when you complete a text entry.
RIGHT ARROW
Pressing the ________ key to complete an entry activates the adjacent cell to the right.
left-aligned
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 ________.
6E15
To enter a number such as 6,000,000,000,000,000 you can type 6,000,000,000,000,000 you can type ________.
range
A ________ is a series of two or more adjacent cells in a column or row or a rectangular group of cells.
colon
You can enter the correct range in a function by typing the beginning and ending cell references separated by a ________.
apostrophe
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 ________.
relative
A ________ reference is an adjusted cell reference in a copied and pasted formula.
fill handle
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.
format
You ________ a worksheet to emphasize certain entries and make the worksheet easier to read and understand.
two
In general, use no more than ________ font types in a worksheet.
CTRL+B
You can apply the Bold font style by pressing the ________ keyboard shortcut keys.
merging
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?
CTRL+HOME
Pressing the ________ keyboard shortcut key(s) selects the cell A1.
11
How many chart types does Excel offer?
embedded
A(n) ________ chart is drawn on the same worksheets as the data.
legend
In the accompanying figure, the ________ identifies the colors assigned to each bar in the chart on a worksheet.
Standard
________ properties are associated with all Microsoft Office documents and include author, title, and subject.
Auto Calculate
The ________ area on the status bar displays common calculations, such as SUM or AVERAGE, for selected number in the worksheet.
INSERT
Which key toggles between Insert mode and Overtype mode?
HOME
Which key moves the insertion point to the beginning of data in a cell?
END
Which key moves the insertion point to the end of data in a cell?
F2
Which key is an alternative to double-clicking the cell to edit it?
Undo
The ________ button is located on the Quick Access Toolbar.
100
Excel remembers the last ________ actions you have completed.
click
To remove an embedded chart, you should ________ it and press the DELETE key.