Question: You need to add a line chart showing a sales trends over the last 12 months and you have only a little space to work with. How can you convey the required information within a single cell?

  1. Add an image of the chart to a comment.
  2. Add a hyperlink to another worksheet that displays a chart when clicked.
  3. Add an image of the chart to the worksheet.
  4. Add a sparkline, a graphic that summarizes data visually within a single worksheet cell.

Answer: The correct answer of the above question is Option D:Add a sparkline, a graphic that summarizes data visually within a single worksheet cell.