Graphing Tides in Excel

The video tutorial guides students through graphing tides in the Bay of Fundy using Excel. It covers data preparation, creating scatter plots, adding data series for high and low tides, and finalizing the chart with titles and labels. The process concludes with copying the chart to Word and saving the document.

What is the primary task described in the video tutorial?

• Designing a bar chart for sales data

• Analyzing temperature changes over a year

• Creating a pie chart of rainfall data

• Graphing the tides in the Bay of Fundy using Excel

What should you do if you see number signs in the Excel columns?

• Change the font size

• Double-click to adjust the column width

• Insert a new row

• Delete the column

Which type of chart is used to graph the tides?

• Scatter plot with smooth curves

• Line chart

• Bar chart

• Pie chart

What should be selected as the X Series values for the high tide series?

• The name at the top

• The dates

• The high tide values

• The low tide values

What is the series name for the second data series added to the chart?

• Tide difference

• Average tide

• Low tide

• High tide

What should you do after adding both data series to the chart?

• Add titles to the chart

• Change the chart type

• Delete the chart

• Insert a new worksheet

Where should the chart title be placed?

• Below the chart

• To the right of the chart

• Above the chart

• To the left of the chart

What should be the title for the vertical axis?

• Bay of Fundy

• Tide level in meters

• High tide

• Date

After completing the chart, where should it be pasted?

• In Microsoft Word

• In a PowerPoint presentation

• In a new Excel sheet

• In an email

What is the final step after pasting the chart into Microsoft Word?

• Print the document

• Email the document

• Delete the document

• Answer analysis questions and save the document