MS-Excel sheet sample work requires you to enter raw data into MS-excel worksheet cells and manipulate them for required formulation work, graphs, pivot tables and charts.
Here we are giving you a table of content/figures which you have to re-enter into an Excel worksheet, experiment some simple formulation work and then prepare a chat/graph of these given data on same worksheet.
You can use your imagination for all the manipulations and chart work.
Table with data
Location | January | April | July | October |
Acapulo | 10 | 5 | 234 | 423 |
Amsterdam | 69 | 53 | 76 | 69 |
Anchorage | 17 | 13 | 42.5 | 52 |
Dallas | 48 | 87.5 | 62 | 118 |
Glasgow | 110 | 50 | 61 | 112 |
Madrid | 39 | 48 | 11 | 53 |
New York | 99 | 100 | 115 | 86 |
Tokyo | 101 | 121 | 189 | 172 |
Toronto | 55.5 | 65.4 | 71 | 63.5 |