Case 16-2 Since extensive data in the form of numbers can be difficult to assimilate, such data are better represented as charts. There are several types of charts available in Microsoft Excel. Choosing the right chart type to represent a data source is important to effectively illustrate a data. A chart type should be chosen based on the number of data series, range of data series values, type of data series etc.
Natalia, a weather reporter, wants to plot a graph using the rainfall data in the past 20 years in a particular state. She intends to present the graph in a single cell to identify the maximum and minimum rainfall. In this scenario, Natalia should use a _____ to represent her data.
A)surface chart
B)sparkline chart
C)radar chart
D)pie chart

Question

Case 16-2 Since extensive data in the form of numbers can be difficult to assimilate, such data are better represented as charts. There are several types of charts available in Microsoft Excel. Choosing the right chart type to represent a data source is important to effectively illustrate a data. A chart type should be chosen based on the number of data series, range of data series values, type of data series etc. ​
Natalia, a weather reporter, wants to plot a graph using the rainfall data in the past 20 years in a particular state. She intends to present the graph in a single cell to identify the maximum and minimum rainfall. In this scenario, Natalia should use a _____ to represent her data.
A)surface chart
B)sparkline chart
C)radar chart
D)pie chart

Quizplus · Accepted Answer

Sparkline charts are designed to be presented in a single cell, making them ideal for Natalia's need to display the rainfall data over 20 years in a compact form while highlighting the maximum and minimum values.

Case 16-2 Since Extensive Data in the Form of Numbers