FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 10: Formula Auditing, Data Validation, and Complex Problem Solving

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 21

Multiple Choice

Review LaterAdd Note

Review Later

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Finds solutions by evaluating many combinations of constrained cell values.

A) formula auditing
B) data validation
C) constraint
D) Scenario Manager
E) precedent
F) dependent
G) Watch Window
H) circular reference
I) Goal Seek
J) Solver

K) A) and I)
L) E) and F)

Correct Answer

verified

Show Answer

Question 22

Multiple Choice

Review LaterAdd Note

Review Later

A cell whose value relies on another referenced cell is said to be a(n) ____ of that referenced cell.

A) precedent
B) partner
C) example
D) dependent

E) A) and B)
F) None of the above

Correct Answer

verified

Show Answer

Question 23

Short Answer

Review LaterAdd Note

_________________________ is a complex mathematical process used to solve problems that include multiple variables.

The _________________________ feature does have some characteristics that require that you stay vigilant when using it; it may, for example, find a solution that satisfies the criteria specified but that violates conditions specified for data validation.

Case 9-2 Once each month, the accounting staff meets in the conference room for a catered lunch and a discussion of ways to improve efficiency using the department's software tools. Today's meeting covers a few of Excel's advanced features. As the senior accountant 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 complex worksheet projections. You tell Mel that ____.

Case 9-1 You are presenting a two-hour seminar on using Excel features to professionals at an annual convention of accounting managers. The seminar will be followed by a brief Q&A session. Half-way through the seminar, you give the seminar participants a break. -During the following Q&A session, another participant complains that a workbook created in his accounting department was widely shared with others in his company; unfortunately, the workbook contained sensitive information in hidden rows and columns that should not have been shared. He asks if Excel has a feature that can help to prevent this problem in the future. You tell him to ____.

Briefly discuss setting iterative calculation options.

Changing cells or adjustable cells are the cells modified by __________________________ to solve a problem.

For each model, it is helpful to define a ____ scenario that represents the starting assumptions.

The only way to switch between scenarios is to use the Scenario Manager.

Auditing the formulas in a worksheet can give you insight into how a worksheet is structured.

The Scenario Manager command is located on the ____ menu.

Tracing _________________________ in Excel allows you to see the cells on which a formula is based.

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

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

Which of the following is the path to the 'What-If Analysis' button?

Which of the following are error codes?

Entries that are the result of calculations will not produce data validation errors.

The Add Watch button is located on the _________________________ toolbar.

You can attempt to solve a complex worksheet problem manually, also known as the trial and error method.