Exam 6: Managing Data With Data Tools

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

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

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?

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?

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?

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?

Adele wants to extract a list of unique items in a database.Which of the following will she select in the series of clicks to do so: Select cell > Data tab > Advanced > Select option under Action (X)> Specify List range > Select a starting cell for copying to location > Check box beside Unique records only > OK?

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

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?

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?