Question 1

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?

Accepted Answer

A)  Click on Data tab and click the Filter button. 
B)  Click the Filter icon button next to the column heading and then click Clear Filter from . 
C)  Highlight the header row of the column and press the keys Alt+D+F+F. 
D)  Highlight the header row of the column and press keys CTRL + R.

Question 2

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.

Accepted Answer

A) True 
 B)False

Question 3

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?

Accepted Answer

A)  Outline 
B)  Data Tools 
C)  Sort & Filter 
D)  Connections

Question 4

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?

Accepted Answer

A)  X-Text Filters, Y-Ends with 
B)  X-Text Filters, Y-Begins with 
C)  X-Number Filters, Y-Between 
D)  X-Number Filters, Y-Does not equal

Question 5

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?

Accepted Answer

A)  Data tab 
B)  Insert tab 
C)  Home tab 
D)  Review tab

Question 6

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?

Accepted Answer

A)  Right click on it and select Insert from the drop-down menu. 
B)  Right click on it, select Format Cells from the drop-down menu and select Add New Column. 
C)  Click on it, then click the arrow next to Insert in the drop-down menu. 
D)  Double click on it, select Format cells from the drop-down menu and click on Insert.

Question 7

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?

Accepted Answer

A)  Filter the list, in place 
B)  Copy to another location 
C)  Filter unique records 
D)  Copy unique records

Question 8

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.

Accepted Answer

A) True 
 B)False

Question 9

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.

Accepted Answer

A) True 
 B)False

Question 10

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

Accepted Answer

A)  Gridlines View 
B)  Gridlines Print 
C)  Headings View 
D)  Headings Print

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?

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?

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 view a worksheet without gridlines showing on the screen, which of the following would you uncheck?