Multiple Choice
Let's suppose you have a data set reporting the sales of five different product categories across the columns, and for each of the past four quarters, listed across the rows. Which of the following use of Sparklines would be the most appropriate?
A) Column Sparklines to compare quarterly sales across product categories and time series for each product category.
B) Line Sparklines to visualize quarterly sales across product categories and time series for each product category.
C) Line Sparklines to visualize quarterly sales across product categories, and Column Sparklines to compare time series for each product category.
D) Column Sparklines to compare quarterly sales across product categories, and Line Sparklines to visualize time series for each product category.
Correct Answer:

Verified
Correct Answer:
Verified
Q11: How many types of Sparklines are available?<br>A)
Q12: Elaborate on the use of geographic data
Q13: Which of the following charts shows three-dimensional
Q14: Describe how to and construct a scatter
Q15: Peige, a stock broker, has data consisting
Q17: After choosing the PivotTable, the PivotChart can
Q18: What is a Key Performance Indicator?<br>A) A
Q19: Use the data given below to
Q20: Which of the following charts provides a
Q21: How does Excel distinguish between vertical and