Question 1

Remove duplicate rows where data in all the columns are identical.

Accepted Answer

n the Data Ribbon Tab in the Sort & Filter Ribbon Group, you clicked the Sort button. Inside the Sort dialog, you clicked the Options... button, clicked the Options... button, and clicked the Cancel button. In the Data Ribbon Tab in the Data Tools Ribbon Group, you clicked the Remove Duplicates button. Inside the Remove Duplicates dialog, you clicked the OK button. Inside the Microsoft Excel dialog, you clicked the OK button.

Question 2

Export this worksheet as a tab-delimited text file.

Accepted Answer

You opened the backstage view, clicked the Save As navigation button, and clicked the Browse button. Inside the Save As dialog in the Save as type drop-down, you selected Text (Tab delimited). Inside the Save As dialog, you clicked the Save button.

Question 3

This worksheet is linked to an Access database. Update the worksheet data.

Accepted Answer

In the Design Ribbon Tab in the External Table Data Ribbon Group, you clicked the Refresh button arrow. Inside the Queries & Connections dialog from the 0 query list, you clicked the Class Schedule Refresh Icon item.

Question 4

Convert the cell range to a table using table style Table Style Light 8 (the first style in the second row under the Light styles). The table should include headers.

Accepted Answer

In the Home Ribbon Tab in the Styles Ribbon Group, you clicked the Format as Table button. In the Format as Table menu, you selected the Table Style Light 8 option. Inside the Format As Table dialog, you clicked the OK button.

Question 5

Apply the Table Style Light 14 Quick Style (the last style in the second row under Light styles) to this table.

Accepted Answer

In the Design Ribbon Tab in the Table Styles Ribbon Group, you expanded the Quick Styles Gallery. In the Design Ribbon Tab in the Table Styles Ribbon Group in the Quick Styles menu, you selected the Table Style Light 14 option.

Question 6

Sort this data alphabetically from A to Z by values in the Category column.

Accepted Answer

You clicked cell B1, clicked the Quick Sort dropdown. In the Table Filter menu, you clicked the (Select All) checkbox, clicked the (Select All) checkbox, and clicked the Sort A to Z menu item.

Question 7

Insert a PivotChart using the first pie chart type.

Accepted Answer

In the Analyze Ribbon Tab in the Tools Ribbon Group, you clicked the PivotChart button. Inside the Insert Chart dialog from the Chart Type list, you selected Pie. Inside the Insert Chart dialog from the Pie Chart list, you clicked the Pie item. Inside the Insert Chart dialog, you clicked the OK button.

Question 8

Sort the Date column so the oldest dates are listed first.

Accepted Answer

In the Home Ribbon Tab in the Editing Ribbon Group, you clicked the Sort & Filter button. In the Sort & Filter menu, you clicked the Custom Sort... menu item. Inside the Sort dialog, you clicked the OK button.

Question 9

Enable filtering.

Accepted Answer

In the Data Ribbon Tab in the Sort & Filter Ribbon Group, you clicked the Filter button.

Question 10

Sort the data first alphabetically by the values in the Category column and then by the dates in the Date column with the oldest dates first.

Accepted Answer

In the Data Ribbon Tab in the Sort & Filter Ribbon Group, you clicked the Advanced button. Inside the Advanced Filter dialog, you clicked the dialog Close button. In the Data Ribbon Tab in the Sort & Filter Ribbon Group, you clicked the Sort button. Inside the Sort dialog in the Sort By drop-down, you selected Category. Inside the Sort dialog, you clicked the Add level button. Inside the Sort dialog in the Sort By2 drop-down, you selected Date. Inside the Sort dialog, you clicked the OK button.

Question 11

Use the Flash Fill command to autofill the remaining cells in this column with the pattern from cell F2.

Accepted Answer

In the Data Ribbon Tab in the Data Tools Ribbon Group, you clicked the Flash Fill button.

Question 12

Convert the table to a normal range.

Accepted Answer

In the Design Ribbon Tab in the Tools Ribbon Group, you clicked the Convert to Range button. Inside the Microsoft Excel dialog, you clicked the Yes button.

Question 13

Add a total row to this table.

Accepted Answer

In the Design Ribbon Tab in the Table Style Options Ribbon Group, you checked the Total Row check box.

Question 14

Refresh the PivotTable data.

Accepted Answer

In the Analyze Ribbon Tab in the Data Ribbon Group, you clicked the Refresh button.

Question 15

Add the Profit-Sharing field to the PivotTable.

Accepted Answer

Inside the PivotTable Fields dialog from the PivotTable Fields list, you clicked the Profit-Sharing check box, checked the Profit-Sharing check box.

Ch. 4 Assessment Excel 2016 IP

Unlock all answers in this set

Haven't found what you need?