Unit C Flashcards
Format
Determines how the labels and values look – (bold, color, font)
Font
Name for a collection of characters.
Font size
Physical size of text
Point:
1/72 of an inch – the way characters are measured.
Alignment
Left, right, center, justified
Column heading
box at top of each column containing a letter.
Cell style
predesigned combinations of formatting attributes.
Theme
predesigned set of attributes that gives Excel worksheet a professional look.
Conditional formatting
Where excel automatically applies different formats depending on conditions you specify.
Number format
(allows you to change $, %, different time formats, etc.)
Ctrl Home
Moves cell pointer to A1 (probably Command+1 on Mac.)
Accounting options
adds $ and decimal places.
To delete conditional formatting
select rule in the conditional formatting rules manager dialog box, then delete rule button.
Column width
Sets the width to a specific number of characters.
Auto-fit-column-width
Fits to the widest entry in a column.
Hide and unhide
hides or displays hidden columns.
Default width
resets column to worksheet’s default column width.
Rename a sheet
right click the tab, click rename.
Copy a sheet
Press and hold ctrl (command on Mac) or drag sheet tab to desired tab location.
Clip
individual media file, such as graphic, sound, or movie.
Table styles
Makes it easier to format selected worksheet cells as a table – Excel has 60 styles.
