Quiz
Excel 1
Create a free account to finish this quiz
Save your progress and see your final score.
Already have an account? Sign in
Questions in this quiz (20)
1Which of the following is a set of formatting elements that includes font style, size, color, alignment, borders, and fill, as well as number formats?
- Acell style
- Brange style
- Cworksheet style
- Dworkbook style
2Which of the following is not an element in an Excel function?
- Aargument
- Bfunction name
- Csyntax
- D=
3What are Excel's default top and bottom margin settings?
- A0.25
- B0.5
- C0.75
- D1
4Which of the following does not occur when a label in a cell is longer or wider than the cell?
- AThe label spills into an empty adjacent cell.
- BAn error message displays.
- CIf adjacent cells are not empty, the label is truncated.
- DThe Formula bar displays the entire entry regardless of length.
5Which of the following is not true when adjusting column width and row height?
- AThe default width for a column in a worksheet using the Office theme is 8.43 characters in the default font.
- BThe default height of each row is 25 points.
- CChange 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.
- DYou can adjust one or more columns or rows at the same time.
6Which of the following paste options copies all data and formulas from the source cell(s), but not the formatting?
- APaste
- BFormulas
- CFormulas & Number Formatting
- DKeep Source Formatting
7Which of the following characters precedes Excel functions?
- A+
- B=
- C(
- D-
8Which 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?
- AAutoFill
- BAutoComplete
- CAutoFit
- DAutoCorrect
9Which of the following displays in a cell when you click AutoSum?
- A=SUM()
- B=AUTOSUM()
- C=ADD()
- D=AUTOADD()
10Which of the following paste options copies all data and formatting?
- AMerge Conditional Formatting
- BMatch Destination Formatting
- CFormulas & Number Formatting
- DKeep Source Formatting
11Which of the following is the default paste option?
- APaste
- BMerge Conditional Formatting
- CFormulas & Number Formatting
- DMatch Destination Formatting
12Which of the following Spelling dialog box options skips all occurrences of the same spelling of a label?
- AIgnore Once
- BIgnore All
- CChange
- DChange All
13Which of the following views displays printed pages with dashed or dotted lines to mark where new pages start?
- ANormal view
- BPage Layout view
- CPage Break Preview
- DFull Screen view
14Which of the following does not describe a print area?
- AYou can select nonadjacent ranges to print on one page.
- BA print area is the data that prints from a Print command.
- CThe default print area is the entire worksheet.
- DA print area is saved with the worksheet.
15In the Excel window, which of the following continuously displays the buttons for switching worksheet views?
- ARibbon
- BScroll bar
- CStatus bar
- DShortcut menu
16Which of the following commands locks rows or columns in view so that you can position data for easy review?
- AZoom options
- BFreeze Panes command
- CStatus bar view buttons
- DSplit command
17What is selected when you point to and click a column heading?
- Athe entire column
- Bthe entire row
- Cthe entire worksheet
- Dthe 20 cells adjacent to the top of the column
18Which of the following features combines two or more cells into one cell and centers the data within the combined cell?
- AAutoFormat
- BAutoFit
- CMerge & Center
- DWrap Text
19Which of the following activates edit mode?
- APress F2.
- BPress F4.
- CPress F12.
- DPress Enter.
20What is selected when you click the Select All button located above the row 1 heading and to the left of the column A heading?
- Athe entire column
- Bthe entire row
- Call worksheet cells
- Da range
Information
- Description
- Excel 1 final review
- Author
- Holly Harper
- Language
- English
- Views
- 25
- Tags
- Rating
- No ratings yet Rate this quiz