Creating a Gantt Chart in Excel

What is the primary purpose of a Gantt chart in project management?

• To evaluate project risks

• To monitor project progress

• To manage team communication

• To track financial expenses

Which column in the Excel worksheet contains the estimated duration for each task?

• Column D

• Column B

• Column C

• Column A

What Excel function is used to calculate the completion date while excluding weekends?

• NETWORKDAYS

• WORKDAY

• DATEDIF

• EDATE

Why is it necessary to change the date format to 'General' before creating a stacked bar chart?

• To ensure dates are treated as numbers

• To make the chart colorful

• To add more data columns

• To simplify the chart creation process

Which type of chart is used as the base for creating a Gantt chart in Excel?

• Pie Chart

• Line Chart

• Stacked Bar Chart

• Scatter Plot

How can you reverse the order of tasks in the Gantt chart to match the table?

• By sorting the data

• By using a filter

• By checking 'Categories in reverse order'

• By changing the chart type

What is the purpose of setting the minimum and maximum bounds for the date axis?

• To add more tasks

• To remove unnecessary gaps

• To change the chart color

• To increase the chart size

How can you make the chart title dynamic in Excel?

• By typing it manually

• By using a text box

• By linking it to a cell with a formula

• By changing the font size

What adjustment is made to track each individual week instead of 10-day intervals?

• Adjust the major unit to 7

• Use a different color scheme

• Change the chart type

• Add more data points

What happens when you update the title in the table linked to the chart?

• The chart title changes color

• The chart title remains unchanged

• The chart title updates automatically

• The chart title disappears