Shared Flashcard Set

Details

Excel 2007-Chapter 3 Notes
Formatting an excel worksheet
26
Other
11th Grade
04/03/2009

Additional Other Flashcards

 


 

Cards

Term
Hint
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
Column Width
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
Change Row Height
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
Hint
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
Insert
Definition
When you insert rows in a worksheet, all references affected by the insertion are automatically adjusted.
Term
Insert Rows
Definition
click insert button OR 1. click insert button arrow. 2. click insert sheet rows at drop-down list.
Term
Entire Column
Definition
Clicking this will insert an entire column immediately to the left of the active cell.
Term
Insert Sheet Columns
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
Hint
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
Clear Contents
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
Clear Formats
Definition
To clear Formats option to remove formatting from cells or selected cells while leaving data.
Term
Clear all
Definition
Option is used to clear the contents of the cell or selected cells as well as the formating.
Term
Font Group
Definition
Use buttons in teh font group to apply formating to cells or data in cells
Term
Border
Definition
You can insert a border on any or all sides of the active cell or any or all sides of selected cells.
Term
Fill Color
Definition
To insert color in the active cell or in selected cells.
Term
Font Color
Definition
You can change the color of text within a cell.
Term
Merge & Center
Definition
Click this to merge selected cells and center data within the merged cells.
Term
Orientation
Definition
Click Orientation to rotate data in a cell
Term
Wrap Text
Definition
If you want data to remain in a cell and wrap to the next line within the same cell
Term
Hint
Definition
Click the zoom percentatge at the left side of the zoom slider bar to display the zoom dialog box.
Term
Hint
Definition
Apply a theme to give your worksheet a professional look
Term
Accounting number format
Definition
click this to add a dollar sign followed by two decimal digits
Term
Hint
Definition
Set the column width to zero and the column is hidden. Set the row height to zero and the row is hidden
Term
Percent Style
Definition
it right aligns the number
Term
Comma style
Definition
Add commas if necessary and a decimal point followed by two decimal digits if none are typed
Term
Increase Decimal
Definition
Increase number of decimal places displayed after a decimal poin in selected cells
Supporting users have an ad free experience!