Microsoft%20Excel%20Interview%20Questions%20and%20Answers
Question: How would you provide a Dynamic range in "Data Source" of Pivot Tables in MS Excel?Answer: To provide a dynamic range in “Data Source” of Pivot tables, first create a named range using offset function and base the pivot table using a named range created in the first step. |
Is it helpful?
Yes
No
Most helpful rated by users:
- What is Microsoft Excel?
- What is ribbon?
- How can I hide or show the ribbon?
- How can you wrap the text within a cell?
- Is it possible to prevent someone from copying the cell from your worksheet?