Creating and Understanding Charts in Excel

This video tutorial guides students through the process of creating a graph in MS Excel. It begins with an overview of the task, followed by detailed instructions on creating a table, calculating averages, and inserting a graph. The tutorial also covers customizing and moving the chart, as well as understanding its components like axes and legends. Students are encouraged to create different types of charts and ask questions if needed.

What is the main purpose of this video tutorial?

• To explore advanced Excel functions

• To understand the history of graphs

• To learn how to create a graph in MS Excel

• To learn about data security

What is the first step in creating a graph in MS Excel?

• Open a web browser

• Open MS Word

• Open MS Excel

• Open a PDF reader

What should you include in the table for creating a graph?

• Student names and marks

• Teacher names and subjects

• Classroom numbers and sizes

• School names and locations

How do you calculate the average in MS Excel?

• By using a calculator

• By using a ruler

• By writing a formula

• By guessing

What is the first action to take when inserting a graph?

• Close the application

• Email the file

• Select the table

• Print the document

Where do you find the option to insert a chart in MS Excel?

• In the File tab

• In the Insert tab

• In the View tab

• In the Home tab

Which chart type is recommended in the tutorial?

• Pie chart

• Column chart

• Histogram

• Scatter plot

What can you do with the chart after creating it?

• Ignore it

• Delete it immediately

• Print it without viewing

• Move it to any location

What is displayed on the y-axis of the chart?

• Marks

• Student names

• Grades

• Subjects

What is displayed on the x-axis of the chart?

• Subjects

• Grades

• Student names

• Marks