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…

Question

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.

• A
  6% (3)
• B
  79% (38)
• C
  10% (5)
• D
  4% (2)

Explanation

In order to accomplish the task, she should take the following steps: Select the cell which is to be 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.

No community discussion yet for this question.