Excel Chapter 4 Study Guide

Front

Lisa's boss asks her to create a chart that shows the number of sales made by each salesperson for their top-five products. Which chart type does she create?

Back

column chart

Front

Felix created a chart but doesn't like how it displays his data. What advice would you give him?

Back

He can use the Change Chart Type tool to find a different chart.

Front

Jade wants to add a background to her chart. Which of these is NOT a chart background option? pattern, video, gradient, border

Back

video

Front

to move a chart, click anywhere in it and drag.

Back

false

Front

You cannot resize a chart after it's been moved to its own sheet.

Back

true

Front

How can Andrew adjust his column chart that uses more than 100 sets of data and has very small columns?

Back

Use the Chart Filters feature.

Front

You can add pictures, shapes, text boxes, and videos to a worksheet.

Back

false

Front

Conditional Formatting does what whenever new data is entered?

Back

Automatically updates

Front

To track his highest-earning employees, which conditional formatting rule does Kenny apply to his selected data?

Back

Top/Bottom Rules

Front

Lisa's boss asked her to create a chart showing the number of units sold for each of their tip-two items from month to month throughout the year. Which chart type does she create?

Back

line chart