Exam 6: Managing Data With Data Tools

Sala wants to unfreeze the first column of his worksheet. Which of the following series of clicks will help him do so?

Cedric has a list of data that he wants to group and summarize, For this, he can create an outline of up to eight levels, one for each group.

To remove duplicate values from an Excel worksheet, click Data > Data Tools > Remove Duplicates.

To ungroup a range of cells in a row in a worksheet, select the rows or columns you wish to ungroup, then click the Group command in the Outline group on the Data tab. In the Group dialog box, select Rows and click OK .

The components of a structured reference are as follows: Table 1 is Table Name, [Net Amount] and [Commission Amount] are column specifiers and [#Totals] and [#Increase] are item specifiers. Which of these can be the formula for the structured reference?

To expand data views using the Outline feature, select the rows with similar data by clicking and dragging on the rows numbers to the left of your data. Then click on Data tab > Group > - sign.

Haley wants to delete a column in a table created in MS Excel to get rid of some unwanted data. What should she do after selecting the column?

Which dialog box opens after selecting a cell in the list of prepared data, clicking the Insert tab on Ribbon and then clicking the Table command in the Tables group?

Kathy wants to rename a table she created to list the chapters from a textbook, and the topics they cover. She selects a cell in the table, then clicks on a Tab X on the Ribbon under the Table Tools tab, clicks on the Table Name box to select the existing name, and then types the new name "Book A" and presses the Y key. What can X and Y be in this series of clicks/selections/entries?

Which of the following series of clicks will you select to remove banded columns from a table?

Which of these keys will you hold to select more than one item while inserting a slicer into a PivotTable?

Which of these combination of keys will you click to clear an outline?

Ursula wants to freeze the header row so that it remains visible while she scrolls down the worksheet. To do so, she can click the View tab and then click Freeze Top Row.

A teacher creates a table that contains data in three columns, A to C under headings : First name, Last name, and Date of birth, respectively. To sort the table by the last names of students from A to Z, she can select a cell in the column B, select the Data tab on the Ribbon, then click the Ascending command.

Which of the following will you do to reapply a filter to a table after the steps: Selecting any cell in the filtered table and clicking the Data tab?

Which of the following keys will you press when the cell cursor is in the last cell of the last record (row) to add new data for the next record?

To select a table to copy it to another worksheet, you can click anywhere in the table, and then press CTRL+ C to select and copy the table data in the entire table.

Soledad wants to create an auto outline in a Excel worksheet to hide details and only show the headers. To do this, she can click into any cell, then click Data tab > Group > Auto Outline.

Which of the following can help you quickly format a cell range with labels in the left column and top row, and totals in the bottom row?

Which of the following boxes will you check after clicking on a table and then selecting Table Tools > Design, to add a total row to a table?