USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Kash is working with a large, complex worksheet and would like to see what is going on in different cells in different parts of the workbook. What built-in tool would Kash use to make monitoring various cell values much simpler?
|
Consolidating Data
|
|
Error Checking
|
|
Evaluate Formula
|
|
Watch Window
|
Explanation:
Detailed explanation-1: -Go to Formulas tab > Formulas Auditing > Trace Dependents. Click on the Trace Dependents button to see the cells that are affected by the active cell. It will show a blue arrow that links the active cell and the other cells related to the selected cell.
Detailed explanation-2: -Select the worksheet(s) you want to preview. Click File, and then click Print to display the Preview window and printing options. Keyboard shortcut You can also press Ctrl+F2.
There is 1 question to complete.