Home / CSE MCQs / Excel Pivot Tables ::

CSE MCQs :: Excel Pivot Tables

  1. What dialog box allows you to change a field name in a PivotTable?
  2. A.
    Field Options
    B.
    Field Pane
    C.
    Field Settings
    D.
    Field Structure

    View Answer

    Workspace

    Discuss Discuss in Forum


  3. Under which tab and in which function group will you find the option to insert a Pivot Table?
  4. A.
    Under the Insert tab in the Tables group
    B.
    Under the Formulas tab in the Data Analysis group
    C.
    In the Data group in the Pivot Tables group
    D.
    In the Data group in the Tables group

    View Answer

    Workspace

    Discuss Discuss in Forum


  5. What command allows you to highlight the cell(s) in a data table that matches your set-up information?
  6. A.
    Cell Styles
    B.
    Conditional Formatting
    C.
    AutoFormatting
    D.
    Data Table Styles

    View Answer

    Workspace

    Discuss Discuss in Forum


  7. Which of the following is NOT a box in the PivotTable Fields List?
  8. A.
    Column Labels
    B.
    Report Filter
    C.
    Values
    D.
    Formulas

    View Answer

    Workspace

    Discuss Discuss in Forum


  9. What function displays row data in a column or column data in a row?
  10. A.
    Hyperlink
    B.
    Index
    C.
    Transpose
    D.
    Rows

    View Answer

    Workspace

    Discuss Discuss in Forum


  11. How can we provide a dynamic range in 'data Source' of pivot tables?
  12. 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

    Discuss Discuss in Forum


  13. Merge cells option can be applied from
  14. A.
    Format Cells dialog box Alignment Tab
    B.
    Formatting toolbar
    C.
    Both of above
    D.
    None of above

    View Answer

    Workspace

    Discuss Discuss in Forum


  15. What is the purpose of using a pointer in a data table?
  16. A.
    It highlights the cell that matches the source data
    B.
    It allows the array formula to be repositioned
    C.
    It highlights the first cell with a potential error
    D.
    It resets the file location to a recognized folder

    View Answer

    Workspace

    Discuss Discuss in Forum


  17. What is the first step for creating a Pivot Table?
  18. A.
    Clicking on the Insert Tab and inserting a Pivot Table
    B.
    Create or select data that needs to be analyzed
    C.
    Deciding on which fields (column and row labels) to use to analyze the data
    D.
    None of the above

    View Answer

    Workspace

    Discuss Discuss in Forum


  19. Which function will you use to enter current time in a worksheet cell?
  20. A.
    =today()
    B.
    =now()
    C.
    =time()
    D.
    =currentTime()

    View Answer

    Workspace

    Discuss Discuss in Forum