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

Identify the letter of the choice that best matches the phrase or definition.

Premises:

Keeps a cell reference constant when copying a formula or function.

Responses:

absolute cell referencing

Keep Source Formatting

goal seeking

Correct Answer:

Verified

Keeps a cell reference constant when copying a formula or function.

(Matching)

4.8/5

(33)

Question 21

Using the accompanying figure, identify the following chart elements: chart sheet, chart title, Pie chart, data series, category names, exploded slice, and data labels.

(Essay)

4.9/5

(39)

Question 22

You can press the CONTROL-ACCENT MARK(`)to display the formulas in a worksheet.

(True/False)

4.9/5

(43)

Question 23

____________________ allows you automatically to modify values in a what-if area of a worksheet based on a goal that you have for another cell in the worksheet.

(Short Answer)

4.7/5

(39)

Question 24

If you accidentally delete valuable data, immediately click the ____ button in the Standard toolbar.

(Multiple Choice)

4.9/5

(28)

Question 25

When Excel draws a(n)____________________ chart, it always positions the chart so that one of the dividing lines between two slices is a straight line pointing to 12 o'clock (or 0 degrees).

(Short Answer)

4.9/5

(34)

Question 26

If the contents of a cell copied using the fill handle is Sunday and Tuesday, what are the next three values of the extended series?

(Multiple Choice)

4.9/5

(32)

Question 27

Rotated text also allows you to fit more text into a smaller column width.

(True/False)

4.8/5

(29)

Question 28

Which of the following is an extension of the fill pattern Sunday, Tuesday?

(Multiple Choice)

4.8/5

(30)

Question 29

Changing the order of sheets in a workbook allows you to position the most important worksheets first.

(True/False)

4.9/5

(34)

Question 30

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

(Short Answer)

4.7/5

(30)

Question 31

When you change a value on which a chart is dependent, Excel immediately redraws the chart based on the new value.

(True/False)

4.9/5

(33)

Question 32

Briefly discuss how Excel modifies cell references when copying and pasting formulas, including an explanation of absolute, relative, and mixed cell references.

(Essay)

5.0/5

(31)

Question 33

The range for the reduction or enlargement of the display of a worksheet is from ____.

(Multiple Choice)

4.8/5

(36)

Question 34

When you rest the mouse pointer over a chart item, such as the legend, Excel displays a chart tip containing the name of the item.

(True/False)

4.9/5

(23)

Question 35

Studies have shown that more than 25 percent of all business worksheets have errors.

(True/False)

4.8/5

(31)

Question 36

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)

4.8/5

(31)

Question 37

The Copy button copies contents and format of the source area to the ____________________.

(Short Answer)

4.8/5

(32)

Question 38

When working with a large worksheet, you can split the window into ____ panes.

(Multiple Choice)

4.8/5

(29)

Question 39

The Increase Indent button indents the contents of a cell to the right by ____ spaces each time you click it.

(Multiple Choice)

4.9/5

(31)

Question 40

Showing 21 - 40 of 112

Using the accompanying figure, identify the following chart elements: chart sheet, chart title, Pie chart, data series, category names, exploded slice, and data labels.

You can press the CONTROL-ACCENT MARK(`)to display the formulas in a worksheet.

____________________ allows you automatically to modify values in a what-if area of a worksheet based on a goal that you have for another cell in the worksheet.

If you accidentally delete valuable data, immediately click the ____ button in the Standard toolbar.

When Excel draws a(n)____________________ chart, it always positions the chart so that one of the dividing lines between two slices is a straight line pointing to 12 o'clock (or 0 degrees).

If the contents of a cell copied using the fill handle is Sunday and Tuesday, what are the next three values of the extended series?

Rotated text also allows you to fit more text into a smaller column width.

Which of the following is an extension of the fill pattern Sunday, Tuesday?

Changing the order of sheets in a workbook allows you to position the most important worksheets first.

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

When you change a value on which a chart is dependent, Excel immediately redraws the chart based on the new value.

Briefly discuss how Excel modifies cell references when copying and pasting formulas, including an explanation of absolute, relative, and mixed cell references.

The range for the reduction or enlargement of the display of a worksheet is from ____.

When you rest the mouse pointer over a chart item, such as the legend, Excel displays a chart tip containing the name of the item.

Studies have shown that more than 25 percent of all business worksheets have errors.

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

The Copy button copies contents and format of the source area to the ____________________.

When working with a large worksheet, you can split the window into ____ panes.

The Increase Indent button indents the contents of a cell to the right by ____ spaces each time you click it.

Introduction to Computers

Microsoft Office 2011 and Mac Os X Lion

Excel: Creating a Worksheet and an Embedded Chart

Excel: Formulas, Functions, and Formatting

Outlook: Managing E-Mail Messages With Outlook

Outlook: Managing Calendars

Powerpoint: Creating and Editing a Presentation With Clip Art

Powerpoint: Enhancing a Presentation With Pictures, Shapes, and Wordart

Powerpoint: Reusing a Presentation and Adding Media

Word: Creating, Formatting, and Editing a Word Document With Pictures

Word: Creating a Research Paper With Citations and References

Filters