There is a new bike available for hire. The daily charge for a Dragonfly ladies bike is £10.00 and the daily cost is £2.00.

1. Insert a row in your booking form. It must be the row directly above the Lazybones bike.

2. Add the details for this new bike.

3. Save the spreadsheet.

4. In a header label the printout NEWBIKE.

5. Print a copy of your spreadsheet showing the formulae. Make sure it fits on one A4 sheet.

Joanne, from Smarts, likes the booking form but wants the daily charges to appear before the numbers required.

1. Use cut/copy and paste to swap these two sets of data.

2. Re-save the spreadsheet.

3. In a header label the printout NEWORDER.

4. Print a copy of the booking form on one A4 sheet.

Joanne wants to know how much profit each item makes.

1. Open your BOOKING spreadsheet.

2. Find the column after the "Total" column and put in a new heading called "Daily Cost"

3. Enter the daily cost for each item from Table 7.1.  The daily cost for the Dragonfly bike is £2.00.  *These numbers are how much it costs Smarts to buy and look after these items on a daily basis.

4. Enter the new heading, "Total Item Cost", in the column beside the "Daily Cost" column.

5. In the first column under the "Total Item Cost" heading enter a formula to calculate the cost of hiring your items.

   1. You will need to multiply the number of items being hired by the daily cost of each item.

   2. Remember to type an equals sign to start your formula.

   3. Remember that this * is the multiply sign.

6. Copy this formula to the rest of the column.

7. At the bottom of the "Daily Cost" column put the title "Total Cost".

8. Enter a function to calculate the total cost of all of the items. *This is the cost to Smarts for all of the items rented.

9. In the column beside the "Total Item Cost" put the heading "Profit"

10. Enter a formula in the cell under the "Profit" heading to calculate the profit made on each item.

    1. To find the profit you will need to subtract the "Total Item Cost" from the "Total".

    2. Remember to type an equals sign to start your formula.

    3. Remember that this - is the subtract sign.

11. Copy this formula to the rest of the cells in the column.

12. Save the sheet on your floppy disk and in your My Documents folder.

13. In the header label the printout PROFIT.

14. Print a copy of your spreadsheet showing the formulae used. Make sure it fits on one A4 sheet.