M N N 0 P Duration 44229.00 44228 44244 TA B D E H 1 Table 1 has the activities listing along with their description, duration, preceding activities, start and end cates. Gantt chart is useful in visualizing the activities timeline. Excel doesn't have a built-in Gantt chart. However, you can customize a bar chart to create the Gantt chart You can watch the following youtube video to create the Gantt chart in excel https://www.youtube.com/watch?v=x5x149ane (a) Using the data in Tablei, create a Gantt chart in the range #17:K33 to display the timeline of project activities. Excel scores the dates as serial numbers, Refer to cell K7, it is referring to cell G7, but cell K7 display format is number and hence we see date in number format. Themin minimum and maximum value of the horizontal axis should be 44228 (start date numbe format) and 44244 (end date number format). 5 Table 1: Development of web page Activity Activity description Preceding Start Date (days) End Dute activities A Determine user 2 2/1/21 2/3/21 Start date in number format B Review software and languages 2 2 2/1/21 2/3/21 End date in number format 9 Puntsolare 1 B 2/3/21 2/4/21 10 Design mand style A, 2/4/21 2/7/21 | 11 Write programs D 2/7/21 2/12/21 12 F Review vulome product with user 1 E 2/12/21 2/13/22 13 Make revisione 2 F 2/13/21 2/15/21 14 H Select server site 1 2/13/21 2/14/21 15 I lestall on severd tot 2 G 2/15/21) 2/17/21 16 17 18 19 20 21 22 23 24 3 44244.00 25 26 27 28 29 30 31 32 33 34