| A | B |
|---|
| To insert a new row, select the row or a cell in the row __________ the one where you want the new row to display | below |
| Newly inserted columns are inserted to the __________ of the selected cell or column. | left |
| A row heading is identified by which of the following? | number |
| A column heading is identified by which of the following? | letter |
| 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 |
| In order to change height and width settings of cells, click the __________ commands in the cells group on the Home tab. | Format |
| You can manually resize rows or columns by dragging the boundary, which is the __________ between rows and columns. | line |
| 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 |
| Select the column, __________ the selection, and select Column Width from the shortcut menu to access the column width dialog box. | right-click |
| What is the default row height? | 15 |
| What is the default column width? | 8.43 |
| Which of the following best describes the definition of row height? | top-to-bottom measurement of a row |
| Which of the following best describes the definition of column width? | left-to-right measurement of a column |
| In order to quickly AutoFit the 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 |
| Use the __________ to copy the width of one column to other columns. | Format Painter |
| __________ is the empty area of a spreadsheet, in which no content displays. | White space |
| Click the __________ to apply formatting to the entire row. | row heading |
| 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 |
| What line color indicates hidden content on a spreadsheet? | green |
| 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 & Unhide, and select the Unhide option. | Home |
| In order to unhide information, which line(s) in the row or column heading do you double-click? | double lines |
| Use the __________ command to make sensitive or extraneous data invisible. | Hide |
| Which of the following is used to change the orientation of row or column data in Excel? | Transpose |
| The Transpose command is found in the Paste Special dialog box in the Clipboard group on which tab? | Home |
| Colors, fonts, and effects are available when working with __________. | document themes |
| In order to quickly format your worksheet, select any cell within the active worksheet and choose a desired theme on which tab? | Page Layout |
| Effects within the Theme group include which of the following? | shadows & bevels |
| Document themes are used to apply sets of styles to a/an __________. | entire document |
| 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 |
| You can create your own customized theme by changing which of the following? | colors, effects, & fonts |
| Which of the following applies to the use of customized themes? | They are available in all Office 2013 documents. |
| Use __________ in the Themes group to enhance charts, shapes, SmartArt, or similar graphics. | Effects |
| __________ are lines that display around worksheet cells. | Gridlines |
| Which of the following elements are displayed by default but do not print automatically? | row headings, column headings & Gridlines |
| To remove a background image, click Delete Background in the Page Setup group on which tab? | Page Layout |
| In order to ensure that gridlines display in the printed worksheet, select the Print checkbox in the Sheet Options group on which tab? | Page Layout |
| __________ allows you to see what your document will look like before sending it to the printer. | Print Preview |
| Click the __________ in the Sheet Options group to open the Page Setup dialog box. | Dialog box launcher |
| A __________ is text that displays at the top of each printed worksheet. | header |
| __________ are lines of text that display at the bottom of each printed page. | Footers |
| To preview a header and/or a footer prior to printing, use Print Preview and __________ view. | Page Layout |
| In order to add a header or footer to your worksheet, you click the Header & Footer button on the Insert tab in which group | Text |
| Which tab is a contextual tab which displays additional Header & Footer formatting options? | Design |
| In order to save time, you can use one of the predefined headers and footers found on which tab? | Data |
| A __________ is text or a picture that displays behind a document and can be printed (unlike a background). | watermark |
| Which of the following codes is inserted in the Header & Footer Elements group, using the picture button, to include a watermark in a printed worksheet? | &[Picture] |
| 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 |
| A ___________ is a divider that breaks a large worksheet into separate pages for printing. | page break |
| Use the __________ window to quickly adjust page breaks to your specification. | Page Break Preview |
| In order to see how the printed document will be split among pages, select Page Break Preview on which tab? | View |
| __________ can be modified to optimize the white space on a printed worksheet. | Margins |
| Which best describes the orientation of a worksheet? | It prints either vertically or horizontally |
| What is used to shrink or stretch a document to print on a single page? | Scaling |
| In which group on the Page Layout tab will you find the options necessary to change the scaling of a printed worksheet? | Page Setup |
