Question 1

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, the best choice would be to use number filters. Within number filters, the option "between" would allow Kylie to enter the range of 400 to 500.

Question 2

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 on the Data tab on the Excel Ribbon will give you access to the Sort & Filter group, where you can turn off the autofilter by clicking the "Clear" button.

Question 3

The score of a student inserted in the B2 cell is 65 and in the C2 cell is 75.Which of the following functions will you insert in the D2 cell so that it returns FALSE if any of the conditions are false for the values in the B2 and C2 cells?
A) =IF(B2>=70, C2>=80)
B) =OR(B2>=70, C2>=80)
C) =AND(B2>=70, C2>=80)
D) =NOT(OR(B2>=70, C2>=80))

Accepted Answer

The function =AND(B2>=70, C2>=80) will return TRUE only if both conditions (B2>=70 and C2>=80) are true, otherwise it will return FALSE. Therefore, if either the score in B2 or C2 is below the minimum threshold, it will return FALSE. This satisfies the condition mentioned in the question.

Question 4

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 5

Which of the following will you select as X in the following series of clicks to convert a table to range: Table > Table Tools > Design > X > Convert to Range?
A) Tools group
B) Themes group
C) Page Setup group
D) Background group

Accepted Answer

The correct option is A) Tools group. In the Design tab, the Tools group contains the option of Convert to Range, which can be clicked to convert the table to a range. The Themes group is used for applying themes to the table, the Page Setup group is used to set the printing properties of the table, and the Background group is used to set the background color of the table, none of which are relevant for converting a table to a range.

Question 6

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

Soledad can create an auto outline in a Excel worksheet by clicking into any cell, then clicking Data tab > Group > Auto Outline to hide details and only show the headers.

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

This is the correct process to sort and count the sweatshirts of each size in the table.

Question 8

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

To clear filters from a specific column, click on the Filter icon button next to the column heading and then click Clear Filter from the column that needs to be cleared. Option A is incorrect as it suggests to click on the Filter button on the Data tab, which would again apply the filter. Option C and D are both incorrect as they suggest using keyboard shortcuts that do not clear filters.

Question 9

What will you do in step X in the following series of clicks to change the font size of chart title: (Right-click) Chart Title > Font > Font tab > X> OK?
A) Select a color in Color box.
B) Enter +Heading in Latin text font box.
C) Select Normal Spacing in Spacing box.
D) Enter the desired size of the chart title in the Size box.

Accepted Answer

In step X, you need to enter the desired size of the chart title in the Size box. This will change the font size of the chart title. The other choices (A, B, and C) are not related to changing the font size of the chart title.

Question 10

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 table to show only the names of students who scored exactly 60 marks. She can do this by unchecking (Select All) and then selecting the box beside the number 60 under Marks. This will filter the table to show only the rows where the Marks column contains the value 60. The other options (A, C, and D) involve filtering for a range of values, which is not what Shelley wants.

Question 11

Which of the following will you select as X in the given series of clicks to remove a data series from a chart: Chart > Chart Tools > Design Tab > Select Data > Data series > X?
A) Add
B) Edit
C) Remove
D) Delete

Accepted Answer

The word "remove" is specifically mentioned in the question and selecting "remove" as X in the given series of clicks will allow the user to delete a data series from the chart. The other options, "add", "edit", and "delete", do not match the required action.

Question 12

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

Right clicking on the last column and selecting "Insert" from the drop-down menu will insert a new column to the right of the current last column. From there, the percentage formula can be added to the new column.

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 choose the "Format as Table" option, which will open a dialog box with various table styles to choose from. Therefore, the correct choice is C.

Question 14

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 method to collapse data views using the Outline feature in Excel.

Question 15

Ngabile wants to insert a Treemap chart for a data set.To do so, she can click on the following series: Range of cells > Page Layout tab > Apps group > Insert Hierarchy Chart > Treemap.

Accepted Answer

To insert a Treemap chart in Excel, Ngabile should go to the Insert tab, then click on the Hierarchy Chart button in the Charts group, and select Treemap from there. The Page Layout tab does not contain options for inserting charts.

Question 16

Which of the following will you select as X in the following series of clicks to change the change the color of a data series: (double-click) Data Series > Format Data Series > Series Options > X > Color > Color of your choice?
A) Effects
B) Fill & Line
C) Shadow Effects
D) Series Options

Accepted Answer

Fill & Line is the option in the Format Data Series menu where you can select the color of the data series. The other options (Effects, Shadow Effects, and Series Options) do not have a direct option to change the color of the data series.

Question 17

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 18

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 19

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?
A) Data tab
B) Insert tab
C) Home tab
D) Review tab

Accepted Answer

The answer of What will you select as X in...

Question 20

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), we can press the Tab key to move the cursor to the first cell of the next record (row) and start adding new data. The Esc key is usually used to cancel a current action or exit a menu, Ctrl and Shift keys do not have any functionality related to adding new data in this scenario.

Quiz 8: Excel

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?

The score of a student inserted in the B2 cell is 65 and in the C2 cell is 75.Which of the following functions will you insert in the D2 cell so that it returns FALSE if any of the conditions are false for the values in the B2 and C2 cells?

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 .

Which of the following will you select as X in the following series of clicks to convert a table to range: Table > Table Tools > Design > X > Convert to Range?

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.

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?

What will you do in step X in the following series of clicks to change the font size of chart title: (Right-click) Chart Title > Font > Font tab > X> 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 of the following will you select as X in the given series of clicks to remove a data series from a chart: Chart > Chart Tools > Design Tab > Select Data > Data series > X?

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?

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.

Ngabile wants to insert a Treemap chart for a data set.To do so, she can click on the following series: Range of cells > Page Layout tab > Apps group > Insert Hierarchy Chart > Treemap.

Which of the following will you select as X in the following series of clicks to change the change the color of a data series: (double-click) Data Series > Format Data Series > Series Options > X > Color > Color of your choice?

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.

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?

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?