Microsoft Excel Interview Questions and Answers
Ques. How would you provide a Dynamic range in "Data Source" of Pivot Tables in MS Excel?Ans. 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: