Chapter 6

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?

Clicking the Data tab on the Excel Ribbon

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?

Create Table

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

Ctrl

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?

Filters

To view a worksheet without gridlines showing on the screen, which of the following would you uncheck?

Gridlines View

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?

Not Clicking Subtotal in the Outline group, Maybe Clicking Reapply in the Sort & Filter group

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?

Not Data, It is Insert tab

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?

Not Format as Table, Maybe Conditional Formatting

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

Not Slicer Contextual tool tab, maybe Analyze tab

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

Not Worksheet > Data tab > Outline group > Ungroup > Ungroup > Rows > OK, Maybe Worksheet > Data tab > Outline group > Ungroup > Clear Outline

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?

Report Connections, Insert Slice, Maybe Remove

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?

Row 4 > View tab > Windows group > Freeze Panes > Freeze Panes

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?

Tab

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?

Total Row

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, ,True or False?

True

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,True or False?

True

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, True or False?

True

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.

True

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 ,True or False?

True

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,True or False?

True

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, True or False?

True

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.

True

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,True or False?

True

To remove duplicate values from an Excel worksheet, click Data > Data Tools > Remove Duplicates,True or False?

True

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

True

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 ,True or False?

True

Tomoko has created a table for the sale of sweatshirts in her shop last month with the headings, Customer's Name, Sweatshirt Size, Order ID and Payment Date. She wants to sort the number of sweatshirts of each size -Small, Medium, Large and Extra Large, bought by different customers. To do so, she can first sort her worksheet by sweatshirt size from smallest to largest, then click Subtotal command under the Data tab. Tomoko can then click the drop-down arrow for the At each change in field and select 'Sweatshirt Size', then select COUNT to count the number of sweatshirts ordered in each size. Then she can select 'Sweatshirt Size' in the Add subtotal to field and finally click OK.

True

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?

Uncheck (Select All), select the box beside the number 60 and click OK.

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

View tab > Windows group > Freeze Panes > Unfreeze Panes

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?

X-Number Filters, Y-Between

Dante wants to calculate the currently monthly subtotals for the sales of golf balls in his store. Which of the following will he select as X in the series of clicks to do so: Cell in the range > Data > X > Subtotal > OK?

not Connections, Maybe Data Tools