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

  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

  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

  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

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

  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

  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

  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

  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

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