Step 5 – Plot a graph using the values you have found. It should go from – 2 to 2 on the x axis, and from 0 to 4 on the y axis. Step 6 – Plot the points from your table on the graph.

You can also alter the values in the table, and see how these impact the graph. If you don't want values to change, learn how to lock cells in Microsoft Excel.

A linear equation is drawn as a straight line on a set of axes. To draw the graph we need coordinates. We generate these coordinates by substituting values into the linear equation.

Calculated tables are helpful tools when you want to add calculated values to the model instead of calculating them on the fly.

Here's how to create a pivot table in Excel to slice and dice your data, letting you perform in-depth analyses and spot important trends.

Pivot tables in Google Sheets summarize smaller sets of data from a more extensive dataset and can be sorted by rows, columns, values, and filters.