IT Task-Using Excel

 

 

TABLE 1- PRICES OF SET DINING MENU / PER NIGHT IN NORTH WEST HOTELS FOR THE PERIOD OF THE COMMONWEALTH GAMES

 

Executive Class

Business Class

Standard Class

Economy Class

Total collective amount of Executive, Business, Standard and Economy class

Hotel A

£70

£50

£40

£29

£189

Hotel B

£65

£55

£39

£25

£184

Hotel C

£85

£65

£49

£39

£238

Hotel D

£49

£35

£25

£14

£123

Hotel E

£37

£30

£20

£15

£102

Hotel F

£51

£34

£29

£21

£135

Hotel G

£67

£57

£47

£37

£208

Hotel H

£34

£20

£14

£9

£77

Hotel I

£24

£15

£10

£8

£57

Hotel J

£20

£15

£8

£3

£46

Hotel K

£35

£23

£21

£15

£94

Hotel L

£41

£25

£20

£10

£96

 

Using Excel

1. Construct a column chart which shows all the Hotels a) For executive class, b) Standard class

For each chart – include a Chart Title, Category for the X axis, Category for the Y axis, Minimum Gridlines for the X axis, Major gridlines for the Y axis.

Bring back the charts into a word document Put into landscape and position to give the best results you can

 

click HERE to return to homepage