nerdexam
Microsoft

77-427 · Question #58

77-427 Question #58: Real Exam Question with Answer & Explanation

Sign in or unlock 77-427 to reveal the answer and full explanation for question #58. The question stem and answer options stay visible for context.

Question

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?

Options

  • AClick the New Window option in the Window group on the View tab.
  • BSelect the cell which is to be monitored.
  • CClick the New Window option in the Window group on the View tab.
  • DSelect the cell which is to be monitored.

Unlock 77-427 to see the answer

You've previewed enough free 77-427 questions. Unlock 77-427 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.

Full 77-427 Practice