5 7 B 0 1 2 3 5 6 7 8 9 0 1 2 A B D E F H Table 1 has the activities listing along with their description, duration, preceding activities, start and end dates. Gantt chart is useful in visualizing the activities 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=xsxi4qaEnog (a) Using the data in Table1, create a Gantt chart in the range B17:K33 to display the timeline of project activities. Excel stores 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. The minimum and maximum value of the horizontal axis should be 44228 (start date numbe format) and 44244 (end date number format). Activity A B C D 2 E F G H I Table 1: Development of web page Duration (days) 2 + 2 1 Activity description Determine user needs Review software and languages Purchase software Design format and style Write programs Review outcome product with user Make revisions Select server site Install on server and test 3 5 1 2 1 2 Preceding activities B A, C D E F G Start Date 2/1/2021 2/1/2021 2/3/2021 2/3/2021 2/3/2021 2/4/2021 End Date 2/4/2021 2/7/2021 4/9/2021 2/7/2021 2/12/2021 2/12/2021 2/13/2021 2/13/2021 2/15/2021 2/13/2021 2/14/2021 2/15/2021 2/17/2021 Start date in number form End date in number forma 44228 44244

Computer Networking: A Top-Down Approach (7th Edition)

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...

See similar textbooks

Related questions

Question

(a) Using the data in Table1, create a Gantt chart in the range B17:K33 to display the timeline of project activities.
Excel stores 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.
The minimum and maximum value of the horizontal axis should be 44228 (start date numbe format) and 44244 (end date number format).

Screenshot attached below

thanks