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

Question

chart. What button should she look for to make this change?
(1 point)
Hidden and Empty Cells
Format Axis
Change Chart Type
Add Chart Element

Answer 1

Yvonne should look for the "Hidden and Empty Cells" button to make the change to skip missing data and connect the next data point on her line chart.