5 5 7 B 9 0 1 2 6 7 8 0 1 2 3 4 A D E F H J B 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 с D E F G H I Table 1: Development of web page Duration (days) 2 2 1 3 5 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 2 1 2 Preceding activities . B A, C D E F G Start Date 2/1/2021 2/1/2021 2/3/2021 End Date 2/3/2021 2/3/2021 2/4/2021 2/7/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 2/4/2021 2/7/2021 2/12/2021 Start date in number form End date in number forma 44228 44244 L M N Y O 44228.00 44244.00 P
5 5 7 B 9 0 1 2 6 7 8 0 1 2 3 4 A D E F H J B 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 с D E F G H I Table 1: Development of web page Duration (days) 2 2 1 3 5 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 2 1 2 Preceding activities . B A, C D E F G Start Date 2/1/2021 2/1/2021 2/3/2021 End Date 2/3/2021 2/3/2021 2/4/2021 2/7/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 2/4/2021 2/7/2021 2/12/2021 Start date in number form End date in number forma 44228 44244 L M N Y O 44228.00 44244.00 P
Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
Related questions
Question
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 3 steps with 2 images
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Recommended textbooks for you
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education