Using Excel to Graph Linear Functions
This storyboard does not have a description.
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