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