Exam 6: Managing Data With Data Tools

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

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.

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?

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.

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.

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

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.

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.

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

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?

We can use the Remove Duplicates feature to permanently delete the duplicate data by selecting the range of cells that has duplicate values we want to remove,then clicking Data > Remove Duplicates,and then checking the columns where we want to remove the duplicates under Columns.

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?

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?

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 .

Kylie is a corporate trainer. She creates a table with three columns, with column headings as: Skill Number, Skill Name and Learning Objective. She wants to display numbers in the first column in the range of 400 to 500. What can Kylie select as X and Y in the following series of clicks or entries to do so: Click filter icon on the column heading > X > Y > (Enter value 400 in dialog box on top) > (Enter value 500 in dialog box below it) > OK?

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.

What will you select as X in the following series of clicks/entries/selections to apply a table style: Select cell to format as table > X > Format as table > Desired table style?

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 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?

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?