Final answer:
To insert a column type sparkline in cell B7, follow these steps: select cell B7, go to the 'Insert' tab, click on 'Sparklines', choose 'Column', specify the 'Data Range', and click 'OK'.
Step-by-step explanation:
To insert a column type sparkline in cell B7, you can follow these steps:
- Select cell B7 where you want the sparkline to be inserted.
- Go to the 'Insert' tab in the Excel ribbon.
- Click on the 'Sparklines' option in the 'Sparklines' group.
- Choose the 'Column' option from the Sparklines dialog box.
- In the 'Data Range' box, specify the range of data you want to use for the sparkline.
- Click 'OK' to insert the column type sparkline in cell B7.