Microsoft Excel 2016 - Module 9 Quiz
* Required
Email address
*
Your email
20. Which of the following complex 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?
*
1 point
Trial and error method
Solver feature
Goal Seek feature
Enable iterative calculations option
4. 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 contains a formula with cell references.
*
1 point
arrow
triangle
link
none of the above
10. Which of the following is the path to the Error Checking button?
*
1 point
(AUDITING tab | Formulas group)
(FORMULAS tab | Error Checking group)
(FORMULAS tab | Formula Auditing group)
(ERROR CHECKING tab | Watch Cells group)
16. Which of the following is the path to the Watch Window button?
*
1 point
(FORMULAS tab | Formula Auditing group)
(FORMULAS tab | Calculations group)
(FORMULAS tab | Observations group)
(FORMULAS tab | Watch group)
9. 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.
*
1 point
precedents
dependents
examples
relationships
6. Which of the following is the path to the Trace Precedents button?
*
1 point
(FORMULAS tab | Formula Auditing group)
(FORMULAS tab | Trace group)
(HOME tab | Formulas group)
(HOME tab | Auditing group)
5. A cell containing a formula that references other cells is said to have ____.
*
1 point
dependents
calculations
precedents
references
14. The ____ Window button opens a separate window that displays values and formulas for specific cells that you choose to monitor.
*
1 point
Formula
Watch
Error
Monitoring
17. The ____ button allows you to move through a formula step by step.
*
1 point
Check Formula
Evaluate Formula
Review Formula
Verify Formula
18. Which of the following is NOT a type of data validation criteria you can assign to a cell?
*
1 point
any specified value
whole numbers
dates
Bold style formatting
15. The ____ allows you to monitor the values and formulas in cells as you work on a worksheet.
*
1 point
Show Window
Data Window
Watch Window
Calculation Window
11. The Trace Error button is located in the ____ dialog box.
*
1 point
Error Checking
Calculation Checking
Formula Checking
none of the above
1. Formula ____ allows you to examine formulas to determine which cells are referenced by those formulas.
*
1 point
calculating
auditing
formatting
trending
13. The ____ error code indicates that a cell reference in a formula is not valid.
*
1 point
#DIV/0!
#NAME?
#VALUE!
#REF!
2. 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.
*
1 point
Goal Seek
Trendlines
Solver
Data Solutions
7. Which of the following is the path to the ‘Remove All Arrows’ arrow?
*
1 point
(FORMULAS tab | Reviewing group)
(FORMULAS tab | Formula Auditing group)
(FORMULAS tab | Arrows group)
None of the above
12. When a cell contains a(n) ____ reference, it means that one of its defining values is itself.
*
1 point
formatted
circular
error
connecting
8. A cell whose value relies on another referenced cell is said to be a(n) ____ of that referenced cell.
*
1 point
precedent
partner
example
dependent
19. Which of the following is the path to the Data Validation button?
*
1 point
(FORMULAS tab | Validation group)
(DATA tab | Data Tools group)
(DATA tab | Validation group)
(FORMULAS tab | Data Tools group)
3. A(n) ____ Report shows the answer that Solver found, which constraints were in place, and which values in the worksheet Solver manipulated in order to solve the problem within those constraints.
*
1 point
Solution
Resolution
Answer
Calculation
Send me a copy of my responses.
Submit
Page 1 of 1
reCAPTCHA
Privacy
Terms
This form was created inside of Professional Tutor, LLC.
Report Abuse
Forms