|
Combining two or more selected cells into one cell is called ____ cells. |
merging |
|
Clicking the ____ box completes an entry. |
enter |
|
A pie chart with one or more slices offset is referred to as a(n) ____ pie chart |
exploded |
|
The group of adjacent cells beginning with B4 and ending with B8, written as B4:B8, is called a(n) range. |
True. |
|
____ properties are associated with all Microsoft Office files and include author, title, and subject. |
Standard |
|
Excel can display characters in only three font colors: black, red, and blue. |
False |
|
You can apply the Bold font style by pressing the ____ keyboard shortcut keys. |
CTRL+B |
|
The first step in creating an effective worksheet is to make sure you |
understand what is required |
|
Pressing the ____ keyboard shortcut key(s) selects cell A1. |
CTRL+HOME |
|
Which of the following is the Ribbon path to the Cell Styles button? |
HOME tab | Styles group |
|
A ____ reference is an adjusted cell reference in a copied and pasted formula |
relative |
|
is/are used to place worksheet, column, and row titles on a worksheet. |
text |
|
Pressing the ____ key to complete an entry activates the adjacent cell to the right. |
right arrow |
|
Live preview is available on a touch screen. |
false |
|
You ____ a worksheet to emphasize certain entries and make the worksheet easier to read and understand |
format |
|
A given range contains the data that determines the size of slices in a corresponding pie chart; these entries are called the category names. |
False |
|
In a worksheet, columns typically contain information that is similar to a list |
False- row not columns |
|
You can enter the correct range in a function by typing the beginning and ending cell references separated by a |
colon (:) |
|
You can turn off the Bold formatting for selected text by clicking the Roman button (Home tab | Font group). |
False. You can not turn off the Bold formatting by clicking the Roman button |
|
A character with a point size of 10 is about 10/72 of one inch in height |
true – a point size of 10 is about 10/72 of one inch in height |
|
The ____ feature works behind the scenes, fixing common typing or spelling mistakes when you complete a text entry. |
Auto Correct |
|
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 |
|
What effect does the Accounting Number Format have on the selected cells |
Displays cell contents with two decimal places that align vertically |
|
An Excel ____ allows data to be summarized and charted easily. |
worksheet |
|
The ____ button allows you to erase recent cell entries. |
Undo |
|
A thin red border indicates the active cell. |
False – green |
|
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 |
|
Combining two or more selected cells into one cell is called ____ cells. |
merging |
|
Excel remembers the last ____ actions you have completed. |
100 |
|
Both the Cancel button and the Enter button appear on the formula bar when you begin typing in a cell. |
true |
|
Which of the following keys toggles between Insert mode and Overtype mode? |
INSERT |
|
Which of the following keys moves the insertion point to the beginning of data in a cell |
HOME |
|
Worksheet titles and subtitles should be as wordy as possible |
False – NO WORDY |
|
Excel recognizes the following as text: 401AX21, 921-231, 619 321, 883XTY. |
True |
|
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 |
|
Press ____ to select the entire worksheet |
CTRL+A |
|
A requirements document includes a needs statement, source of data, summary of calculations, and any other special requirements for a worksheet. |
True |
|
You can press the RIGHT ARROW or LEFT ARROW keys to position the insertion point during in-cell editing. |
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 |
|
You use ____ to view an XPS file. |
XPS Viewer |
|
To enter data in a cell, you must first select the |
Cell |
|
Which of the following keys moves the insertion point to the end of data in a cell? |
END |
|
To erase an entire entry in a cell and then reenter the data from the beginning, press the ____ key |
ESC |
|
With Excel in Edit mode, you can edit cell contents directly in the cell. |
True |
|
The person or persons requesting the worksheet should supply their requirements in a ____ document |
requirements |
|
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 |
|
To use the AutoCalculate area, select the range of cells containing the numbers for a calculation you want to verify and then press and hold or double-click the AutoCalculate area to display the Customize Status Bar shortcut menu. |
False |
|
The AutoCorrect feature can automatically capitalize the first letter in the names of days. |
True |
|
You should press the SPACEBAR to clear a cell |
False |
|
The date you change a file is an example of a(n) ____ property |
automatically updated |
|
The opposite of merging cells is splitting a merged cell. |
True |
|
A single point is about 1/32 of one inch in height |
False |
|
How many chart types does Excel offer? |
15 |
|
The range of cells receiving the content of copied cells is called the |
destination area |
|
What effect does the Comma Style format have on the selected cells |
Displays cell contents with two decimal places and commas as the thousands separators |
|
The range of cells receiving copied content is called the ____ area |
paste |
Share This
Flashcard
