Which option adds column sparklines to cells F2:F11 to represent B2:E11 values?

Which option adds column sparklines to cells F2:F11 to represent B2:E11 values?

• A. Quick Analysis button, Sparklines, Column
• B. Insert tab, Sparklines, Line
• C. Data tab, Sparklines, Column
• D. Home tab, Styles, Sparkline

Answer: (A)

Sparklines are tiny charts placed in cells to show trends for a related data range. A column sparkline displays vertical bars in each cell, one per row, representing multiple values across columns for that row. To add column sparklines in F2:F11 that visualize B2:E11, you’d select the data range B2:E11, use the Quick Analysis tool that appears, choose Sparklines, pick Column, and set the destination range to F2:F11. This creates ten sparklines—one in each cell from F2 to F11—each representing the four values in its corresponding row (B2:E2, B3:E3, and so on). Other paths would either point to a different sparkline type (like a line sparkline) or use a different tab, which isn’t the quickest or provides the exact Column sparkline outcome for the specified destination.

Sparklines are tiny charts placed in cells to show trends for a related data range. A column sparkline displays vertical bars in each cell, one per row, representing multiple values across columns for that row.

To add column sparklines in F2:F11 that visualize B2:E11, you’d select the data range B2:E11, use the Quick Analysis tool that appears, choose Sparklines, pick Column, and set the destination range to F2:F11. This creates ten sparklines—one in each cell from F2 to F11—each representing the four values in its corresponding row (B2:E2, B3:E3, and so on).

Other paths would either point to a different sparkline type (like a line sparkline) or use a different tab, which isn’t the quickest or provides the exact Column sparkline outcome for the specified destination.