Exam 9: Excel 4: Working With Charts

Excel includes three kinds of 3-D chart types. ____________________​

Sub gridlines show the values between the tick marks in a chart. _________________________

A bar chart and column chart are equivalent chart types in Excel.

Describe four commonly used Excel chart types.

In a true 3-D chart, a third axis, called the _____, lets you compare data points across both categories and values.​

Which chart type is the best candidate for emphasizing sales trends over a period of 6 months?

Dragging a chart object to a new location on the worksheet will change the data in the worksheet.

You can use the Quick Analysis tool to create a sparkline.​

To delete a selected sparkline from a cell, click the _____ button in the Group group on the Sparkline Tools Design tab.​

Which chart type do you use to compare distinct objects over time using horizontal bars?

____ lets you create diagram types including List, Process, Cycle, Hierarchy, Relationship, Matrix, and Pyramid.

You can create multiple charts based on the same worksheet data.  ____________________

You can use buttons on the Insert tab of the Ribbon to create a chart.

WordArt can be created using the Chart Tools Format tab.

Explain what a combination chart is and how you can create one.

You can ____ the chart title text to select it.

The Chart Elements button makes it eas y to add, remove, and modify individual chart objects.​

Critical Thinking Questions Case 1-1 You are the manager of the Sales department for a local clothing store that has three locations. You have prepared a worksheet containing data about the sales figures for the company, which also has a chart to illustrate of the data. In the chart, you want to change the fill of one of the data series in your worksheet. To do this, what list arrow do you use?

A pie chart ____.

To switch a chart's columns and rows, click the ____________________ button in the Data group on the Chart Tools Design tab.