The Complete Excel Guide: Beginners to Advanced - Exercise 9

The video tutorial covers Exercise Nine, focusing on Microsoft stock prices. It explains how to access and analyze stock data, create win loss sparklines, and plot stock prices using charts. The tutorial also includes a challenge to automate chart and sparkline updates, encouraging further exploration and practice with data visualization tools.

Where can you find the Microsoft stock prices data for Exercise Nine?

• In a library database

• In the instructor's personal files

• In the course textbook

• On Yahoo Finance and other financial websites

What is the main focus of the first part of Exercise Nine?

• Calculating average stock prices

• Analyzing historical stock trends

• Creating a pie chart

• Developing a win-loss sparkline

How should the sequence of data be arranged for the win-loss sparkline?

• Newest values on the left, oldest on the right

• Random order

• Oldest values on the left, newest on the right

• Alphabetical order

What is the final task in Exercise Nine?

• Writing a report

• Plotting stock prices on a chart

• Plotting a pie chart

• Creating a histogram

What additional challenge is suggested at the end of Exercise Nine?

• Automating the chart and sparkline updates

• Writing a summary report

• Designing a new exercise

• Creating a new dataset