Unit C Flashcards
(21 cards)
Format
Determine how the labels and values look (bold, color, font)
Font
a name for a collection of characters
font size
physical size of letters
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
predefined set of attributes that gives excel worksheet a professional l look
Conditional formatting
Where excel automatically applies different formats depending on conditions you specify
Number format
allows you to change a $, %, different time format
ctrl home
moves cell pointer to A1
Accounting option
adds $ and decimal places
To detete conditional formatting
Select rule in the conditional formatting rules manager dialog box then delete rule button
column width
sets the width to specific number of characters
Autofit column width
fits to the widest entry in column
hide and unhide
hides or displays hidden column
default width
resets column to worksheets default column width
Rename a sheet
right click the tab, click rename
Copy a sheet
press and hold ctrl drag sheet tab to desired tab location
Clip
individual media file such as a graphic sound or movie
Table styles
makes it easy to format selected worksheet cells as a table - Excel has 60 styles