Spreadsheet+L+5




 * Lesson Five - Building a Formula**

Enter the following data into a spreadsheet and then derive a **formula** to find the cost of each item, as well as the total cost of the entire order.

To do this you must first select the cell in which you want the answer to go and then type In the correct formula. Inside of using a predefined formula (like =sum or =average) you will have to construct one.

A spreadsheet operates exactly the same way as if you were doing math problems. For example in or to get a spreadsheet which would automatically determine the cost of multiple items such as found below. You would have to set up your formulas like this; 3 || Grapple Grommets || $0.19 || 200 || =B3*C3 || Copy the spreadsheet below and insert formulas where needed. You will also have to put in a formula to calculate GST (7%) and PST(6%) as well as the TOTAL. This assignment will require that you think.
 * || A || B || C || D ||
 * 1 || Item || Single Price || Quantity || Total ||
 * 2 || Shoe Horn || $1.99 || 3 || =B2*C2 ||
 * 4 ||  ||   ||   ||   ||