Excel Quiz 1
What are Excel's default top and bottom margin settings?
.75
By default, what file name extension is given to Excel workbook files?
.xlsx
How many items can the Office Clipboard hold?
24
Which of the following characters precedes Excel functions?
=
Which of the following displays in a cell when you click AutoSum?
=SUM()
Which of the following methods inserts a manual line break in a cell?
Alt+Enter
Which of the following features resizes column width or row height to fit the width or height of the longest or tallest entry?
AutoFit
What key do you press to select non-adjacent worksheets?
Ctrl
Which of the following keyboard shortcuts opens the Format Cells dialog box?
Ctrl+1
Which of the following keyboard shortcuts opens a new blank workbook?
Ctrl+N
Which of the following keyboard shortcuts cuts cells or a range?
Ctrl+X,
Which format should you use to save a file if you want it to be compatible with earlier versions of Microsoft Excel?
Excel 97-2003 Workbook
In Excel, which of the following keys opens the Save As dialog box?
F12
Which of the following activates edit mode?
F2
The default paste option is Keep Source Formatting.
FALSE
Which of the following options simplifies the process of entering the months of the year in a worksheet?
Fill Handle
Which of the following options copies formatting attributes and styles from one cell to another cell or range?
Format Painter
Which of the following paste options copies all data and formulas from the source cell(s), but not the formatting?
Formulas
Which of the following statements is not true when hiding rows?
Hiding a row deletes the data from the row
Which of the following Spelling dialog box options skips all occurrences of the same spelling of a label?
Ignore All
Which of the following Page Setup dialog box tabs includes an option to set margins for headers and footers?
Margins
Which of the following Page Setup dialog box tabs are used to change the orientation of a worksheet?
Page
Which of the following is the default paste option?
Paste
Which of the following commands enlarges or shrinks printed data to fit a specific number of pages or a particular paper size?
Scale to Fit
Which of the following Page Setup dialog box tabs are used to identify a Print area other than the entire worksheet?
Sheet
What key do you press to select adjacent worksheets?
Shift
Which of the following keyboard shortcuts inserts a worksheet to the left of the active sheet?
Shift+F11
In the Excel window, which of the following continuously displays the buttons for switching worksheet views?
Status bar
A print area is the data that prints from a print command.
TRUE
Which of the following is not true when inserting and deleting columns?
To insert multiple columns or rows, each column or row is inserted individually
A cell style is a set of formatting elements that includes font style, size, color, alignment, borders, and fill, as well as number formats.
True
In Excel, an indent moves cell contents away from the left edge of the cell.
True
How do you enter a number as a label in a cell?
Type an apostrophe before the number
Which of the following best describes the size of an Excel worksheet?
Type an apostrophe before the number
Which of the following commands displays a label on multiple lines within a cell?
Wrap text
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
By default, how does Excel align labels in a cell?
bottom left of a cell
By default, how does Excel align values in a cell?
bottom right of a cell
Which of the following displays the result of a formula?
cell
Which of the following displays when you place the pointer on the border of a selected cell or range?
move pointer
Which of the following is the name used to describe a rectangular group of cells?
range
Which of the following appears when you move the pointer over a cell?
selection pointer
What is selected when you point to and click a column heading?
the entire column
Before using the Merge & Center command, what cell should contain the data?
upper-left cell of the selection