TestOut Office Pro – Excel Videos 5.8.1 & 5.8.2 (15)

What is the main purpose of using charts in data representation?

• To make data more confusing

• To visually represent data and spot trends

• To hide data

• To delete data

What is a clustered column chart also known as?

• Line graph

• Pie chart

• Bar graph

• Scatter plot

How can you resize a chart in Excel?

• By clicking the delete button

• By dragging the corners

• By changing the font size

• By using the eraser tool

What happens to data labels when you change the chart type?

• They are highlighted

• They are lost

• They are duplicated

• They are printed

Which button allows you to add data labels and a color legend to a chart?

• Minus (-) button

• Brush button

• Plus (+) button

• Star button

What can you do with the brush button in chart formatting?

• Change the chart style

• Erase the chart

• Print the chart

• Save the chart

How can you add new data to an existing chart?

• By clicking the delete button

• By dragging colored boxes

• By changing the font size

• By using the eraser tool

What is the recommended starting point for creating a chart?

• The Home tab

• The Recommended Charts button

• The File tab

• The View tab

What type of chart is created when converting a bar graph using the pie chart button?

• Line chart

• Simple pie chart

• Scatter plot

• Area chart

What is the benefit of using charts according to the document?

• To make data more complex

• To visually represent data and spot trends

• To hide data

• To delete data