the problem is ” Jane is driving down the road at 45 miles per hour.” the formual for this is distance= rate x time.

how do i change the linear equation of this problem into an Excel formula? what are the steps and functions to get a linear equation into a Excel formula?

Put a number into A1 representing the time (say 0 hours).

Put the following formula into B1 representing the distance:

=45*A1

You can create a table of values by copying the cells down to later rows. Change the value in the first column (A) and column B should be recalculated automatically.

A B

0 0

1 45

2 90

3 135

4 180

etc.