Excel Chapter 1 Study Guide
How many chart types does Excel offer?
10
The characters that Excel displays on the screen are a specific ____.
ALL
You use ____ to view an XPS file.
XPS Viewer
Combining two or more selected cells into one cell is called ____ cells.
merging
Excel remembers the last ____ actions you have completed.
100
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
The ____ feature works behind the scenes, fixing common typing or spelling mistakes when you complete a text entry.
AutoCorrect
You can apply the Bold font style by pressing the ____ keyboard shortcut keys.
CTRL+B
Pressing the ____ keyboard shortcut key(s) selects cell A1.
CTRL+HOME
What effect does the Comma Style format have on the selected cells?
Displays cell contents with 2 decimal
What effect does the Accounting Number Format have on the selected cells?
Displays cell contents with two decimal places that align vertically
To erase an entire entry in a cell and then reenter the data from the beginning, press the ____ key.
ESC
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
A single point is about 1/32 of one inch in height.
FALSE
In a worksheet, columns typically contain information that is similar to a list. _________________________
FALSE
Live preview is available on a touch screen.
FALSE
The Top status bar command is used to display the highest value in the selected range in the AutoCalculate area. _________________________
FALSE
To clear the entire worksheet, tap or click the Clear All button on the worksheet.
FALSE
When entering dollar values in cells, you also must type the dollar sign ($), commas, and any trailing zeros.
FALSE
When you tap or click the Enter box to complete an entry in a cell, the active cell moves down to the next cell in the same column.
FALSE
You should press the SPACEBAR to clear a cell.
FALSE
If you wish to sign out of your Microsoft account, tap or click ____ on the ribbon to open the Backstage view and then tap or click the Account tab to display the Account gallery, and tap or click the Sign out link.
FILE
Which of the following keys moves the insertion point to the beginning of data in a cell?
HOME
Which of the following keys toggles between Insert mode and Overtype mode?
INSERT
The ____ is a blinking vertical line that indicates where the next typed character will appear.
Insertion Point
Pressing the ____ key to complete an entry activates the adjacent cell to the right.
Right Arrow
____ properties are associated with all Microsoft Office files and include author, title, and subject.
Standard
A character with a point size of 10 is about 10/72 of one inch in height.
TRUE
Excel recognizes the following as text: 401AX21, 921-231, 619 321, 883XTY.
TRUE
If you accidentally undo an action, you can use the Redo button to redo it. _________________________
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
The AutoCorrect feature can automatically capitalize the first letter in the names of days.
TRUE
The group of adjacent cells beginning with B4 and ending with B8, written as B4:B8, is called a(n) range. _________________________
TRUE
The opposite of merging cells is splitting a merged cell. _________________________
TRUE
With Excel in Edit mode, you can edit cell contents directly in the cell.
TRUE
You can clear cell contents and formatting by tapping or clicking Clear Contents on the Clear button menu.
TRUE
You can press the RIGHT ARROW or LEFT ARROW keys to position the insertion point during in-cell editing.
TRUE
The ____ button allows you to erase recent cell entries.
Undo
____ is an electronic image format, sometimes called a fixed format.
XPS, PDF
The date you change a file is an example of a(n) ____ property.
automatically updated
To enter data in a cell, you must first select the ____.
cell
The range of cells receiving the content of copied cells is called the ____.
destination area
The ____ preceding a formula alerts Excel that you are entering a formula or function and not text.
equal sign (=)
A ____ is information that exists on a physical medium such as paper.
hard copy, printout
By default, text is ____ in a cell.
left-aligned
The range of cells receiving copied content is called the ____ area.
paste
If you have multiple Excel workbooks open, to close all open workbooks and exit Excel, ____.
press and hold the Excel app button on the taskbar and then tap 'Close all windows' on the shortcut menu
You can insert a function in a cell by ____.
tapping, clicking
An Excel ____ allows data to be summarized and charted easily.
worksheet
