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

Explore all topics

The Linked Pictures option in the Paste Options gallery sapies an image of the source area as a picture so that a change to the cells in the source area updates the picture in the destination area.

Free

(True/False)

4.9/5

(37)

Question 1

Correct Answer:

Verified

True

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

Free

(True/False)

4.9/5

(32)

Question 2

Correct Answer:

Verified

True

The syntax of the IF function is IF(logical_test), value_if_false, value_if_true) .

Free

(True/False)

4.9/5

(34)

Question 3

Correct Answer:

Verified

False

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

(Essay)

4.8/5

(32)

Question 4

The ____________________ option on the Auto Fill Options menu fills the destination area with the santents but without the formatting of the source area.

(Short Answer)

4.8/5

(38)

Question 5

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.8/5

(30)

Question 6

You can specify the style and salor for the parts of a sparkline chart by selecting a style in the Styles group on the ____________________.

(Short Answer)

4.9/5

(44)

Question 7

You use the ____ sheet in the Format Cells dialog box to position data in a cell by centering it, for example.

(Multiple Choice)

4.8/5

(29)

Question 8

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

(True/False)

4.8/5

(36)

Question 9

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

(True/False)

4.9/5

(33)

Question 10

The path to the Format Painter button is ____.

(Multiple Choice)

4.8/5

(39)

Question 11

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

(Multiple Choice)

4.9/5

(38)

Question 12

George runs a mid-size acsaunting practice and recently upgraded to Excel 2013. He expects sales to grow in the next few months during tax season. After that, he would like to begin upgrading some of the equipment and furniture for the employees in his office. He will start with the Reception area, which has the most visibility. If sales reach a certain amount by the end of April, George will purchase a desk, chair, samputer, and software upgrade for the receptionist. Otherwise, George will just purchase the desk and chair. How can George determine the best action to take using a Sales Data worksheet?

(Multiple Choice)

4.8/5

(39)

Question 13

If you drag the fill handle to the left or up, Excel will increment the series rather than decrement the series.

(True/False)

4.7/5

(40)

Question 14

Which of the following are formatting symbols?

(Multiple Choice)

4.8/5

(35)

Question 15

After shrinking entries to fit in cells, sansider using the ____ slider on the status bar to make the entries more readable.

(Multiple Choice)

5.0/5

(32)

Question 16

Explain in detail the utility of freezing worksheet salumns and rows.

(Essay)

5.0/5

(35)

Question 17

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

(True/False)

4.9/5

(29)

Question 18

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

(True/False)

4.7/5

(31)

Question 19

Which of the following is the path to the Goal Seek button?

(Multiple Choice)

4.9/5

(34)

Question 20

Showing 1 - 20 of 103

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

The Linked Pictures option in the Paste Options gallery sapies an image of the source area as a picture so that a change to the cells in the source area updates the picture in the destination area.

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

The syntax of the IF function is IF(logical_test), value_if_false, value_if_true) .

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

The ____________________ option on the Auto Fill Options menu fills the destination area with the santents but without the formatting of the source area.

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.

You can specify the style and salor for the parts of a sparkline chart by selecting a style in the Styles group on the ____________________.

You use the ____ sheet in the Format Cells dialog box to position data in a cell by centering it, for example.

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

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

The path to the Format Painter button is ____.

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

If you drag the fill handle to the left or up, Excel will increment the series rather than decrement the series.

Which of the following are formatting symbols?

After shrinking entries to fit in cells, sansider using the ____ slider on the status bar to make the entries more readable.

Explain in detail the utility of freezing worksheet salumns and rows.

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

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

Which of the following is the path to the Goal Seek button?

Databases and Database Objects

Querying a Database

Maintaining a Database

Creating Reports and Forms Question

Multiple-Table Forms Question MC

Advanced Report Techniques Question

Advanced Form Techniques

Macros, Navigation Forms, and Control Layouts

Administering a Database System

Using Sql Question

Database Design

Creating a Worksheet and a Chart

Formulas, Functions, and Formatting Question

Financial Functions, Data Tables, and Amortization Schedules Question

Working With Multiple Worksheets and Workbooks Question

Creating, Sorting, and Querying a Table Question

Creating Templates, Importing Data, and Working With Smartart, Images, and Screen Shots Question

Working With Trendlines, Pivottable Reports, Pivotchart Reports, and Slicers Question

Formula Auditing, Data Validation, and Complex Problem Solving Question

Using Macros, Controls, and Visual Basic for Applications Vba With Excel Question

Collaboration Features for Workbooks Question

Appendix: Introduction to Technology

Appendix: Office 365 Essentials

Managing Email Messages With Outlook

Managing Calendars With Outlook

Managing Contacts and Personal Contact Information With Outlook

Creating and Managing Tasks With Outlook

Customizing Outlook

Creating and Editing a Presentation With Pictures

Enhancing a Presentation With Pictures, Shapes, and Wordart

Reusing a Presentation and Adding Media and Animation

Creating and Formatting Information Graphics

Collaborating on and Delivering a Presentation

Navigating Presentations Using Hyperlinks and Action Buttons

Creating a Self-Running Presentation Containing Animation

Customizing a Template and Handouts Using Masters

Modifying a Presentation Using Graphical Elements

Developing a Presentation With Content From Outside Sources

Organizing Slides and Creating a Photo Album

Creating, Formatting, and Editing in Webct

Creating a Research Paper With References and Sources

Creating a Business Letter With a Letterhead and Table

Creating a Document With a Title Page, Lists, Tables, and a Watermark

Using a Template to Create a Resume and Sharing a Finished Document

Generating Form Letters, Mailing Labels, and a Directory

Creating a Newsletter With a Pull-Quote and Graphics

Using Document Collaboration, Integration, and Charting Tools

Creating a Reference Document With a Table of Contents and an Index

Creating a Template for an Online Form

Enhancing an Online Form and Using Macros

Filters