Yvonne is creating a line chart and wants Excel to skip all cells that are missing data and connect them to the next data point on the chart. What button should she look for to make this change?

Question

(1 point)
Responses

Hidden and Empty Cells
Hidden and Empty Cells

Format Axis
Format Axis

Change Chart Type
Change Chart Type

Add Chart Element
Add Chart Element

Answer 1

Yvonne should look for the Hidden and Empty Cells option to make the change so that Excel skips all cells that are missing data and connects to the next data point on the chart.