MOS - Microsoft Office Specialist Word: Managing Tables and Lists Questions and Answers — Questions and Answers
Question 1: You have a large table in a Word document that spans several pages. To improve readability, you need to ensure the header row is visible at the top of each page where the table appears. Which of the following is the correct action to take?
- Manually copy and paste the header row at the beginning of the table on each new page.
- Select the header row, go to the Table Design tab, and click 'Set as Header'.
- Select the header row, go to the Layout tab under Table Tools, and click 'Repeat Header Rows'. (Correct answer)
- In the Table Properties dialog box, on the Table tab, select the 'Repeat as header row' checkbox.
Correct answer: Select the header row, go to the Layout tab under Table Tools, and click 'Repeat Header Rows'.
To make a table's header row appear on every page, you must select the header row(s), navigate to the 'Layout' tab that appears under 'Table Tools', and then click the 'Repeat Header Rows' command in the Data group. This feature automatically displays the selected header row(s) at the top of the table on subsequent pages.
Question 2: A user wants to convert a multi-column table back into plain text, with each column's data separated by a comma. Which sequence of commands should be used?
- Select the table, go to the Insert tab, and click 'Convert Table to Text'.
- Select the table, go to the Table Design tab, click 'Export', and choose 'Comma Separated'.
- Right-click the table, select 'Table Properties', and choose 'Convert to Text'.
- Select the table, go to the Layout tab under Table Tools, click 'Convert to Text', and then choose 'Commas'. (Correct answer)
Correct answer: Select the table, go to the Layout tab under Table Tools, click 'Convert to Text', and then choose 'Commas'.
The 'Convert to Text' feature is located on the 'Layout' contextual tab within the 'Data' group. After clicking this, a dialog box appears where the user can specify the separator for the text, such as a comma, tab, or paragraph mark.
Question 3: You are formatting a report and need to create a numbered list that starts with the number 5 instead of the default 1. How can you accomplish this?
- Manually type '5.' before the first list item and then use the 'Format Painter' for subsequent items.
- Right-click on the first number in the list and select 'Set Numbering Value'. (Correct answer)
- Go to the 'Define New Number Format' dialog and type '5' in the 'Start at' field.
- Press the Tab key before the first item until the number changes to 5.
Correct answer: Right-click on the first number in the list and select 'Set Numbering Value'.
Word allows you to easily change the starting number of a list. By right-clicking the number in the list, you can access the context menu which includes the 'Set Numbering Value' option, allowing you to specify a new starting number.
Question 4: Which of the following options in the 'Table Style Options' group allows you to apply special formatting to alternating rows to improve readability?
- Header Row
- First Column
- Total Row
- Banded Rows (Correct answer)
Correct answer: Banded Rows
The 'Banded Rows' option, found in the 'Table Style Options' group on the 'Table Design' tab, applies alternating background colors to the rows of a table. This visual distinction makes it easier for readers to follow the data across the table.
Question 5: A user has text where items are separated by tabs, and each line represents a new row. To organize this data, they want to convert it into a table. Where is the 'Convert Text to Table' command located?
- On the Home tab, in the Paragraph group.
- On the Insert tab, within the Table dropdown menu. (Correct answer)
- On the Layout tab, in the Data group.
- On the References tab, in the Citations & Bibliography group.
Correct answer: On the Insert tab, within the Table dropdown menu.
The command to convert selected text into a table is found by clicking the 'Insert' tab, then clicking the 'Table' button, which reveals the 'Convert Text to Table' option.
Question 6: You need to sort a table of sales data first by 'Region' in alphabetical order, and then by 'Sales Amount' from highest to lowest. Which feature in the Sort dialog box allows for this multi-level sorting?
- The 'My list has' header row option.
- The 'Sort by' dropdown for the primary sort and the 'Then by' dropdown for the secondary sort. (Correct answer)
- The 'Ascending' and 'Descending' options applied sequentially.
- The 'Options' button where multiple sort keys can be defined.
Correct answer: The 'Sort by' dropdown for the primary sort and the 'Then by' dropdown for the secondary sort.
The Sort dialog box in Word allows for multi-level sorting. You set the primary sorting criterion using the 'Sort by' fields. For subsequent sorting levels, you use the 'Then by' fields. This allows you to sort by Region first (Ascending) and then by Sales Amount (Descending).
You have a large table in a Word document that spans several pages.
To improve readability, you need to ensure the header row is visible at the top of each page where the table appears.
Which of the following is the correct action to take?