Excel Ch 2

Question 1

Cut

Answer 1

command that removes the selected text or object from the file and places it on the Office Clipboard for later use.

Question 2

Copy

Answer 2

Command that places a duplicate of the selected text or object on the Clipboard without changing the file

Question 3

Paste

Answer 3

Command that is used to insert text or an object from the Clipboard into a file.

Question 4

Undo

Answer 4

Reverses the last action performed.

Question 5

Redo

Answer 5

Reverses the Undo command and restores the file to its previous state.

Question 6

Alignment

Answer 6

Refers to how text and numbers are positioned within the cell both horizontally and vertically.

Question 7

General horizontal alignment

Answer 7

Default alignment of cells. When cells are formatted using the General horizontal alignment, Excel detects the type of content in the cell. Cells that contain text are aligned to the left, and cells that contain numbers are aligned to the right.

Question 8

Font

Answer 8

Refers to a set of characters of a certain design. the font is the shape of the character or number as it appears on screen.

Question 9

Fill color

Answer 9

Solid color that shades a cell.

Question 10

Cell style

Answer 10

A combination of effects that can be applied at one time. Styles can include formatting such as borders, fill color, font size, and number formatting.

Question 11

Format Painter

Answer 11

Tool that copies and pastes formatting styles.

Question 12

Conditional formatting

Answer 12

Provides a visual analysis of data by applying formatting to cells that meet specific criteria (conditions)

Question 13

Data bars

Answer 13

A conditional formatting style in Excel that displays a color bar (gradient or solid) representing the cell value in comparison to other values (cells with higher values have longer data bars).

Question 14

Color scales

Answer 14

A conditional formatting style in Excel that colors cells according to one of the color scales (e.g. red to green [bad/low to good/high] or blue to red [cold/low to hot/high]).

Question 15

Icon sets

Answer 15

Conditional formatting style in Excel that displays a graphic in each cell representing the cell value in relation to other values.

Question 16

Highlight Cells Rules

Answer 16

A conditional formatting style in Excel that allows you to define formatting for cells that meet specific numerical or text criteria (e.g., greater than a specific value or containing a specific text string).

Question 17

Top/Bottom Rules

Answer 17

Excel conditional formatting style that automatically finds and highlights the highest and lowest values or values that are above or below the average in the specified range of cells.

Question 18

Find

Answer 18

Command that locates specific text, data, or formatting in a spreadsheet.

Question 19

Replace

Answer 19

Used with the Find command to replace specified data or formatting in a file with new data or formatting.

Question 20

Print Area

Answer 20

A range of cells that you designate as the default print selection.