Valid 77-888 Dumps shared by ExamDiscuss.com for Helping Passing 77-888 Exam! ExamDiscuss.com now offer the newest 77-888 exam dumps, the ExamDiscuss.com 77-888 exam questions have been updated and answers have been corrected get the newest ExamDiscuss.com 77-888 dumps with Test Engine here:
You work as a Help Desk Technician for Dreams Unlimited Inc. Martha, a Sales Manager, is creating a sales report in Microsoft Excel. The report contains many worksheets. Martha has used many formulas in her report. She wants to monitor a cell which contains a formula. The formula refers to many other cells that are located in different worksheets in the report. She wants to know the effects on the cell when the values in different sheets change. She requests that you help her out to accomplish the task. Which of the following steps would you suggest she take in order to accomplish the task?
Correct Answer: B
Explanation/Reference: Explanation: In order to accomplish the task, she should take the following steps: Select the cell which is to be monitored. On the Formulas tab in the Formula Auditing group, click Watch Window. Click Add Watch. Answer option D is incorrect. Evaluate Formula is the formula examination tool provided by Microsoft Excel. This tool is useful for examining formulas that do not produce an error but are not generating the expected result. Answer options A and C are incorrect. Clicking the New Window option in the Window group on the View tab opens an instance of the workbook within the Excel window. This is useful when you work on different worksheets, and at the same time you want to navigate among them.
