ch 3 excel

Question 1

Which of the following is not impacted when you apply a chart​ style?

A. The chart area fill color might change.
B. The font size for the chart title changes.
C. Chart elements may display or be removed.
D. The fill colors for data series change.

Answer 1

C. Chart elements may display or be removed.

Question 2

The value axis currently shows increments such as​ 50,000 and​ 100,000. What option would you select to display the values in increments of 50 and​ 100?

A. More Primary Vertical Axis Title Options
B. Show Axis in Thousands
C. Show Right to Left Axis
D. Show Axis in Millions

Answer 2

B. Show Axis in Thousands

Question 3

A worksheet contains columns listing new movie​ releases, total production​ costs, week 1 gross​ revenue, and week 2 gross revenue. Which of the following would least likely form a data series in a column​ chart?

A. Week 1 gross revenue
B. Movie names
C. Week 2 gross revenue
D. Production costs

Answer 3

B. Movie names

Question 4

You want to create a single chart that shows the proportion of yearly sales for five divisions for each year for five years. Which type of chart can accommodate your​ needs?

A. ​100% stacked column chart
B. Pie chart
C. Clustered column chart
D. Surface chart

Answer 4

A. ​100% stacked column chart

Question 5

Currently, a column chart shows values on the value​ axis, years on the category​ axis, and state names in the legend. What should you do if you want to organize data with the states on the category axis and the years shown in the​ legend?

A. Switch the rows and columns in the chart.
B. Change the chart type to a​ dual-axis chart.
C. Apply a different chart layout and chart style.
D. Set chart filters to exclude states in the legend.

Answer 5

A. Switch the rows and columns in the chart.

Question 6

What type of chart would display the names of seven city names​ (such as Jefferson City and Salt Lake​ City) on a category axis that is the easiest to​ read?

A. Line chart
B. Bar chart
C. Column chart
D. Pie chart

Answer 6

B. Bar chart

Question 7

Why would you add Alt Text to a combo​ chart?

A. To display data labels that show exact values for each data point in the chart
B. To include the axes titles for the primary and secondary axes
C. To provide an alternative chart title with more information
D. To adhere to accessibility compliance for screen reader capabilities

Answer 7

D. To adhere to accessibility compliance for screen reader capabilities

Question 8

You created a worksheet that tracks data for a basketball team. The range​ B10:F10 contains the difference in final points between your team and the other team. What is the recommended sparkline to create to represent this​ data?

A. ​Plus/Minus
B. Column
C. Line
D. Win/Loss

Answer 8

D. Win/Loss

Question 9

What is an advantage of using the Recommended Charts​ command?

A. The recommended chart includes a custom chart title that reflects the dataset.
B. The recommend chart is always the best way to represent the dataset.
C. Using Recommended Charts automatically inserts a chart in an empty range in a worksheet.
D. The Insert Chart dialog box displays recommended chart types based on the selected data.

Answer 9

D. The Insert Chart dialog box displays recommended chart types based on the selected data.

Question 10

Which chart element should you display to show exact values for a data series in a bar​ chart?

A. Legend
B. Data labels
C. Value axis title
D. Chart title

Answer 10

B. Data labels