Exam 4: Working With Large Worksheets, Charting, and What-If Analysis

If formulas located in other cells reference cells in a deleted row or column, Excel does not adjust these cell references but instead displays the ____ error message.

(Multiple Choice)

4.9/5

(81)

Question 61

Charts can either be embedded in a worksheet or placed in a separate ____.

(Multiple Choice)

4.8/5

(81)

Question 62

-In the accompanying figure, the split double arrow mouse pointer ____.

(Multiple Choice)

4.9/5

(81)

Question 63

The ____________________ at the bottom of the Fill Color and Font Color buttons changes to the most recently selected color.

(Short Answer)

4.8/5

(78)

Question 64

The path to the Format Painter button is ____.

(Multiple Choice)

4.9/5

(83)

Question 65

When Excel cannot calculate a formula, it displays an error message in a cell.

(True/False)

5.0/5

(80)

Question 66

The Copy button copies the contents and format of the source area to the Office ____, a temporary storage area in the computer's memory.

(Multiple Choice)

4.8/5

(87)

Question 67

If you enter 90 in the Degrees box in the ____ area of the Format Cells dialog box, the text will appear vertically and read from bottom to top in the cell.

(Multiple Choice)

4.7/5

(81)

Question 68

You know Excel is in Copy mode when a small plus sign appears next to the block arrow mouse pointer during a(n) ____________________ operation.

(Short Answer)

5.0/5

(84)

Question 69

You can nest IF functions as deep as you want, but after you get beyond a nest of three IF functions, the logic becomes difficult to follow.

(True/False)

5.0/5

(77)

Question 70

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Indicates a cell is using a name Excel does not recognize.

(Multiple Choice)

4.9/5

(73)

Question 71

Excel includes four types of sparkline charts: line, column, win/loss, and stock.

(True/False)

4.8/5

(72)

Question 72

Which of the following Auto Fill Options menu options is the same as the Fill Series option?

(Multiple Choice)

4.9/5

(69)

Question 73

The ____ function is useful when you want to assign a value to a cell based on a logical test.

(Multiple Choice)

4.8/5

(77)

Question 74

Which of the following is the path to the Increase or Decrease Indent button?

(Multiple Choice)

4.8/5

(76)

Question 75

Excel allows you to ____________________ the titles so that the titles remain on the screen no matter how far down or to the right you scroll.

(Short Answer)

4.9/5

(82)

Question 76

When you change a value on which a chart is dependent, Excel immediately ____________________ the chart.

(Short Answer)

4.8/5

(82)

Question 77

The ____________________ option on the Auto Fill Options menu fills the destination area with contents using the format of the source area and does not create a series.

(Short Answer)

4.9/5

(87)

Question 78

A relative cell reference instructs Excel to adjust the cell reference as it copies it to the destination area.

(True/False)

4.8/5

(68)

Question 79

____ text often provides a strong visual appeal.

(Multiple Choice)

4.7/5

(81)

Question 80

Showing 61 - 80 of 112

If formulas located in other cells reference cells in a deleted row or column, Excel does not adjust these cell references but instead displays the ____ error message.

Charts can either be embedded in a worksheet or placed in a separate ____.

-In the accompanying figure, the split double arrow mouse pointer ____.

The ____________________ at the bottom of the Fill Color and Font Color buttons changes to the most recently selected color.

The path to the Format Painter button is ____.

When Excel cannot calculate a formula, it displays an error message in a cell.

The Copy button copies the contents and format of the source area to the Office ____, a temporary storage area in the computer's memory.

If you enter 90 in the Degrees box in the ____ area of the Format Cells dialog box, the text will appear vertically and read from bottom to top in the cell.

You know Excel is in Copy mode when a small plus sign appears next to the block arrow mouse pointer during a(n) ____________________ operation.

You can nest IF functions as deep as you want, but after you get beyond a nest of three IF functions, the logic becomes difficult to follow.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Indicates a cell is using a name Excel does not recognize.

Excel includes four types of sparkline charts: line, column, win/loss, and stock.

Which of the following Auto Fill Options menu options is the same as the Fill Series option?

The ____ function is useful when you want to assign a value to a cell based on a logical test.

Which of the following is the path to the Increase or Decrease Indent button?

Excel allows you to ____________________ the titles so that the titles remain on the screen no matter how far down or to the right you scroll.

When you change a value on which a chart is dependent, Excel immediately ____________________ the chart.

The ____________________ option on the Auto Fill Options menu fills the destination area with contents using the format of the source area and does not create a series.

A relative cell reference instructs Excel to adjust the cell reference as it copies it to the destination area.

____ text often provides a strong visual appeal.

Essential Concepts and Skills

Creating a Worksheet and a Chart

Formulas, Functions, and Formatting

Working With Multiple Worksheets and Workbooks

Financial Functions, Data Tables, and Amortization Schedules

Creating, Sorting, and Querying a Table

Creating Templates, Manipulating Data, and Adding Additional Enhancements to a Worksheet

Working With Trendlines, Pivot Table Reports, Pivotchart Reports, and Slicers

Formula Auditing, Data Validation, and Complex Problem Solving

Using Macros and Visual Basic for Applications Vba With Excel

Collaboration Features for Workbooks

Filters