Unit C

Question 1

Format

Answer 1

Determines how the labels and values look – (bold, color, font)

Question 2

Font

Answer 2

Name for a collection of characters.

Question 3

Font size

Answer 3

Physical size of text

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

predesigned 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 $, %, different time formats, etc.)

Question 11

Ctrl Home

Answer 11

Moves cell pointer to A1 (probably Command+1 on Mac.)

Question 12

Accounting options

Answer 12

adds $ and decimal 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 hidden 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 (command on Mac) or drag sheet tab to desired tab location.

Question 20

Clip

Answer 20

individual media file, such as graphic, sound, or movie.

Question 21

Table styles

Answer 21

Makes it easier to format selected worksheet cells as a table – Excel has 60 styles.