Microsoft Excel 2016 - Module 9 Quiz
Email address *
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
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
10. Which of the following is the path to the Error Checking button? *
1 point
16. Which of the following is the path to the Watch Window button? *
1 point
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
6. Which of the following is the path to the Trace Precedents button? *
1 point
5. A cell containing a formula that references other cells is said to have ____. *
1 point
14. The ____ Window button opens a separate window that displays values and formulas for specific cells that you choose to monitor. *
1 point
17. The ____ button allows you to move through a formula step by step. *
1 point
18. Which of the following is NOT a type of data validation criteria you can assign to a cell? *
1 point
15. The ____ allows you to monitor the values and formulas in cells as you work on a worksheet. *
1 point
11. The Trace Error button is located in the ____ dialog box. *
1 point
1. Formula ____ allows you to examine formulas to determine which cells are referenced by those formulas. *
1 point
13. The ____ error code indicates that a cell reference in a formula is not valid. *
1 point
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
7. Which of the following is the path to the ‘Remove All Arrows’ arrow? *
1 point
12. When a cell contains a(n) ____ reference, it means that one of its defining values is itself. *
1 point
8. A cell whose value relies on another referenced cell is said to be a(n) ____ of that referenced cell. *
1 point
19. Which of the following is the path to the Data Validation button? *
1 point
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
Submit
reCAPTCHA
This form was created inside of Professional Tutor, LLC. Report Abuse