Excel Graphing and Data Management

The video tutorial guides viewers through creating a predator paragraph in Excel. It starts with opening Excel and entering data, followed by highlighting the data and creating a scatter plot graph. The tutorial explains how to adjust the graph by formatting data series and using a secondary axis to better display variations. It also covers adding titles and labels for clarity and concludes with instructions on saving the graph.

What is the first step in creating a predator paragraph in Excel?

• Save the Excel file

• Enter data for wolves and moose

• Create a scatter plot

• Open Excel and choose a workbook

What should you do after entering data in Excel?

• Create a pie chart

• Highlight the data

• Save the workbook

• Print the document

Which type of chart is used to display the predator data?

• Scatter plot

• Pie chart

• Line chart

• Bar chart

What does the red line in the graph represent?

• Yearly data

• Predator data

• Moose population

• Wolf population

How can you better display the variations in the wolf population on the graph?

• Add more data points

• Change the chart type

• Use a primary axis

• Use a secondary axis

What is the purpose of using a secondary axis in the graph?

• To change the chart color

• To better display variations in data

• To simplify the graph

• To add more data sets

What should you do to add labels and titles to the graph?

• Use Quick layouts

• Delete the existing graph

• Add a new worksheet

• Change the chart type

How can you change the titles on the graph?

• Right-click and select 'Edit'

• Select 'Format' and then 'Title'

• Use the 'Insert' menu

• Double-click and type the new title

What is the final step after completing the graph?

• Save the graph

• Close Excel

• Share the graph

• Print the graph

Where can you save the completed Excel file?

• Only in the cloud

• Only on the desktop

• On a flash drive, desktop, or folder

• Only in the Excel app