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 |
Which of the following steps is a method for hiding a single worksheet in a multi sheet workbook?
Which of the following steps is a method for hiding a single worksheet in a multi-sheet workbook? On the View tab, in the Window group, click Hide.
Which sequence of steps will allow you to change the color of a worksheet tab?
To change the color of a sheet tab, right-click the tab, point to Tab Color and pick a color that you want. Tip: Click away from the formatted tab to see the new tab color. If you want to remove the color, right-click the tab, point to Tab Color, and pick No Color.
How do you access the tab color option to change the color of a worksheet tab quizlet?
How do you change the color of a worksheet tab? Right-click the tab and select Tab Color.
Which tab of the ribbon contains commands to change the color of cells?
Click Home > Format Cells dialog launcher, or press Ctrl+Shift+F. On the Fill tab, under Background Color, pick the color you want.