Using Excel to Graph Linear Functions

Using Excel to Graph Linear Functions
  Copy


More Options: Make a Folding Card




Storyboard Description

This storyboard does not have a description.

Storyboard Text

  • Excel is a spreadsheet program with columns and rows that meet to form cells, which may be used to form a T-chart to aide in graphing functions.
  • First, enter data representing x starting in cell A1 and going down the column.
  • Name the data, x, by dragging your mouse to highlight the data, then going to the tool bar>formula>define name.
  • Go to cell B1, and define a function for the data, starting with an equal sign, and using x to represent the data in the first column.
  • Complete the chart by dragging the small box in the lower right hand corner of B1 down the column even with the data in column A.
  • Graph the data by highlighting the completed chart, then going to the tool bar>insert>scatter plot.
Explore Our Articles and Examples

Try Our Other Websites!

Photos for Class   •   Quick Rubric   •   abcBABYart   •   Storyboard That's TPT Store