Question 1

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

Accepted Answer

To add a new column to the right, Josh should right click on the current last column and select "Insert" from the drop-down menu. This will create a new blank column to the right that he can populate with the percentage scores.

Question 2

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

Accepted Answer

Since Kylie wants to display numbers in the first column in the range of 400 to 500, she needs to use number filters. X should be "Number Filters" and Y should be "Between" to specify a range.

Question 3

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 .

Accepted Answer

To ungroup a range of cells in a row or column, you should select the rows or columns you wish to ungroup, then click the Ungroup command in the Outline group on the Data tab, not the Group command.

Question 4

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.

Accepted Answer

Clicking on the Data tab > Group > Auto Outline will allow Soledad to create an auto outline in Excel to hide details and only show the headers.

Question 5

Cedric has a list of data that he wants to group and summarize,For this,he can create an outline of up to eight levels,one for each group.

Accepted Answer

Cedric can create an outline of up to eight levels, one for each group.

Question 6

Haley wants to delete a column in a table created in MS Excel to get rid of some unwanted data.What should she do after selecting the column?
A) Left click on the selected column and press the Esc key.
B) Right click on the selected column and press the Delete key.
C) Double click on the selected column and press the Tab key.
D) Right click on the selected column and press Ctrl + Z key.

Accepted Answer

After selecting the column, Haley should right click on the selected column and press the Delete key to delete the column. This will remove the entire column including all the data in it.

Question 7

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

The steps described will allow Tomoko to sort and count the number of sweatshirts of each size bought by different customers.

Question 8

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.

Accepted Answer

This is the correct process for collapsing data views using the Outline feature.

Question 9

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.

Accepted Answer

This statement is true.

Question 10

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?
A) X-Insert tab,Y-Shift key
B) X-Home tab,Y-PgDn key
C) X-Design tab,Y-Enter key
D) X-Page Layout tab,Y-Esc key

Accepted Answer

The "Table Name" box is found under the "Design" tab of the Table Tools tab. Thus, the answer is either C or D. However, the "Esc" key is not used in this operation, so the answer must be C, with "Enter" being the key pressed to confirm the table name change.

Question 11

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?
A) Check the box beside Select All and the number 60 and click OK.
B) Uncheck (Select All),select the box beside the number 60 and click OK.
C) Select Number Filters > Between > (Enter value 0 in dialog box on top)> (Enter value 60 in dialog box below it)> OK.
D) Select Number Filters > Less Than or Equal To > (Enter value 0 in dialog box on top)> (Enter value 60 in dialog box below it)> OK.

Accepted Answer

Shelley needs to filter the column to show only the students who scored exactly 60 marks. Therefore, she should uncheck (Select All) and select the box beside the number 60. This will filter the table to show only the rows where the Marks column has the value of 60.

Question 12

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?
A) New Table
B) Insert Table
C) Create Table
D) Include Table

Accepted Answer

The Create Table 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.

Question 13

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?
A) Cell Style
B) Cell Effects
C) Format as Table
D) Conditional Formatting

Accepted Answer

To format a range as a table, we need to click on the "Format as Table" option, which is represented by X in this series of clicks. The Cell Style and Cell Effects options are used to change the formatting of individual cells, and Conditional Formatting is used to add formatting based on specific conditions. Therefore, the best choice is option C.

Question 14

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?
A) Clicking the Data tab on the Excel Ribbon
B) Clicking the Insert tab on the Excel Ribbon
C) Clicking the Review tab on the Excel Ribbon
D) Clicking the Formulas tab on the Excel Ribbon

Accepted Answer

Clicking the Data tab on the Excel Ribbon and then clicking the "Clear" button in the Sort & Filter group will manually turn off autofilter in a table without affecting the cell selection.

Question 15

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?
A) Filter the list,in place
B) Copy to another location
C) Filter unique records
D) Copy unique records

Accepted Answer

Adele should select "Copy to another location" in the series of clicks described, as this option allows her to specify a starting cell for copying to a location and check the box beside "Unique records only" to extract a list of unique items.

Question 16

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?
A) Clicking Subtotal in the Outline group
B) Clicking Reapply in the Sort & Filter group
C) Clicking Consolidate in the Data Tools group
D) Clicking Refresh All in the Connections group

Accepted Answer

Clicking "Reapply" in the Sort & Filter group will reapply the last used filter to the table.

Question 17

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?
A) Outline
B) Data Tools
C) Sort & Filter
D) Connections

Accepted Answer

Outline is the correct choice because after selecting a cell in the range and clicking on Data, you would navigate to Outline to access the Subtotal function in Excel.

Question 18

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?
A) Esc
B) Ctrl
C) Tab
D) Shift

Accepted Answer

When the cell cursor is in the last cell of the last record (row), pressing the Tab key will move the cursor to the first cell of the next record (row) and allow you to add new data. Pressing the Esc key will cancel any changes made to the current cell and keep the cursor in the same cell. Pressing the Ctrl key and Shift key will not have any effect on adding new data for the next record.

Question 19

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?
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 <"Date of order">.
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.

Accepted Answer

Luke should click the Filter icon button next to the column heading and then click Clear Filter from "Date of order" to remove filters from the first column.

Question 20

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.

Accepted Answer

To expand data views using the Outline feature, you would click on the "+" sign to expand grouped data, not the "-" sign. The "-" sign is used to collapse grouped data.

Quiz 6: Managing Data With Data Tools

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 .

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.

Cedric has a list of data that he wants to group and summarize,For this,he can create an outline of up to eight levels,one for each group.

Haley wants to delete a column in a table created in MS Excel to get rid of some unwanted data.What should she do after selecting the column?

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.

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.

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?

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?

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?

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?

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?

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?

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?

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?

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.