Microsoft Excel is a useful program to help young students learn math. If you need to put together a worksheet with inequalities, you can use Excel to create a table of data points from an equation and then use the graph tool to display that equation graphically. To build an accurate graph, you will need a basic understanding of Excel functions, but even beginners will find the process fairly easy.
Video of the Day
Step
Create a column of data points in the "A" column. These data points should be evenly spaced apart but can be as small or as large as you want, depending on the range and domain of your graph. If you are unsure, using the numbers "-10" to "10" usually will suffice.
Step
Enter the equation of the inequality in cell "B1" and replace "x" with "A1." For example, if your inequality is y<3x, you would enter "=3*(A1)."
Step
Copy the contents of cell "B1."
Step
Paste the equation into the reset of the cells in the "B" column that correspond to your data points in the "A" column.
Step
Select both the data point cells and the equation cells.
Step
Click on "Line" under the Charts section of the Insert tab.
Step
Select the "2D line graph" option.
Step
Click on "Shapes" above the Illustrations header and select the "Freeform" tool.
Step
Draw a polygon that runs along the edge of the plotted line and along the edges of the chart area. Make sure it is placed properly above or below the equation, depending on the inequality.
Step
Select the polygon, click on the "Format" tab, click on "Shape Fill" and select "More Fill Colors."
Step
Adjust the color and transparency so that the shape shows up clearly on the graph.
