Mastering Graphs and Charts in Microsoft Excel

The video tutorial explains the changes in Microsoft Excel 2007 for creating charts, highlighting the removal of the wizard and the introduction of a more automated process. It demonstrates how to set up data, create a basic column chart, customize styles, add labels and titles, and move charts to their own sheets. The tutorial emphasizes the ease of creating charts with a single click while still allowing for customization and updates.

What major change was introduced in Excel 2007 for creating charts?

• The chart wizard was enhanced with more features.

• The chart creation process was automated to a single click.

• Charts can only be created using templates.

• Charts are no longer supported in Excel 2007.

What is the first step in creating a simple column chart in Excel 2007?

• Open the chart wizard.

• Highlight the table without including titles or totals.

• Select the entire worksheet.

• Download a chart template.

What is a downside of the new chart creation process in Excel 2007?

• Charts are automatically included as objects within the sheet.

• It requires multiple steps to create a chart.

• Charts cannot be customized at all.

• Charts are not linked to the data.

How can you move a chart to a separate sheet in Excel 2007?

• By dragging the chart to a new sheet.

• By using the 'Move Chart' option.

• By copying and pasting the chart.

• By saving the chart as a new file.

Which menu appears when you select a chart in Excel 2007 for customization?

• Format Painter

• Chart Wizard

• Data Tools

• Chart Tools

What can you do to increase the space for your graph in Excel 2007?

• Add more data series.

• Increase the font size of labels.

• Delete the legend if it's not needed.

• Add a data table below the chart.

How can you add titles and labels to your chart in Excel 2007?

• By inserting text boxes manually.

• By editing the data source.

• By using the 'Data Tools' menu.

• By using the 'Quick Layout' option.