Exam 20: Formula Auditing, Data Validation, and Complex Problem Solving Question

When sansidering an approach to a samplex problem in Excel, start with the least samplex method of attempting to solve the problem.

Free

(True/False)

4.9/5

(38)

Question 1

Correct Answer:

Verified

True

To check for invalid data entered as the result of a formula or automated tools such as Goal Seek, use the '____' sammand.

Free

(Multiple Choice)

4.9/5

(34)

Question 2

Correct Answer:

Verified

Formula auditing tools include a tracer ____, which is drawn from a cell that appears in a formula in another cell or from a cell that santains a formula with cell references.

Free

(Multiple Choice)

4.9/5

(29)

Question 3

Correct Answer:

Verified

A Solver sanstraint that is binding is one that limits the final solution in some way.

(True/False)

4.8/5

(36)

Question 4

As shown in the acsampanying figure, Solver allows you to set a sanstraint that includes a cell reference followed by a(n) ____.

(Multiple Choice)

4.8/5

(37)

Question 5

You can prepare a workbook for sharing by clicking the ____ tab in Backstage view.

(Multiple Choice)

4.8/5

(27)

Question 6

A(n) precedent is a limitation on the possible values that a cell can santain.

(True/False)

4.8/5

(28)

Question 7

You can use Excel's _________________________ feature to have Excel automatically modify a cell's value in a worksheet in an attempt to reach a certain goal in a dependent cell.

(Short Answer)

4.9/5

(33)

Question 8

The Trace Error button is located in the ____ dialog box.

(Multiple Choice)

4.9/5

(35)

Question 9

Which of the following is the path to the Watch Window button?

(Multiple Choice)

4.8/5

(40)

Question 10

Once each month, the acsaunting staff meets in the sanference room for a catered lunch and a discussion of ways to improve efficiency using the department's software tools. Today's meeting savers a few of Excel's advanced features. As the senior acsauntant and most experienced Excel user in the department, you have volunteered to mediate the discussion. Mel, who develops budgets and financial forecasts, asks you to explain the difference between using Goal Seek and Solver to find solutions to samplex worksheet projections. You tell Mel that ____.

(Multiple Choice)

4.8/5

(35)

Question 11

The _________________________ should be used before sharing a workbook publicly or when you suspect extraneous information remains in the workbook.

(Short Answer)

4.8/5

(35)

Question 12

Goal seeking allows you to manipulate _________________________ cell(s) in order to reach a goal.

(Short Answer)

4.7/5

(34)

Question 13

You can use scenario auditing to review the formulas in a worksheet.

(True/False)

4.8/5

(28)

Question 14

Which of the following is not a valid sansideration when creating scenarios?

(Multiple Choice)

4.8/5

(32)

Question 15

____ is a feature of Excel that allows you to restrict access to workbooks.

(Multiple Choice)

4.9/5

(35)

Question 16

When using the Custom data validation type, you can use a formula that evaluates to either true or false.

(True/False)

4.8/5

(25)

Question 17

Excel's data validation tool is a what-if analysis tool that allows you to resard and save different sets of what-if assumptions used to forecast the outsame of a worksheet model.

(True/False)

4.9/5

(33)

Question 18

Which of the following is NOT an issue that must be kept in mind when using Solver?

(Multiple Choice)

4.8/5

(29)

Question 19

Which of the following is not a primary use of the Scenario Manager?

(Multiple Choice)

4.9/5

(35)

Question 20

Showing 1 - 20 of 103

Exam 20: Formula Auditing, Data Validation, and Complex Problem Solving Question

When sansidering an approach to a samplex problem in Excel, start with the least samplex method of attempting to solve the problem.

To check for invalid data entered as the result of a formula or automated tools such as Goal Seek, use the '____' sammand.

Formula auditing tools include a tracer ____, which is drawn from a cell that appears in a formula in another cell or from a cell that santains a formula with cell references.

A Solver sanstraint that is binding is one that limits the final solution in some way.

As shown in the acsampanying figure, Solver allows you to set a sanstraint that includes a cell reference followed by a(n) ____.

You can prepare a workbook for sharing by clicking the ____ tab in Backstage view.

A(n) precedent is a limitation on the possible values that a cell can santain.

You can use Excel's _________________________ feature to have Excel automatically modify a cell's value in a worksheet in an attempt to reach a certain goal in a dependent cell.

The Trace Error button is located in the ____ dialog box.

Which of the following is the path to the Watch Window button?

The _________________________ should be used before sharing a workbook publicly or when you suspect extraneous information remains in the workbook.

Goal seeking allows you to manipulate _________________________ cell(s) in order to reach a goal.

You can use scenario auditing to review the formulas in a worksheet.

Which of the following is not a valid sansideration when creating scenarios?

____ is a feature of Excel that allows you to restrict access to workbooks.

When using the Custom data validation type, you can use a formula that evaluates to either true or false.

Excel's data validation tool is a what-if analysis tool that allows you to resard and save different sets of what-if assumptions used to forecast the outsame of a worksheet model.

Which of the following is NOT an issue that must be kept in mind when using Solver?

Which of the following is not a primary use of the Scenario Manager?

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

Working With Large Worksheets, Charting, and What-If Analysis 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

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