BSAB1C-ELEC1 (FQuiz1)

What is a key difference between a Column Chart and a Bar Chart?

• Column charts use vertical bars, while bar charts use horizontal bars.

• Column charts are only for percentages, while bar charts are for whole numbers.

• Bar charts show trends over time, while column charts do not.

• Column charts show proportions, while bar charts do not.

Line charts are best suited for:

• Comparing proportions

• Showing trends over time

• Displaying 3D landscapes

• Grouping data by category

The legend in a chart:

• Provides a description of the chart

• Displays values on the x-axis

• Identifies different data series by color

• Shows proportions in a pie chart

If you want to move a chart to a new worksheet, you should:

• Drag and drop the chart

• Use the Move Chart command on the Design tab

• Change the chart style

• Update the data range

What chart type is best used to show proportions of a whole?

• Bar Chart

• Column Chart

• Line Chart

• Pie Chart

Which chart type allows you to display data across a 3D landscape?

• Pie Chart

• Surface Chart

• Column Chart

• Area Chart

What command can you use to add predefined chart layouts?

• Add Chart Element

• Recommended Charts

• Chart Styles

• Quick Layout

In an Area Chart, what is unique about its data display?

• It uses horizontal bars.

• It shows data as slices.

• It fills in the area under the lines.

• It shows data as points on a 3D surface.

What do you call the part of a chart that measures values on the y-axis?

• Legend

• Horizontal Axis

• Data Series

• Vertical Axis

In what scenario would a Pie Chart not be suitable?

• Comparing proportions of a whole

• Tracking monthly sales

• Showing percentages of categories

• Illustrating parts of a total