Flexible Interactive Workbooks in Excel

Tutorial 2

Setting up the settings sheet

It is now time to create the settings worksheet. This will contain all of the information required by the main worksheet, but that the student does not need to see.

For this workbook, a table containing references, the units for conversion and the conversion factors is required.

The following steps will work through the stages described above.

  1. Create the table

    • Make sure that the settings worksheet is selected, then enter the information as it is seen in fig. 5. Alternatively, you can copy and paste from the table below.

      • 1 cm inches 0.393701 2.54
      2 cm feet 0.032808 30.48
      3 m feet 3.28084 0.3048
      4 km mile 0.621891 1.608
      5 grams ounces 0.035274 28.34952
      6 kg pounds 2.204623 0.453592
      7 litres pints 1.759754 0.568261
      8 litres gallons 0.219969 4.54609
      9 £ $ 1.89063 0.528924
      10 £ 1.48938 0.67142

Now move on to Step 3