Exam 6: Managing Data With Data Tools

The components of a structured reference are as follows: Table 1 is Table Name,[Net Amount] and [Commission Amount] are column specifiers and [#Totals] and [#Increase] are item specifiers.Which of these can be the formula for the structured reference?

Josh teaches sixth grade math.He created a table showing marks that his students scored on an assessment-the last column on the right displays this information.He now wants to add another column to the right showing percentage of marks that each students scored.What should he do after selecting the current last column on the right?

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.

If you wish to see how formatting changes affect your table,the Preview list on the right side of the New Table Style box that opens under Table Styles gallery lets you do so.

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.

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

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.

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

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?

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

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?

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

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

To select a table to copy it to another worksheet,you can click anywhere in the table,and then press CTRL+ C to select and copy the table data in the entire table.

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.

Kathy wants to rename a table she created to list the chapters from a textbook,and the topics they cover.She selects a cell in the table,then clicks on a Tab X on the Ribbon under the Table Tools tab,clicks on the Table Name box to select the existing name,and then types the new name "Book A" and presses the Y key.What can X and Y be in this series of clicks/selections/entries?

Luke owns his own business.creates a table with three columns titled as: Date of order,Regions and Products Ordered.He applied filters on the columns to analyze the data he entered.He now wants to clear filters from the first column.What should Luke do after clicking on the column heading?

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?

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.