Microsoft Office Tutorials and References
In Depth Information
13. Go to the Stock Values worksheet. Add a column sparkline to cell B2 to display the
Shares Traded values in the range B4:B33.
14. Add a line sparkline to cell F2 to display the closing values of the stock over the
15. In the range G3:G33, create a new column of values named Difference that is equal
to the difference between the stock’s closing value and its opening value on each
day. Display the difference values using the same format as in column F.
16. Add a win/loss sparkline to cell G2 that indicates the days that the stock gained
value and the days that the stock lost value.
17. Save and close your workbook, and then submit the ﬁ nished workbook to your
instructor, either in printed or electronic form, as requested.
Case Problem 4
Create an Excel
provide a report
on a sporting
Data File needed for this Case Problem: Basketball.xlsx
Blowout Sports Steve Eagan is the owner and operator of Blowout Sports, a sports
information and scouting company located in Lexington, Kentucky. One of Steve’s jobs
is to provide detailed graphical reports and analysis of college basketball games for
the media, coaches, and interested fans. Steve has been placing box score data and
game logs into an Excel workbook. He wants to summarize this data in one worksheet
using charts and graphs. He’s asked you to help develop the workbook. Steve has a
sample workbook containing the results of a recent basketball game for you to work on.
Complete the following:
1. Open the Basketball workbook located in the Excel4\Case4 folder included
with your Data Files, and then save the workbook as Basketball Report . In the
Documentation sheet, enter your name in cell B3 and the date in cell B4.
2. The Game Log worksheet contains the minute-by-minute score of the game. Use
the data in this worksheet to create a line chart describing the ebb and ﬂ ow of the
game that is embedded in the Game Report worksheet. The format of the chart is up
to you, but it should include titles for the chart and the axes, a chart legend overlay,
vertical gridlines spaced at 4-minute intervals, and horizontal gridlines at 5-point
intervals. ( Hint : To display vertical gridlines at 4-minute intervals, you must turn off
the multi-level category labels.)
3. The Box Score worksheet contains statistical summaries of the game. Use the data
in this worksheet to create two column charts describing the points scored by each
player on the two teams. Embed the charts in the Game Report worksheet. The
format of the charts is up to you, but it should include titles for the chart and axes, and
gradient ﬁ ll colors for the columns.
4. The Box Score worksheet also contains team statistics. Use this data to create several
pie charts that compare the two teams. Embed the pie charts in the Game Report
worksheet. The ﬁ nal pie charts should include data labels for the pie slices and slice
colors that match the team’s colors (red for Wisconsin, gold for Iowa).
5. The Season Record worksheet contains a record of each team’s season including
wins and losses. Use this data to create a win/loss sparkline displayed on the Game
Report worksheet alongside each team’s season record.