Filters
Question type
Study Flashcards

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

Correct Answer

verifed

verified

The Goal Seek command is located on the ____ menu.


A) What-If Analysis
B) Problem Solving Tools
C) Calculation Settings
D) none of the above

Correct Answer

verifed

verified

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


A) The constraints may be constructed so that an answer that satisfies all of them cannot be found
B) Multiple answers might solve the problem
C) Some problems do not have solutions
D) Constraint precision is incompatible with most forms of automatic scaling

Correct Answer

verifed

verified

Which of the following is the path to the 'Remove All Arrows' arrow?


A) (FORMULAS tab | Reviewing group)
B) (FORMULAS tab | Formula Auditing group)
C) (FORMULAS tab | Arrows group)
D) None of the above

Correct Answer

verifed

verified

Which of the following are methods or tools you can use to solve complex worksheet problems?


A) trial and error
B) Goal Seek
C) Solver
D) data validation

Correct Answer

verifed

verified

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. -On her way to the break room, one of the participants stops to ask you how she can improve her efficiency when working with unfamiliar workbooks sent to her from accounting personnel located in different branch offices. You suggest that ____.


A) she use the formula auditing tools in the Formula Auditing group on the FORMULAS tab to trace formula precedents and dependents in order to better understand how each worksheet is structured
B) she ask each branch office accountant to also send an outline document describing all the formulas and other features included in each workbook
C) unfortunately, Excel does not have any built-in tools she can use to become more familiar with the workbooks she receives
D) she ask the branch office accountants to send her all the necessary information so that she can create her own workbooks

Correct Answer

verifed

verified

You can use _________________________ to manage two sets of Solver data.

Correct Answer

verifed

verified

The error code #DIV/0! indicates that there are no common cells in two ranges a formula identifies as having an intersection.

Correct Answer

verifed

verified

One of the tools that Excel provides to solve complex problems is ____, which allows you to specify up to 200 cells that can be adjusted to find a solution to a problem.


A) Goal Seek
B) Trendlines
C) Solver
D) Data Solutions

Correct Answer

verifed

verified

Obvious formula errors in a worksheet are indicated by a(n) ____ in the cell that contains the formula.


A) error code, such as #/DIV0!
B) series of pound signs (#####)
C) green triangle
D) blue square

Correct Answer

verifed

verified

You should name ranges for all input variables before creating your first scenario.

Correct Answer

verifed

verified

_________________________ will try many possible solutions to find one that solves the problem subject to the constraints placed on the data.

Correct Answer

verifed

verified

Showing 101 - 112 of 112

Related Exams

Exam 1

Essential Concepts and Skills

112 Questions

Exam 2

Creating a Worksheet and a Chart

112 Questions

Exam 3

Formulas, Functions, and Formatting

111 Questions

Exam 4

Working With Large Worksheets, Charting, and What-If Analysis

112 Questions

Exam 5

Working With Multiple Worksheets and Workbooks

112 Questions

Exam 6

Financial Functions, Data Tables, and Amortization Schedules

111 Questions

Exam 7

Creating, Sorting, and Querying a Table

112 Questions

Exam 8

Creating Templates, Manipulating Data, and Adding Additional Enhancements to a Worksheet

112 Questions

Exam 9

Working With Trendlines, Pivot Table Reports, Pivotchart Reports, and Slicers

112 Questions

Exam 11

Using Macros and Visual Basic for Applications Vba With Excel

112 Questions

Exam 12

Collaboration Features for Workbooks

112 Questions

Show Answer