Term
|
Definition
| To 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
| Type the number representing the average numbber of characters in the standard font that you want to fit in the column, then press Enter or Click OK. |
|
|
Term
|
Definition
Drag row boundary line Or.
1. click format button. 2. click row height at drop-down list. 3. type desired height then click OK |
|
|
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
| click insert button OR 1. click insert button arrow. 2. click insert sheet rows at drop-down list. |
|
|
Term
|
Definition
| Clicking this will insert an entire column immediately to the left of the active cell. |
|
|
Term
|
Definition
| If you want to insert more than one column, select the number of columns in the worksheet that you want inserted, click the insert button arrow and then click insert sheet columns. |
|
|
Term
|
Definition
| Display the Delete dialog box by positoning the cell pointer in the worksheet, clicking the right mouse button, and then clicking delete at the shortcut menu. |
|
|
Term
|
Definition
| If you want to delete cell contents but not the cell, make the cell active or select desired cells and the press the Delete key. |
|
|
Term
|
Definition
| To clear Formats option to remove formatting from cells or selected cells while leaving data. |
|
|
Term
|
Definition
| Option is used to clear the contents of the cell or selected cells as well as the formating. |
|
|
Term
|
Definition
| Use buttons in teh font group to apply formating to cells or data in cells |
|
|
Term
|
Definition
| You can insert a border on any or all sides of the active cell or any or all sides of selected cells. |
|
|
Term
|
Definition
| To insert color in the active cell or in selected cells. |
|
|
Term
|
Definition
| You can change the color of text within a cell. |
|
|
Term
|
Definition
| Click this to merge selected cells and center data within the merged cells. |
|
|
Term
|
Definition
| Click Orientation to rotate data in a cell |
|
|
Term
|
Definition
| If you want data to remain in a cell and wrap to the next line within the same cell |
|
|
Term
|
Definition
| Click the zoom percentatge at the left side of the zoom slider bar to display the zoom dialog box. |
|
|
Term
|
Definition
| Apply a theme to give your worksheet a professional look |
|
|
Term
|
Definition
| click this to add a dollar sign followed by two decimal digits |
|
|
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
| it right aligns the number |
|
|
Term
|
Definition
| Add commas if necessary and a decimal point followed by two decimal digits if none are typed |
|
|
Term
|
Definition
| Increase number of decimal places displayed after a decimal poin in selected cells |
|
|
