Sorting and filtering data in tables MCQs – MS Word

MCQs on Sorting and Filtering Data in Tables in MS Word

  1. To sort data in a table in MS Word, which tab do you need to use?
    • A) Home
    • B) Layout
    • C) Table Design
    • D) Table Tools Layout

    Answer: D) Table Tools Layout

  2. How can you sort data in ascending order in a table in MS Word?
    • A) Select the table, go to the “Home” tab, and click “Sort” in the “Paragraph” group.
    • B) Select the table, go to the “Table Tools Layout” tab, and click “Sort” in the “Data” group, then choose “Ascending.”
    • C) Go to the “Insert” tab, select “Sort,” and choose “Ascending.”
    • D) Go to the “Review” tab and select “Sort” from the options.

    Answer: B) Select the table, go to the “Table Tools Layout” tab, and click “Sort” in the “Data” group, then choose “Ascending.”

  3. What is the purpose of the “Filter” option in a table in MS Word?
    • A) To format the table borders.
    • B) To sort the table data alphabetically or numerically.
    • C) To hide or show specific rows based on criteria.
    • D) To change the font size and style in the table.

    Answer: C) To hide or show specific rows based on criteria.

  4. Which of the following is a correct method to filter data in a table in MS Word?
    • A) Select the table, go to the “Design” tab, and choose “Filter.”
    • B) Select the table, go to the “Table Tools Layout” tab, and click “Filter” in the “Data” group.
    • C) Select the table, click on the drop-down arrow in the column header, and choose the filtering options.
    • D) Use the “Table Tools Design” tab to apply a filter.

    Answer: C) Select the table, click on the drop-down arrow in the column header, and choose the filtering options.

  5. If you want to sort a table by a specific column, which steps should you follow in MS Word?
    • A) Select the entire table, go to the “Layout” tab, and choose “Sort” to select the column you want to sort by.
    • B) Click on the column header, then go to the “Table Tools Layout” tab and select “Sort.”
    • C) Click on the column header, then use the “Home” tab to sort data.
    • D) Select the column, right-click and choose “Sort.”

    Answer: A) Select the entire table, go to the “Layout” tab, and choose “Sort” to select the column you want to sort by.

  6. What options are available when sorting data in a table in MS Word?
    • A) Only Ascending and Descending
    • B) Only Numerical and Alphabetical
    • C) Ascending, Descending, and Custom Sort
    • D) Only Date and Time

    Answer: C) Ascending, Descending, and Custom Sort

  7. How do you remove a filter applied to a table in MS Word?
    • A) Select the table, go to the “Table Tools Layout” tab, and click “Clear Filter.”
    • B) Click on the drop-down arrow in the column header and choose “Clear Filter.”
    • C) Go to the “Design” tab and select “Remove Filter.”
    • D) Filters are automatically removed when you close the document.

    Answer: B) Click on the drop-down arrow in the column header and choose “Clear Filter.”

  8. What does the “Custom Sort” option allow you to do in MS Word?
    • A) Apply a filter based on specific criteria.
    • B) Sort data by multiple columns and specify sort orders.
    • C) Change the table’s design and layout.
    • D) Sort data in reverse order only.

    Answer: B) Sort data by multiple columns and specify sort orders.