Which of the following is a set of formatting elements that includes font style, size, color, alignment, borders, and fill, as well as number formats?
cell style
range style
worksheet style
workbook style
Which of the following is not an element in an Excel function?
argument
function name
syntax
=
What are Excel's default top and bottom margin settings?
0.25
0.5
0.75
1
Which of the following does not occur when a label in a cell is longer or wider than the cell?
The label spills into an empty adjacent cell.
An error message displays.
If adjacent cells are not empty, the label is truncated.
The Formula bar displays the entire entry regardless of length.
Which of the following is not true when adjusting column width and row height?
The default width for a column in a worksheet using the Office theme is 8.43 characters in the default font.
The default height of each row is 25 points.
Change the column width or row height by dragging the border between column or row headings, by using the context menu, or by selecting a command from the Format button.
You can adjust one or more columns or rows at the same time.
Which of the following paste options copies all data and formulas from the source cell(s), but not the formatting?
Paste
Formulas
Formulas & Number Formatting
Keep Source Formatting
Which of the following characters precedes Excel functions?
+
(
-
Which of the following features displays a suggested label in a column when the first character or two that you type matches a label already in the column?
AutoFill
AutoComplete
AutoFit
AutoCorrect
Which of the following displays in a cell when you click AutoSum?
=SUM()
=AUTOSUM()
=ADD()
=AUTOADD()
Which of the following paste options copies all data and formatting?
Merge Conditional Formatting
Match Destination Formatting
Which of the following is the default paste option?
Which of the following Spelling dialog box options skips all occurrences of the same spelling of a label?
Ignore Once
Ignore All
Change
Change All
Which of the following views displays printed pages with dashed or dotted lines to mark where new pages start?
Normal view
Page Layout view
Page Break Preview
Full Screen view
Which of the following does not describe a print area?
You can select nonadjacent ranges to print on one page.
A print area is the data that prints from a Print command.
The default print area is the entire worksheet.
A print area is saved with the worksheet.
In the Excel window, which of the following continuously displays the buttons for switching worksheet views?
Ribbon
Scroll bar
Status bar
Shortcut menu
Which of the following commands locks rows or columns in view so that you can position data for easy review?
Zoom options
Freeze Panes command
Status bar view buttons
Split command
What is selected when you point to and click a column heading?
the entire column
the entire row
the entire worksheet
the 20 cells adjacent to the top of the column
Which of the following features combines two or more cells into one cell and centers the data within the combined cell?
AutoFormat
Merge & Center
Wrap Text
Which of the following activates edit mode?
Press F2.
Press F4.
Press F12.
Press Enter.
What is selected when you click the Select All button located above the row 1 heading and to the left of the column A heading?
all worksheet cells
a range
