Question 1

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?

Accepted Answer

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

Question 2

What will you select as X in the following series of clicks to insert a Recommended chart: Range of cells > X > Charts group > Recommended Charts > Clustered Column > OK?

Accepted Answer

The insert tab contains the Charts group, which is where the Recommended Charts option can be found.

Question 3

To move a chart to a different worksheet,click on the Chart > Chart Tools > Design tab > Location group > Move Chart > New sheet,and then in the New sheet box,type a name for the worksheet.

Accepted Answer

The steps mentioned are correct for moving a chart to a different worksheet in Excel.

Question 4

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?

Accepted Answer

To remove a data series from a chart, we need to select the data series and then click on the "Remove" button, which will delete the data series from the chart. The other options like "Add" and "Edit" will not help in removing the data series. "Delete" may also be a possible option, but "Remove" is a more appropriate and commonly used term in this context.

Question 5

To switch chart rows and columns,we can click anywhere in the chart containing the data series that we want to plot on different axes,click on the Design tab in Chart Tools,then in the Data group,and finally click Switch Row/Column.

Accepted Answer

This is the correct procedure to switch chart rows and columns.

Question 6

Rainn wants to switch rows to column in his chart.To do so,he can click on the following series: chart with data series that he wants to plot on different axes > Chart Tools > Design tab > Data group > Switch Row/Column.

Accepted Answer

This is the correct method to switch rows to columns in a chart using Microsoft Excel.

Question 7

Which of the following will you select as X in the given series of clicks to add a legend to the bottom of a chart: Chart > + sign > X > Bottom?

Accepted Answer

In the given series of clicks, after selecting the chart, clicking on the "+" sign, and selecting X (the location where the legend is to be added), the next step is to choose the "Legend" option to add a legend to the bottom of the chart. Therefore, the correct choice is B) Legend.

Question 8

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 9

Which of the following will you select as X in the following series of clicks to apply a shape fill to a chart element: Chart > Chart Tools > Format > Shape Styles > X?

Accepted Answer

The option to select a shape fill is located under the "Shape Styles" section, and is represented by the icon of a paint bucket. This is the option labeled as X in the given series of clicks.

Question 10

Which of the following will you select as X in the following series of clicks to add a data table to a chart: Data Chart > Chart Tools > X > Data table > (Select check box)Show Data table?

Accepted Answer

The correct sequence of clicks to add a data table to a chart in Excel is to go to Data Chart > Chart Tools > Layout > Data table and then select the "Show Data table" checkbox. Therefore, the correct choice for X is "Layout".

Question 11

What will you select as X in the following series of clicks/entries to insert a Histogram chart: Range of cells > Insert tab > Charts group > X > Histogram group > Histogram chart icon > OK?

Accepted Answer

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

Question 12

Which option will you click after selecting a chart and clicking on + at its top to add a trendline to a chart?

Accepted Answer

Clicking on the + at the top of a selected chart will bring up a menu of options including Trendline. Therefore, the correct answer is D.

Question 13

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?

Accepted Answer

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

Question 14

Which of the following keys will you press after clicking on a chart to remove it from an Excel sheet but keep the data intact?

Accepted Answer

Pressing the "Delete" key after clicking on a chart in Excel will remove the chart from the sheet but keep the data intact. Pressing Ctrl + Q or Alt + F will not remove the chart, and pressing Esc will simply exit any active mode (such as editing a cell).

Question 15

If you see a cells with blue fills of varying lengths representing the values,the cells most likely have ________ applied to them.

Accepted Answer

Data bars are a conditional formatting option in Excel that allows you to quickly visualize data using colored bars filled to varying lengths to represent the values. Data bars are often used to compare values in a single column or to compare values across multiple columns.

Question 16

Which of the following will you select as X in the following series of clicks/entries to insert a chart using the Quick Analysis tool: Range of cells > X > Charts > Select Chart Type you want?

Accepted Answer

The Quick Analysis tool can be opened with the keyboard shortcut Ctrl + Q. Therefore, the correct choice for X in the given series of clicks/entries would be Ctrl + Q.

Question 17

Which of the following will you do in step X in the following series of clicks to change the bounds of a chart axis: Chart > Chart Tools > Format tab > Current Selection > Format Selection > Format Axis > Axis Options > Vertical Axis crosses > At Category number > X?

Accepted Answer

In step X, you will type the number that you want in the text box under "At Category number."

Question 18

Olivia wants to align a certain shape on her worksheet in a specific manner.To do so,she clicks on the shape,and then clicks on the Format tab under Drawing Tools.She then clicks on Align in the Arrange group.What should Olivia click on next to align the picture to the left?

Accepted Answer

Olivia should click on Align Left to align the picture to the left.

Question 19

What will you select as X and Y in the following series of clicks/entries to insert a Clustered Column - Line Combination chart: Range of cells > Insert tab > Charts group > Insert Combo Chart symbol > Create Custom Combo Chart > Insert Chart dialog box > All Charts > Series 1 > X (Chart type)> Series 2 > Y (Chart type)> OK?

Accepted Answer

The question specifically mentions that we need to insert a Clustered Column - Line Combination chart. Therefore, the best choice would be to select Clustered Column as X and Line as Y. Option A and D do not include the required chart types, and option C is not relevant to the given requirement.

Question 20

Which of the following will you select as X in the following series of clicks to apply a shadow effect: (Double-click)Text box > Format Options > Text Options > X > Shadow?

Accepted Answer

The option "Text Effects" usually contains various effects that can be applied to text, including shadow effects. Therefore, selecting "Text Effects" is the best choice to apply shadow to the text box.

Quiz 4: Analyzing and Charting Financial Data

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?

What will you select as X in the following series of clicks to insert a Recommended chart: Range of cells > X > Charts group > Recommended Charts > Clustered Column > OK?