Which of the following is the Ribbon path to the Cell Styles button? |
(HOME tab | Styles group) |
You should press the SPACEBAR to clear a cell. |
False |
Pressing the ____ key to complete an entry activates the adjacent cell to the right. |
Right arrow |
Excel remembers the last ____ actions you have completed. |
100 |
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 |
____ properties are associated with all Microsoft Office files and include author, title, and subject. |
Standard |
Combining two or more selected cells into one cell is called ____ cells. |
merging |
A single point is about 1/32 of one inch in height. |
false |
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 |
A pie chart with one or more slices offset is referred to as a(n) ____ pie chart. |
exploded |
Press ____ to select the entire worksheet. |
ctrl+A |
A thin red border indicates the active cell. |
False |
To enter data in a cell, you must first select the ____. |
cell |
In a worksheet, columns typically contain information that is similar to a list. _________________________ |
False |
An Excel ____ allows data to be summarized and charted easily. |
worksheet |
Both the Cancel button and the Enter button appear on the formula bar when you begin typing in a cell. |
true |
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 |
Excel recognizes the following as text: 401AX21, 921-231, 619 321, 883XTY. |
True |
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 |
A requirements document includes a needs statement, source of data, summary of calculations, and any other special requirements for a worksheet. |
true |
You can apply the Bold font style by pressing the ____ keyboard shortcut keys. |
ctrl+B |
Worksheet titles and subtitles should be as wordy as possible. |
False |
The range of cells receiving the content of copied cells is called the ____. |
destination area |
The ____ button allows you to erase recent cell entries. |
undo |
Pressing the ____ keyboard shortcut key(s) selects cell A1. |
CTRL+HOME |
You can enter the correct range in a function by typing the beginning and ending cell references separated by a ____. |
colon: |
Which of the following keys toggles between Insert mode and Overtype mode? |
insert |
Which of the following keys moves the insertion point to the end of data in a cell? |
End |
What effect does the Accounting Number Format have on the selected cells? |
Displays cell contents with two decimal places that align vertically |
____ is/are used to place worksheet, column, and row titles on a worksheet. |
text |
The range of cells receiving copied content is called the ____ area. |
paste |
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 |
Live preview is available on a touch screen. |
false |
You can turn off the Bold formatting for selected text by clicking the Roman button (Home tab | Font group). |
false |
The ____ feature works behind the scenes, fixing common typing or spelling mistakes when you complete a text entry. |
autocorrect |
Excel 1
Share This
Unfinished tasks keep piling up?
Let us complete them for you. Quickly and professionally.
Check Price