Home / CSE MCQs / Excel Pivot Tables :: Discussion

Discussion :: Excel Pivot Tables

  1. How can we provide a dynamic range in 'data Source' of pivot tables?
  2. A.
    Create a Named range using Offset function
    B.
    Base the pivot table using the Named range created in Step 1
    C.
    Both A and B
    D.
    None

    View Answer

    Workspace

    Answer : Option C

    Explanation :



Be The First To Comment