AB | |
below | |
Newly placed columns are placed to the __________ that the selected cell or column. You are watching: Which tab and group will allow the insertion of rows and columns in a worksheet | left |
A row heading is identified through which of the following? | number |
A column heading is identified whereby of the following? | letter |
To delete a row, select the heat heading ~ above the home tab in the cell group, click the __________ button arrow, and select Delete sheet Rows. | delete |
In stimulate to adjust height and also width setups of cells, click the __________ regulates in the cells team on the residence tab. | Format |
You deserve to manually resize rows or columns by dragging the boundary, i beg your pardon is the __________ in between rows and also columns. | line |
In order to let Excel automatically adjust the broad to right the contents, what deserve to you use on the border line between rows or columns? | double-click |
Select the column, __________ the selection, and select tower Width from the shortcut menu to access the shaft width dialog box. | right-click |
What is the default heat height? | 15 |
What is the default shaft width? | 8.43 |
Which the the following ideal describes the definition of row height? | top-to-bottom measure of a row |
Which the the following ideal describes the an interpretation of shaft width? | left-to-right measure up of a column |
In stimulate to conveniently AutoFit the entries in every rows on a worksheet, __________ among the row limits after clicking the select All icon in the upper left corner of her worksheet. | double-click |
Use the __________ to copy the broad of one pillar to various other columns. | Format Painter |
__________ is the empty area of a spreadsheet, in i m sorry no content displays. | White space |
Click the __________ to apply formatting to the whole row. | row heading |
When you great to mitigate the visibility of undesirable rows or columns in a spreadsheet, what choice from the shortcut menu have the right to you use? | Hide |
What line color indicates concealed content ~ above a spreadsheet? | green |
In order to unhide columns or rows, select the covert row or shaft header on the __________ tab, click the Format button arrow, suggest to Hide & Unhide, and select the Unhide option. | Home |
In order to unhide information, i m sorry line(s) in the heat or column heading do you double-click? | double lines |
Use the __________ command to make sensitive or extraneous data invisible. | Hide |
Which of the complying with is supplied to adjust the orientation of row or tower data in Excel? | Transpose |
The Transpose command is found in the Paste one-of-a-kind dialog box in the Clipboard team on i beg your pardon tab? | Home |
Colors, fonts, and effects are accessible when working through __________. | document themes |
In bespeak to quickly format your worksheet, select any kind of cell within the energetic worksheet and choose a preferred theme on which tab? | Page Layout |
Effects within the theme group incorporate which the the following? | shadows & bevels |
Document themes are offered to use sets of styles to a/an __________. | entire document |
In order come return all template color facets to their original colors, which button in the Create new Theme colors dialog box do you click? | Reset |
You can develop your own customized layout by an altering which that the following? | colors, effects, & fonts |
Which of the following applies to the usage of customized themes? | They are accessible in every Office 2013 documents. |
Use __________ in the Themes team to boost charts, shapes, SmartArt, or similar graphics. | Effects |
__________ are lines the display about worksheet cells. | Gridlines |
Which the the following aspects are presented by default however do not print automatically? | row headings, obelisk headings & Gridlines |
To remove a background image, click Delete lift in the page Setup team on i beg your pardon tab? | Page Layout |
In order to ensure that gridlines display screen in the published worksheet, pick the print checkbox in the Sheet alternatives group on i m sorry tab? | Page Layout |
__________ enables you to view what your paper will look at like prior to sending it to the printer. | Print Preview |
Click the __________ in the Sheet alternatives group to open the page Setup dialog box. | Dialog crate launcher |
A __________ is message that screens at the peak of each published worksheet. | header |
__________ room lines of message that display screen at the bottom of each printed page. | Footers |
To preview a header and/or a footer before printing, use publish Preview and __________ view. | Page Layout |
In bespeak to add a header or footer to your worksheet, girlfriend click the Header & Footer button on the Insert tab in i m sorry group | Text |
Which tab is a contextual tab which displays added Header & Footer formatting options? | Design |
In bespeak to conserve time, you can use among the predefined headers and footers discovered on which tab? | Data |
A __________ is message or a snapshot that screens behind a document and can be published (unlike a background). | watermark |
Which of the following codes is placed in the Header & Footer aspects group, using the photo button, to encompass a watermark in a published worksheet? | & |
Use the __________ button on the web page Layout tab to repeat heading rows in ~ the height of spreadsheets spanning an ext than one printed page. | Print Titles |
A ___________ is a divider that breaks a big worksheet into separate pages because that printing. | page break |
Use the __________ window to quickly adjust page division to her specification. See more: Why Is A Flower’S Stigma Sticky? ? Why Is A Stigma Sticky | Page break Preview |
In order come see exactly how the printed paper will it is in split amongst pages, pick Page break Preview on i m sorry tab? | View |
__________ have the right to be modified come optimize the white an are on a printed worksheet. | Margins |
Which best describes the orientation the a worksheet? | It prints either vertically or horizontally |
What is used to shrink or large a document to publish on a single page? | Scaling |
In which group on the page Layout tab will certainly you uncover the alternatives necessary to adjust the scaling the a published worksheet? | Page Setup |
![]() |