WEEK 1 TUTORIAL
1.Stock Watcher for Mydin
Zamri has created a basic stock watcher worksheet for Mydin that the uses to report on gains or losses from when the company purchased the stock and the last recorded date and price. Since Zamri is busy with other task, he has given you a snapshot of his spreadsheet (see Figure below) that you can use to recreate this spreadsheet for yourself. Here are some basic steps to follow: 1. Create a new workbook 2. Enter all the information provided in figure below. 3. Apply the Currency format to the respective columns 4. The data should be entered as a function. 5. Enter a formula for Gain/Loss (%) column 6. Format the percent in the Gain/Loss (%) column

2. Total ToyStory
ToyStory, Inc is a regional pet toy supplier that tracks its businesses sales in a spreadsheet. The owner, Douglass Tatnall, has provided you with a skeleton worksheet, ToyStory_Data.xls (see below), with the totals for each quarter by sales region. Tatnall needs you to total each column and row, and then provide her with a clustered column chart of each region by quarter. Regional Sales Summary | | | | | | | 1st Quarter | 2nd Quarter | 3rd Quarter | 4th Quarter | Northeast | $ 119,900.00 | $ 125,170.00 | $ 133,700.00 | $ 139,550.00 | South | $ 50,000.00 | $ 52,000.00 | $ 49,601.00 | $ 54,500.00 | Midwest | $ 34,800.00 | $ 32,200.00 | $ 47,900.00 | $ 45,900.00 | West | $ 56,250.00 | $ 49,580.00 | $ 52,900.00 | $ 51,360.00