Exam 6: Managing Data With Data Tools

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?

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.

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?

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?

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?

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?

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?

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.

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.

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