Excel: Lesson 7 Practice Test
Which of the following codes is inserted in the header and footer elements group, using the picture button, to include a watermark in a printed worksheet?
& [Picture]
What is the default row height?
15
What is the default column width?
8.43
To insert a new row, select the row or a cell in the row ________ the one where tou want the bew row to display.
Below
You can create your own customized theme by changing which of the following?
Colors, effects, and fonts
In order to save time, you can use one of be predefined headers and footers found on which tab?
Data
To delete a row, select the row heading on the Home tab in the cells group, click the __________ button arrow, and select Delete Sheet Rows.
Delete
Which tab is a contextual tab which displays additional header and Forster formatting options?
Design
Click the ___________ in the Sheet Options group to open the Page Setup Dialog box.
Dialog box launcher
Colors, fonts, and effects are available when working with ____________.
Document themes
In order to quickly AutoFit entries in all rows on a worksheet, ____________ one of the row boundaries after clicking the Select All icon in the upper left corner of your worksheet.
Double click
In order to unhide information, which line(s) in the row or column heading do you double click?
Double lines
In order to let Excel automatically adjust the width to fit the contents, what can you use on the boundary line between rows or columns?
Double-Click
Use ___________ in the Themes group to enhance charts, shapes, SmartArt, or similar graphics.
Effects
Document themes are used to apply sets of styles to an...
Entire document
_____________ are lines of text that display at the bottom of each printed page.
Footer
In order to change height and width settings of cells, click the _________ commands in the cells group on the Home tab.
Format
Use the ________________ to copy the width of one column to other columns.
Format painter
What line color indicates hidden content on a spreadsheet?
Green
_______________ are lines that display around worksheet cells.
Grid lines
A ____________ is text that displays at the top of each printed worksheet.
Header
Use the ___________ command to make sensitive or extraneous data invisible.
Hide
When you wish to reduce the visibility of unwanted rows or columns in a spreadsheet, what option from the shortcut menu can you use?
Hide
In order to unhide columns or rows, select the hidden row or column header on the ___________ tab, click the Format button arrow, point to Hide and Unhide, and select the Unhide option.
Home
The Transpose command is found in the Paste Special dialog box in the Clipboard group on which tab?
Home
Which of the following best describes the definition of column width?
Left-to-right measurement of a column
A column heading is identified by which of the following?
Letter
You can manually resize rows or columns by dragging the boundary, which is the ___________ between rows and columns.
Line
A row heading is identified by which of the following?
Number
In order to ensure that grid lines display in the printed worksheet, select the Print checkbox in the Page Setup group on which tab?
Page layout
In order to quickly format your worksheet, select any cell within the active worksheet and choose a desired theme on which tab?
Page layout
To preview a header and/or footer prior to printing, use Print Preview and _______________ view.
Page layout
To remove a background image, click Delete Background in the Page Setup group on which tab?
Page layout
_________________ allows you to see what your document will look like before sending it to the printer.
Print preview
Use the ____________ button on the Page Layout tab to repeat heading rows at the top of spreadsheets spanning more than one printed page.
Print titles
In order to return all theme color elements to their original colors, which button in the Create New Theme Colors dialog box do you click?
Reset
Newly inserted columns are inserted to the __________ of the selected cell or column.
Right
Select the column, __________ the selection, and select Column Width from the shortcut menu to access the column width dialog box.
Right click
Click the ________________ to apply formatting to the entire row.
Row heading
Which of the following elements are displayed by default but do not print automatically?
Row headings, column headings, and grid lines
Effects within the Theme group include which of the following?
Shadows and bevels
In order to add a header or footer to your worksheet, you click the header and footer button on the Insert tab in which group?
Text
Which of the following applies to the use of customized themes?
They are available in all Office 2013 documents
Which of the following best describes the definition of row height?
Top-to-bottom measurement of a row
Which of the following is used to change the orientation of row or column data in Excel?
Transpose
A _______________ is text or a picture that displays behind a document and can be printed (unlike a background).
Watermark
_____________ is the empty are of a spreadsheet, in which no content displays .
White space
