UNIT C EXCEL

Question 1

Format

Answer 1

determines how the labels and values look

Question 2

Font

Answer 2

name for a collection of characters

Question 3

Font size

Answer 3

physical size of the letters

Question 4

Point

Answer 4

1/72 of an inch-the way characters are measured

Question 5

Alignment

Answer 5

left, right, center, justified

Question 6

Column heading

Answer 6

box at top of each column containing a letter

Question 7

Cell style

Answer 7

predesigned combinations of formatting attributes

Question 8

Theme

Answer 8

predefined set of attributes that gives excel worksheet a professional look

Question 9

Conditional formatting

Answer 9

where excel automatically applies different formats depending on conditions you specify

Question 10

Number format

Answer 10

(allows you to change to $, %, different time formats, ect)

Question 11

Ctrl Home

Answer 11

Moves cell pointer to A1

Question 12

Accounting option

Answer 12

adds $ and decimals places

Question 13

To delete conditional Formatting

Answer 13

select rule in the conditional formatting rules manager dialog box then delete rule button

Question 14

Column width

Answer 14

sets the width to a specific number of characters

Question 15

Auto fit column width

Answer 15

fits to the widest entry in a column

Question 16

Hide and unhide

Answer 16

hides or displays hides columns

Question 17

Default width

Answer 17

resets column to worksheet’s default column width

Question 18

Rename a sheet

Answer 18

right click the tab, click rename

Question 19

Copy a sheet

Answer 19

press and hold ctrl, drag sheet tab to desired location

Question 20

clip

Answer 20

individual media file, such as a graphic, sound oe movie.

Question 21

Table styles

Answer 21

makes it easy to format selected worksheet cells as a table - Excel has 60 styles