Annemarie lists 12 months of product sales data in the range A3:M7. The products are listed in the range A3:A7 and the monthly sales data in the range B3:M7. She wants to display a simple chart at the end of each row in column N to track the monthly sales for each product. What can she insert in the range N3:N7?
A) Line chart
B) Line sparklines
C) Scatter chart
D) Data bars

Question

Quizplus · Accepted Answer

Line sparklines would be the best choice since Annemarie wants to display a small chart at the end of each row to show the trend of monthly sales for each product. Line sparklines are small line charts that can be placed in a single cell, making them ideal for this purpose. The other options (Line chart, Scatter chart, Data bars) would not be appropriate for displaying the data in this way.

Annemarie Lists 12 Months of Product Sales Data in the Range