MS-Excel sheet job 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.
You can use your imagination for all the manipulations and chart work.
Table with data
Location | January | April | July | October |
Acapulco | 10 | 5 | 208 | 145 |
Amsterdam | 69 | 53 | 76 | 74 |
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.2 | 65.4 | 71 | 63.5 |