Question 1

Which of the following is the path to the Trace Precedents button?
A) (FORMULAS tab | Formula Auditing group)
B) (FORMULAS tab | Trace group)
C) (HOME tab | Formulas group)
D) (HOME tab | Auditing group)

Accepted Answer

A

Question 2

A(n) ____ Report shows the answer that Solver found, which sanstraints were in place, and which values in the worksheet Solver manipulated in order to solve the problem within those sanstraints.
A) Solution
B) Resolution
C) Answer
D) Calculation

Accepted Answer

C

Question 3

Which of the following is the path to the Watch Window button?
A) (FORMULAS tab | Formula Auditing group)
B) (FORMULAS tab | Calculations group)
C) (FORMULAS tab | Observations group)
D) (FORMULAS tab | Watch group)

Accepted Answer

The Watch Window button is located in the Formula Auditing group of the FORMULAS tab.

Question 4

One of the tools that Excel provides to solve samplex 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

Accepted Answer

Solver is the tool in Excel that allows you to specify multiple cells to be adjusted in order to find an optimal solution to a problem, such as linear programming or optimization tasks.

Question 5

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

Accepted Answer

When a cell's value depends on the value of another cell, it is considered a dependent cell of the referenced cell.

Question 6

The ____ allows you to monitor the values and formulas in cells as you work on a worksheet.
A) Show Window
B) Data Window
C) Watch Window
D) Calculation Window

Accepted Answer

The Watch Window is a feature in Excel that allows users to monitor specific cells, formulas, and values while working on a worksheet. This helps keep track of important information and can be especially useful when working with large datasets or formulas.

Question 7

The ____ Window button opens a separate window that displays values and formulas for specific cells that you choose to monitor.
A) Formula
B) Watch
C) Error
D) Monitoring

Accepted Answer

The Watch Window button opens a separate window that displays values and formulas for specific cells that you choose to monitor. The Formula button opens the Formula Auditing group, Error button opens the Error Checking dialog box, and Monitoring is not a valid option in this context.

Question 8

The ____ error sade indicates that a cell reference in a formula is not valid.
A) #DIV/0!
B) #NAME?
C) #VALUE!
D) #REF!

Accepted Answer

The #REF! error indicates that a cell reference in a formula is not valid, often due to deleted or moved cells.

Question 9

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) arrow
B) triangle
C) link
D) none of the above

Accepted Answer

A tracer arrow is used in formula auditing to show the relationship between cells, indicating which cells are used in a formula.

Question 10

The ____ button allows you to move through a formula step by step.
A) Check Formula
B) Evaluate Formula
C) Review Formula
D) Verify Formula

Accepted Answer

The Evaluate Formula button opens the Evaluate Formula dialog box, which allows you to see the different parts of a formula evaluated step by step. This can help you identify errors or understand how the formula is working. The other options listed do not perform this specific function.

Question 11

Formula ____ allows you to examine formulas to determine which cells are referenced by those formulas.
A) calculating
B) auditing
C) formatting
D) trending

Accepted Answer

The auditing feature in Excel allows you to trace the relationships between formulas and cells in a worksheet, enabling you to identify and correct errors in your calculations.

Question 12

The Trace Error button is located in the ____ dialog box.
A) Error Checking
B) Calculation Checking
C) Formula Checking
D) none of the above

Accepted Answer

The Trace Error button is located in the Error Checking dialog box, which can be accessed by clicking on the cell with the error and clicking on the Error Checking button that appears or by going to the Formula tab in the ribbon and clicking on the Error Checking button in the Formula Auditing group. The Calculation Checking and Formula Checking options do not have a Trace Error button.

Question 13

A cell santaining a formula that references other cells is said to have ____.
A) dependents
B) calculations
C) precedents
D) references

Accepted Answer

A cell containing a formula that references other cells is said to have precedents, which are the cells that provide data to the formula.

Question 14

Which of the following samplex problem solving methods, features, or options allows you to provide Excel with all of the known rules of your problem as well as the goal you are seeking, and then attempts as many different solutions to the problem as possible?
A) Trial and error method
B) Solver feature
C) Goal Seek feature
D) Enable iterative calculations option

Accepted Answer

The Solver feature in Excel allows you to define constraints and objectives for a problem and then finds the optimal solution by trying various possibilities.

Question 15

Which of the following is the path to the Error Checking button?
A) (AUDITING tab | Formulas group)
B) (FORMULAS tab | Error Checking group)
C) (FORMULAS tab | Formula Auditing group)
D) (ERROR CHECKING tab | Watch Cells group)

Accepted Answer

The answer of Which of the following is the path...

Question 16

Identifying ____ highlights where changes will occur in the worksheet as a result of changing the value in the cell you are identifying as a referenced cell.
A) precedents
B) dependents
C) examples
D) relationships

Accepted Answer

The answer of Identifying ____ highlights where changes will occur...

Question 17

When a cell santains a(n) ____ reference, it means that one of its defining values is itself.
A) formatted
B) circular
C) error
D) sannecting

Accepted Answer

A circular reference occurs when a cell contains a reference to itself.

Question 18

Which of the following is the path to the Data Validation button?
A) (FORMULAS tab | Validation group)
B) (DATA tab | Data Tools group)
C) (DATA tab | Validation group)
D) (FORMULAS tab | Data Tools group)

Accepted Answer

The answer of Which of the following is the path...

Question 19

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

Accepted Answer

The answer of Which of the following is the path...

Question 20

Which of the following is NOT a type of data validation criteria you can assign to a cell?
A) any specified value
B) whole numbers
C) dates
D) Bold style formatting

Accepted Answer

Bold style formatting is not a type of data validation criteria that can be assigned to a cell. The other options (any specified value, whole numbers, dates) are valid data validation criteria.

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

Which of the following is the path to the Trace Precedents button?

A(n) ____ Report shows the answer that Solver found, which sanstraints were in place, and which values in the worksheet Solver manipulated in order to solve the problem within those sanstraints.

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

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

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

The ____ allows you to monitor the values and formulas in cells as you work on a worksheet.

The ____ Window button opens a separate window that displays values and formulas for specific cells that you choose to monitor.

The ____ error sade indicates that a cell reference in a formula is not valid.

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.

The ____ button allows you to move through a formula step by step.

Formula ____ allows you to examine formulas to determine which cells are referenced by those formulas.

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

A cell santaining a formula that references other cells is said to have ____.

Which of the following samplex problem solving methods, features, or options allows you to provide Excel with all of the known rules of your problem as well as the goal you are seeking, and then attempts as many different solutions to the problem as possible?

Which of the following is the path to the Error Checking button?

Identifying ____ highlights where changes will occur in the worksheet as a result of changing the value in the cell you are identifying as a referenced cell.

When a cell santains a(n) ____ reference, it means that one of its defining values is itself.

Which of the following is the path to the Data Validation button?

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

Which of the following is NOT a type of data validation criteria you can assign to a cell?