An Excel ____ allows data to be summarized and charted easily. |
worksheet |
The ____ button allows you to erase recent cell entries. |
Undo |
The first step in creating an effective worksheet is to make sure you ____. |
understand what is required |
To enter data in a cell, you must first select the ____. |
cell |
____ is/are used to place worksheet, column, and row titles on a worksheet. |
Text |
Clicking the ____ box completes an entry. |
Enter |
The ____ feature works behind the scenes, fixing common typing or spelling mistakes when you complete a text entry. |
AutoCorrect |
Pressing the ____ key to complete an entry activates the adjacent cell to the right. |
RIGHT ARROW |
The range of cells receiving copied content is called the ____ area. |
paste |
You can enter the correct range in a function by typing the beginning and ending cell references separated by a ____. |
colon (:) |
Excel remembers the last ____ actions you have completed. |
100 |
A ____ reference is an adjusted cell reference in a copied and pasted formula. |
relative |
The ____ button allows you to choose whether you want to copy the values from the source area to the destination area with formatting. |
Auto Fill Options |
You ____ a worksheet to emphasize certain entries and make the worksheet easier to read and understand. |
format |
You can apply the Bold font style by pressing the ____ keyboard shortcut keys. |
CTRL+B |
Combining two or more selected cells into one cell is called ____ cells. |
merging |
Which of the following is the Ribbon path to the Cell Styles button? |
(HOME tab | Styles group) |
What effect does the Accounting Number Format have on the selected cells? |
Displays cell contents with two decimal places that align vertically |
What effect does the Comma Style format have on the selected cells? |
Displays cell contents with two decimal places and commas as thousands separators |
Pressing the ____ keyboard shortcut key(s) selects cell A1. |
CTRL+HOME |
How many chart types does Excel offer? |
15 |
A pie chart with one or more slices offset is referred to as a(n) ____ pie chart. |
exploded |
The date you change a file is an example of a(n) ____ property. |
automatically updated |
____ properties are associated with all Microsoft Office files and include author, title, and subject. |
Standard |
You use ____ to view an XPS file. |
XPS Viewer |
The ____ area on the status bar includes six commands as well as the result of the associated calculation on the right side of the menu. |
AutoCalculate |
Which of the following keys toggles between Insert mode and Overtype mode? |
INSERT |
To erase an entire entry in a cell and then reenter the data from the beginning, press the ____ key. |
ESC |
Which of the following keys moves the insertion point to the beginning of data in a cell? |
HOME |
Which of the following keys moves the insertion point to the end of data in a cell? |
END |
A requirements document includes a needs statement, source of data, summary of calculations, and any other special requirements for a worksheet. |
True |
Worksheet titles and subtitles should be as wordy as possible. |
False |
A thin red border indicates the active cell. |
False |
Both the Cancel button and the Enter button appear on the formula bar when you begin typing in a cell. |
True |
The AutoCorrect feature can automatically capitalize the first letter in the names of days. |
True |
When text is longer than the width of a column, Excel displays the overflow characters in adjacent cells to the right as long as those adjacent cells contain no data. |
True |
Excel recognizes the following as text: 401AX21, 921-231, 619 321, 883XTY. |
True |
A single point is about 1/32 of one inch in height. |
False |
Excel can display characters in only three font colors: black, red, and blue. |
False |
A character with a point size of 10 is about 10/72 of one inch in height. |
True |
Modifying the column widths usually is done last because other formatting changes may affect the size of data in the cells in the column. |
True |
Live preview is available on a touch screen. |
True |
You can press the RIGHT ARROW or LEFT ARROW keys to position the insertion point during in-cell editing. |
True |
With Excel in Edit mode, you can edit cell contents directly in the cell. |
True |
To add a pie chart, first select the data to be charted and then tap or click the Insert Pie or Doughnut Chart button (INSERT tab | Charts group). |
True |
Excel Chapter 1
Share This
Unfinished tasks keep piling up?
Let us complete them for you. Quickly and professionally.
Check Price