Term
|
Definition
| the appearance of a worksheet on the screen and how it looks when printed |
|
|
Term
|
Definition
| To change the width of all colums in a worksheet, click the Select All button and then drag a column boundary to the desired postion |
|
|
Term
|
Definition
| To change the column width you drag column boundary line. or Double-click column boundary. or Click format button.Click Column Width at drop-down list. Type desired width. Click OK. |
|
|
Term
|
Definition
| Change Row 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 Row by Clicking insert Button OR click Insert Button arrow Click Insert Sheet Rows at drop-down list. OR Click Insert button arrow. click insert Cells. Click Entire row in dialog box. Click OK. |
|
|
Term
|
Definition
| Insert Column by Clicking insert button. OR Click Insert button arrow. Click Insert Sheet Columns at drop-down list. OR Click Insert Button arrow. Click insert cells. Click entire column. Click OK. |
|
|
Term
|
Definition
| Display the Delete dialog by positioning the cell pointer in the worksheet, clicking the right mouse button, and then clicking Delete at the shortcut menu. |
|
|
Term
|
Definition
| Clear the Data in Cells by selected desired cells,press Delete key. OR select desired cells,Click clear button, then click Clear Contents at the drop-down list. |
|
|
Term
|
Definition
| you type in the number representing the avg. number of characters in the standard font that you want to fit the column. |
|
|
Term
|
Definition
|
|
Term
|
Definition
| another method for inserting a row |
|
|
Term
|
Definition
| inserts row above the active cell |
|
|
Term
|
Definition
| if you want to insert more tham=n one columnselect the number of columns in the worksheet that you want inserted, click the insert button arrow then click this button |
|
|
Term
|
Definition
| inserts an entire column immediately to the left of the active cell |
|
|
Term
|
Definition
| displys delete dialog box |
|
|
Term
|
Definition
| a quick method for clearing contents of a cell to riht click cell and then click this |
|
|
Term
|
Definition
|
|
Term
|
Definition
| removes formatting from cells or selected cells while leaving the data |
|
|
Term
|
Definition
| clears the contents of the cell or selected cells as well as the formatting |
|
|
Term
|
Definition
| located in the orientation button in the Alignment group |
|
|
Term
|
Definition
| viewing a worksheet before printing |
|
|
Term
|
Definition
| to preview a worksheet you click the office button then point to print then click print preview |
|
|
Term
|
Definition
| Has margin boundary lines display around the worksheet |
|
|
Term
|
Definition
| Click the zoom percentage at the left side of the Zoom slider bar to display the Zoom dialog box |
|
|
Term
|
Definition
| displays the workshet with the theme formatting applied |
|
|
Term
|
Definition
| Apply a theme to give your worksheet a professional look. |
|
|
Term
|
Definition
| where yo choose the categories |
|
|
Term
|
Definition
| shows the points on a arc |
|
|
Term
|
Definition
|
|
Term
| Wrap text in Text Control |
|
Definition
| If you want data to remain in a cell and wrap to the next line within the same cell to fit option to reduce the size of the text fons so all selected data fits |
|
|
Term
|
Definition
| option to combine two or more selected cells |
|
|
Term
|
Definition
| Format with format painter you select cells with desired formatting then double-click formatting double-click Format Painter button then select cells then click format painter button |
|
|
Term
|
Definition
| you cna have a row(s) or column(s) hidden |
|
|
Term
|
Definition
Hide columns by selecting them click the format button, point to hide & unhide.
To hide rows you select them, click format button, point to hide and unhide, then click hide rows |
|
|
