Chapter 3: Excel

Question 1

Dragging the sizing handle activates the Autofill features and recognizes the cell entry as one that can be incremented.

Answer 1

True

Question 2

A sparkline is a miniature chart contained in a single cell.

Answer 2

False

Question 3

To create two horizontal panes with the left pane frozen, move the cell selector in the top row of the window and select the column to the rightr of where you want the split to appear.

Answer 3

True

Question 4

Dragging the sizing handle activates the Autofill features and recognizes the cell entry as one that can be incremented.

Answer 4

False

Question 5

Icon Sets conditional formatting applies a two- or three-color graduated scale to compare values in a range.

Answer 5

False

Question 6

You can freeze the information in the top and right panes of a window only.

Answer 6

False

Question 7

The Trace Errors formula auditing command outlines the cell causing the error with a colored border.

Answer 7

False

Question 8

A relative reference is a cell or range reference in a formula whose location does not change when the formula is copied.

Answer 8

False

Question 9

B$7 is an absolute reference

Answer 9

False

Question 10

What-if analysis varies the value in the cell you specify until a formula that is dependent on that cell returns the desired result.

Answer 10

False

Question 11

A worksheet window can be divided into __________, either horizontal or vertical, through which different areas of the worksheet can be viewed at the same time

Answer 11

Panes

Question 12

A technique used to evaluate what effect changing one or mroe values in formulas has on other values in the worksheet is called __________.

Answer 12

What-If Analysis

Question 13

A $ character in front of either the column or the row reference in a formula creates a(n) _________ reference.

Answer 13

Absolute

Question 14

A(n) _____ reference is created when the reference is to the same cell or range on multiple sheets in the same workbook.

Answer 14

3-D

Question 15

The __________ feature logically repeats and extends a series.

Answer 15

AutoFill

Question 16

_____________ formatting changes the appearance of a range of cells based on a set of conditions you specify.

Answer 16

Conditional Formatting

Question 17

Use a(n) __________ to show the incremental chagne in data over time in one cell.

Answer 17

Sparkline

Question 18

_____________ consist of the name of the sheet enclosed in quotes, and are separated from the cell reference by an explanation point.

Answer 18

Sheet Reference

Question 19

When specified rows and coluns are _____________, they are fixed when you scroll.

Answer 19

Frozen

Question 20

The ___________ tool is used to find the vlaue needed in one cell to attain a result you want in another cell.

Answer 20

Goal Seek

Question 21

A formula that contains references to cells in other sheets of a workbook is a(n) ________.

Answer 21

3-D Reference

Question 22

The number 32534 displayed with the Currency style would appear as ________ in a cell.

Answer 22

$32,534.00

Question 23

The _________ error value indicates that the wrong type of argument or operand was used.

Answer 23

VALUE

Question 24

The ________ function key will change a selected cell reference to absolute.

Answer 24

F4

Question 25

Which of the following is NOT a valid sheet name?

Answer 25

3/12/12

Question 26

The ________ feature enters a series of headings by logically repeating and extending the series.

Answer 26

AutoFill

Question 27

The cell reference that will adjust row 8 without adjusting column E when it is copied is

Answer 27

$E8

Question 28

A cell or range reference in a formula whose location does not change when the formula is copied is a(n) _________.

Answer 28

Absolute Reference

Question 29

The information in the worksheet can be _______ in the top and left panes of a window only.

Answer 29

Frozen

Question 30

_________ is used to evaluate the effects of changing selected factors in a worksheet.

Answer 30

What-If Analysis

Question 31

A division of the worksheet window that allows different areas of the worksheet to be viewed at the same time is called a _________.

Answer 31

Pane