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
icon
Related questions
Question
45
53
B
2/1/2021
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
D
2/3/2021
Sample Answer
F
Gantt Chart: Development of web page
2/5/2021
2/7/2021
2/9/2021
G
2/11/2021
H
2/13/2021
2/15/2021
2/17/2021
L
M
Transcribed Image Text:45 53 B 2/1/2021 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 D 2/3/2021 Sample Answer F Gantt Chart: Development of web page 2/5/2021 2/7/2021 2/9/2021 G 2/11/2021 H 2/13/2021 2/15/2021 2/17/2021 L M
F
D
G
A B
H
с
1 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.
2 The minimum and maximum value of the horizontal axis should be 44228 (start date numbe format) and 44244 (end date number format).
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
Activity
A
B
с
D
E
F
G
H
I
Activity description
Determine user needs
Review software and languages
Purchase software
E
Table 1: Development of web page
Duration
(days)
2
=
Design format and style
Write programs
Review outcome product with user
Make revisions
Select server site
Install on server and test
2
=
1
=
3
=
5
=
1
2
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/4/2021
2/3/2021
2/7/2021
2/4/2021
2/7/2021
2/12/2021
sjever
2/12/2021
2/13/2021
2/13/2021 2/15/2021
2/13/2021
2/14/2021
2/15/2021 2/17/2021
End Date
Start date in number form
End date in number forma
K
44228
44244
L
M
N
▼
0
44228.00
44244.00
P Q
Transcribed Image Text:F D G A B H с 1 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. 2 The minimum and maximum value of the horizontal axis should be 44228 (start date numbe format) and 44244 (end date number format). 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 Activity A B с D E F G H I Activity description Determine user needs Review software and languages Purchase software E Table 1: Development of web page Duration (days) 2 = Design format and style Write programs Review outcome product with user Make revisions Select server site Install on server and test 2 = 1 = 3 = 5 = 1 2 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/4/2021 2/3/2021 2/7/2021 2/4/2021 2/7/2021 2/12/2021 sjever 2/12/2021 2/13/2021 2/13/2021 2/15/2021 2/13/2021 2/14/2021 2/15/2021 2/17/2021 End Date Start date in number form End date in number forma K 44228 44244 L M N ▼ 0 44228.00 44244.00 P Q
Expert Solution
steps

Step by step

Solved in 3 steps with 2 images

Blurred answer
Knowledge Booster
Form
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.
Similar questions
Recommended textbooks for you
Database System Concepts
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)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education