Term
|
Definition
| The appearance of a worksheet on the screen and how it looks when printed |
|
|
Term
|
Definition
| the change the width of all columns in a worksheet, click the select all button and then drag a column boundary to the desired position. |
|
|
Term
|
Definition
| position the moust pointer on the blue boundary line between clumns until the mouse pointer turns into a doubleheaded arrow potingleft and right and then drag the boundary to the ritght to increase the size of he to the left to decrease the size |
|
|
Term
|
Definition
| to display, click the format button in the cells group in the home tab and then click column width at the drop down list |
|
|
Term
| quick steps to changing column width |
|
Definition
| drag column boundary liine or double click column boundary or click format, column width, type desired width |
|
|
Term
| quick steps to changing row height |
|
Definition
| drag row boundary line or click format, row height, and type desired height |
|
|
Term
|
Definition
| to change the height of all rows in a worksheet, click the select all button and then drag a row boundary to the desired position. |
|
|
Term
|
Definition
| when you insert rows in a worksheet, all references affected by the insertion are automatically adjusted. |
|
|
Term
|
Definition
| insert a row with the insert button in the cells group in the home tab or with options at the insert dialog box |
|
|
Term
| quick steps to insert rows |
|
Definition
| click insert button, or click insert button arrow, cilck insert sheet rows at drop-down list, or click insert button, insert cells, click entire row, then click ok |
|
|
Term
|
Definition
| make a cell active in the column immediately to the right of where the new column is to be inserted, click the insert button arrow and then click insert sheet columns at the drop-down list. |
|
|
Term
|
Definition
| display the delete dialog box by posiitioning the cell pointer in the worksheet, clicking the right mouse button, and then clicking delete at the shortcut menu. |
|
|
Term
|
Definition
| make the cell active or select desired cells, click clear button in the editing group in the home tab, and then click clear contents at the drop-down list. |
|
|
Term
|
Definition
| Click the office button, point to the print option, and then click the print preview option or press F2 |
|
|
Term
|
Definition
| click the zoom percentage at the left side of the zoom slider bar to display the zoom dialog box |
|
|
Term
|
Definition
| click page layout tab and then click the themes button in the themes group. Position themoust pointer over a theme and the live preview feature will display the worksheet with the theme. |
|
|
Term
|
Definition
| Apply a theme to give your worksheet a professional look. |
|
|
Term
|
Definition
| change the format of numbers with buttons in the numbers group in the home tab or with options at the format cells dialog box with the number tab selected. |
|
|
Term
| Increase & Decrease Decimal |
|
Definition
| increase and decrease decimal in the number group in the home tab. It will only change existing numbers |
|
|
Term
| Format Numbers using the Format Cells Dialog Box |
|
Definition
| you can format numbers with options at the format cells dialog box with the number tab selected. Display the dialog box by clicking the number group dialog box |
|
|
Term
| Aligning and Indenting Data |
|
Definition
| you can align and indent data in cells using buttons in the alighment group in the home tab or with options at the format cells dialog box with the alignment tab selected |
|
|
Term
|
Definition
| you can choose to rotate data. |
|
|
Term
|
Definition
| you can type a degree in the degrees text box to rotate text |
|
|
Term
|
Definition
| if you want data to remain ina cell and wrap to the next line within the same cell click wrap text option in the text control section |
|
|
Term
|
Definition
| use the merge cell option to combine two or more selected cells into a single cell |
|
|
Term
|
Definition
| at the format cells dialog box with the font tab selcted, you can chantge the font, font style, font size, and font color. |
|
|
Term
|
Definition
| select cells, click borders button arrow, click desired border or select cells, click borders button arrow, click more borders, use options dialog box to apply desired border, and click ok |
|
|
Term
|
Definition
| select cells, click fill color button arrow, and click desired border or select cells, click format button, click format cells at the drop-down list, click fill tab, use options in dialog box to apply desired shading, and click ok |
|
|
Term
|
Definition
| apply to formatting, move to desired location and press F4 or ctrl + y |
|
|
Term
| formatting with format painter |
|
Definition
| select cells with desired formatting, double click format painter button, select cells, click format painter button |
|
|
Term
|
Definition
| set the column width to zero and the column is hidden. Set the row height to zero and the row is hidden. |
|
|
Term
|
Definition
| select columns, click format button, point to hide&unhide, and click hide columns |
|
|
Term
|
Definition
| select rows, click format button, point to hide&unhide, click hide rows. |
|
|
