What are the key steps to prepare data for creating a chart in Excel?

Ensure data is presented correctly, including selecting the appropriate range of cells that contain the data and row headings for axis labels.

Which is used to select a range of cells?

Shift Key

True or False: A bar chart presents data in vertical columns.

False. A bar chart presents data in horizontal bars, while a column chart presents data in vertical columns.

What type of chart gets created automatically after selecting a chart type in Excel?

Excel automatically creates and inserts the selected chart type onto your worksheet.

Fill in the blank: A column chart is a type of chart that presents data in ___ columns.

Vertical

Riddle: I can show changes over time, displayed in bars or columns. What am I?

A chart.

What should you do if you want to change the chart type after creating it in Excel?

You can select a different chart type from the chart options available in the Insert menu.

Why is it important to include row headings when preparing data for a chart?

Including row headings is important because they serve as axis labels in the finished chart, helping to identify the data being represented.

What are the three types of cell references used in Excel formulas?

The three types of cell references used in Excel formulas are relative, absolute, and mixed.

In a relative reference, when a formula is copied to another location, what happens to the cell reference?

Excel updates the cell reference inside the formula to reflect its new position.