> > >

Excel MCQs

How would you provide a Dynamic range in “Data Source” of Pivot Tables?

To check dynamic range the pivot table is modified or not we use “Data Source” in range containing the pivot table.

If the multiple sources are different Pivot tables, from same workbook, then it is possible create a named range using Pivot table using multiple sources of data.

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.

All of the above

Answer

Correct 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.

Explanation:

Note: This Question is unanswered, help us to find answer for this one

Excel Skill Assessment

Your Skill Level: Poor

Retake Quizzes to improve it