Answer :
Final answer:
To add column sparklines in the E9:E10 range, numerical data must be present in the B9:D10 range. Ungrouping sparklines separates them into individual elements, and the vertical axis maximum value can be adjusted to control the scale of the sparklines.
Explanation:
Sparklines can only be added to cells with numerical data. Therefore, in order to add column sparklines in the range E9:E10, the cells in the range B9:D10 must contain numerical data. You cannot add sparklines in the A column, so option d) is not correct.
The vertical axis maximum value affects the scale of the sparklines. By setting the maximum value to -15000 for cell E9 and -60000 for cell E10, you are controlling the scale of the sparklines. This allows you to adjust the range of values displayed on the vertical axis of the sparklines.
Ungrouping sparklines separates them into individual elements, meaning that each sparkline becomes independent and can be moved or modified individually. Therefore, option c) is correct.