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 to seewhat is going on in different cells in different parts of the workbook.What built-in tool would Kash use to make monitoring various cell valuesmuch 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: -Filtering. We use filtering when we want to get the data that will match the specific conditions. Click on any single-cell inside your data.
Detailed explanation-3: -The VLOOKUP or Vertical Lookup function is used when data is listed in columns. This function searches for a value in the left-most column and matches it with data in a specified column in the same row. You can use VLOOKUP to find data in a sorted or unsorted table.
There is 1 question to complete.