Exam 6: Managing Data With Data Tools

Hari wants to connect a slicer to three pivot tables so that he can control the entire dashboard with a single slicer. To do so, he selects the pivot tables to connect a slicer, then selects a cell in any of them, then clicks on three group/tab/button in a series. Next from the "Insert Slicer" dialog box, he selects the column to use as a filter in the slicer and clicks OK. What can be the three clicks he made during the procedure?

A teacher creates a table that contains data about winners of a Sports Day events in 4 columns, A to D under headings : Event, Rank, First name, Last name and Grade, respectively. To sort the table by Event and then by Rank, she can select a cell in the column A, select the Data tab on the Ribbon, then select the Sort command. Under the Sort dialog box, in the Sort by drop down menu, she can select Event, click Add Level and then select Rank in the Then by drop down menu and finally click OK.

Judith wants to sort data about information of students in a school into three columns: first by gender, second by state and third by age. To do so, she can select all the cells in the list, then click the Data tab, click the Sort button in the Sort & Filter group, then click the Add Level button to add the first sorting level. From the Sort by dropdown, she can select the name of the first column, then the options in Sort on and Order. She can further click the Add Level button to add the next two columns and select options for each from the drop down boxes.

Leigh-Ann wants to filter data in a PIvotChart using a slicer. She clicks on the table and then selects Slicer in a particular group on the insert tab. She then ticks the check boxes for the columns that she wants to filter in the Insert Slicers dialog box and clicks OK. What tab did click during the procedure?

The manager of a footwear company creates a table that contains data in three columns, A to C under headings: Names of customers, Date of order, and Size of footwear ordered, respectively. To select a separate table to sort the number of footwear that were ordered on different dates, she can select the cell range she wants to sort, select the Data tab on the Ribbon, then click the Sort command. In the Sort dialog box that appears, she can choose the column she want to sort by, decide the sorting order and click OK.

Helen wants to resize slicer buttons to exact dimensions. She selects the slicer, then clicks the Slicer Tools under Options tab. What should she select next to reset the slicer buttons to exact dimensions?

To collapse 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.

Mitchel wants to remove a row of unnecessary data in a table created in MS Excel. What should he do after selecting the row?

Michelle finished a 5 kilometer run in 180th position. The organizers shared an Excel spreadsheet with names of all the participants and the time they took to complete the race. The top 15 finishers are listed in rows 2 to 16. Michelle wants to compare her time against theirs. How can she do so?

Which of the following will you do to manually turn off autofilter in a table between the steps: Clicking any cell in the filtered range and clicking the Filter button?

To group specific rows in Excel, select them, then click the Group command on the Data tab in the Outline group. Finally select Rows or Columns in the Group dialog box and click OK.

Which of the following will you select as X in the following series of clicks to format a range as a table: Home tab > Styles group > X > Table Styles?

Which of these tabs will you select to alter the font as desired while changing the slicer style?

Grace wants to connect a slicer to two PivotCharts. In which of these dialog boxes can she select the pivot tables she wants to link to the slicer and click OK?

To delete duplicate records from a table, select the range of cells, then click Remove Duplicates on the Data tab in the Data Tools group, then select one or more columns under Columns. Click OK, and then click Ok again to dismiss a message that indicate the number of duplicate values removed or how many unique values remain.

To apply banded rows to a table, we can select the range of cells that we want to apply banded rows to, then click on the following: Insert tab > Table > OK in Create table dialog box > Design tab > Table Styles Options group > Check Banded rows box.

How can you remove Split panes in a worksheet you are working on?

Nisha wants to freeze all rows above row 4 in a worksheet she is working on to keep them visible while scrolling through the rest of the worksheet. Which of the following series of clicks will help her do so?

To apply a banded column to a table, we can select the range of cells that we want to apply banded columns to, then click on the following: Home tab > Table > OK in Create table dialog box > View tab > Table Styles Options group > Check Banded Columns box.

Shelley creates a table containing the marks of Language Arts students in her class with these columns: Names of Students and Marks. She now wants to see the names of students who scored exactly 60 marks. What will Shelley do after selecting the column header arrow for the column with heading Marks?