Charts, Tables & Visual Data Flashcards

In Microsoft Excel, which chart type is best suited for showing trends over time with continuous data?

Answer: Line chart

Line charts are ideal for displaying trends over continuous time periods because the connected points show the direction of change.

In Excel, what must you do before creating a chart from worksheet data?

Answer: Select the data range you want to include in the chart

You must first select the data range so Excel knows which values to plot in the chart.

Which type of chart is most appropriate for displaying the percentage contribution of each category to a whole?

Answer: Pie chart

Pie charts display each category as a slice of the whole circle, making proportions and percentages easy to visualize.

In Microsoft Word, how do you insert a table with a specific number of rows and columns?

Answer: Insert tab > Table > Insert Table (specify rows and columns)

The Insert tab contains the Table command where you can use 'Insert Table' to specify exact row and column counts.

In an Excel chart, what is the 'Legend' used for?

Answer: To identify the data series represented by different colors or patterns

The legend is a key that identifies each data series in the chart by associating colors or patterns with series names.

In Excel, how do you change the chart type of an existing chart?

Answer: Right-click the chart and select 'Change Chart Type'

Right-clicking an existing chart provides the 'Change Chart Type' option to switch to a different chart style without recreating it.