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

Explore all topics

With bar charts, you can drag the bar in the chart in one direction or another to change the corresponding value in the worksheet.

(True/False)

4.9/5

(36)

Question 101

Which of the following patterns extends the fill series to 575, 550, 525?

(Multiple Choice)

4.8/5

(33)

Question 102

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

(Short Answer)

4.9/5

(35)

Question 103

The incorrect use of copying, deleting, inserting, and moving ranges of cells has the potential to render a worksheet useless.

(True/False)

4.9/5

(29)

Question 104

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

Premises:

Returns a number that corresponds to the system date and time beginning with December 31, 1899.

Responses:

goal seeking

NUM!

IF function

Correct Answer:

Verified

Returns a number that corresponds to the system date and time beginning with December 31, 1899.

(Matching)

4.9/5

(30)

Question 105

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

(Multiple Choice)

4.7/5

(38)

Question 106

In a clustered column chart, the names of each column are part of the ____ series.

(Multiple Choice)

4.7/5

(38)

Question 107

Which of the following is the path to the Zoom button?

(Multiple Choice)

4.8/5

(36)

Question 108

Which of the following cell contents is extended to Qtr3, Qtr4, and Qtr1 by dragging the fill handle?

(Multiple Choice)

4.9/5

(33)

Question 109

Excel allows you to rotate text in a cell counterclockwise by entering a number between -1 degrees and -90 degrees.

(True/False)

4.8/5

(41)

Question 110

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

(Short Answer)

4.8/5

(32)

Question 111

Showing 101 - 111 of 111

With bar charts, you can drag the bar in the chart in one direction or another to change the corresponding value in the worksheet.

Which of the following patterns extends the fill series to 575, 550, 525?

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

The incorrect use of copying, deleting, inserting, and moving ranges of cells has the potential to render a worksheet useless.

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

In a clustered column chart, the names of each column are part of the ____ series.

Which of the following is the path to the Zoom button?

Which of the following cell contents is extended to Qtr3, Qtr4, and Qtr1 by dragging the fill handle?

Excel allows you to rotate text in a cell counterclockwise by entering a number between -1 degrees and -90 degrees.

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

Office 2013 and Windows 8 Essential Concepts and Skills

Digital Literacy: Introducing a World of Technology

The Internet: Accessing, Searching, Sharing, and Communicating

Computers and Mobile Devices: Evaluating the Possibilities

Programs and Apps: Using Software at Work, School, and Home

Digital Safety and Security: Identifying Threats, Issues, and Defenses

Access: Databases and Database Objects: an Introduction

Access: Querying a Database

Excel: Creating a Worksheet and a Chart

Excel: Formulas, Functions, and Formatting

Powerpoint: Creating and Editing a Presentation With Pictures

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

Powerpoint: Reusing a Presentation and Adding Media and Animation

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

Word: Creating a Research Paper With References and Sources

Word: Creating a Business Letter With a Letterhead and Table

Filters