36385211
Description
Question 1
Question
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?
Answer
-
cell style
-
range style
-
worksheet style
-
workbook style
Question 2
Question
Which of the following is not an element in an Excel function?
Answer
-
argument
-
function name
-
syntax
-
=
Question 3
Question
What are Excel's default top and bottom margin settings?
Answer
-
0.25
-
0.5
-
0.75
-
1
Question 4
Question
Which of the following does not occur when a label in a cell is longer or wider than the cell?
Answer
-
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.
Question 5
Question
Which of the following is not true when adjusting column width and row height?
Answer
-
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.
Question 6
Question
Which of the following paste options copies all data and formulas from the source cell(s), but not the formatting?
Answer
-
Paste
-
Formulas
-
Formulas & Number Formatting
-
Keep Source Formatting
Question 7
Question
Which of the following characters precedes Excel functions?
Answer
-
+
-
=
-
(
-
-
Question 8
Question
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?
Answer
-
AutoFill
-
AutoComplete
-
AutoFit
-
AutoCorrect
Question 9
Question
Which of the following displays in a cell when you click AutoSum?
Answer
-
=SUM()
-
=AUTOSUM()
-
=ADD()
-
=AUTOADD()
Question 10
Question
Which of the following paste options copies all data and formatting?
Answer
-
Merge Conditional Formatting
-
Match Destination Formatting
-
Formulas & Number Formatting
-
Keep Source Formatting
Question 11
Question
Which of the following is the default paste option?
Answer
-
Paste
-
Merge Conditional Formatting
-
Formulas & Number Formatting
-
Match Destination Formatting
Question 12
Question
Which of the following Spelling dialog box options skips all occurrences of the same spelling of a label?
Answer
-
Ignore Once
-
Ignore All
-
Change
-
Change All
Question 13
Question
Which of the following views displays printed pages with dashed or dotted lines to mark where new pages start?
Answer
-
Normal view
-
Page Layout view
-
Page Break Preview
-
Full Screen view
Question 14
Question
Which of the following does not describe a print area?
Answer
-
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.
Question 15
Question
In the Excel window, which of the following continuously displays the buttons for switching worksheet views?
Answer
-
Ribbon
-
Scroll bar
-
Status bar
-
Shortcut menu
Question 16
Question
Which of the following commands locks rows or columns in view so that you can position data for easy review?
Answer
-
Zoom options
-
Freeze Panes command
-
Status bar view buttons
-
Split command
Question 17
Question
What is selected when you point to and click a column heading?
Answer
-
the entire column
-
the entire row
-
the entire worksheet
-
the 20 cells adjacent to the top of the column
Question 18
Question
Which of the following features combines two or more cells into one cell and centers the data within the combined cell?
Answer
-
AutoFormat
-
AutoFit
-
Merge & Center
-
Wrap Text
Question 19
Question
Which of the following activates edit mode?
Answer
-
Press F2.
-
Press F4.
-
Press F12.
-
Press Enter.
Question 20
Question
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?
Answer
-
the entire column
-
the entire row
-
all worksheet cells
-
a range
0 comments
Want to create your own Quizzes for free with GoConqr? Learn more.