WEB TUTORIAL

Introduction to using Excel 2013

Exercises

 

Instructions for Exercise 1:

  1. For Row 3 we are calculating the concentration and associated error of Solution 2 (which was made by diluting Solution 1). Therefore, the value (COld) in Cell B3 needs to be the concentration of Solution 1. However, rather than typing this number in by hand we can get Excel to copy the exact value across by entering in Cell B3    =+G2    (i.e. Excel will place in Cell B3 the calculated value from Cell G2).

    Similarly, the concentration error (sOld) for Solution 1 is entered in Cell C3 using the formula    =+J2

    Your spreadsheet should look like this:

  2. The concentration of Solution 2 was calculated using this equation:

  3. Equations used in this calculation:

  4. The numbers in the D, E & F columns will be the same for all the calculations, so highlight D2, E2 & F2 and copy them down to Row 6. Similarly, the formulae used to calculate the concentrations and errors are the same (just with different numbers), so also copy G2, H2, I2 & J2 down to Row 6. Finally copy B3 & C3 down to Row 6.

  5. Your spreadsheet should contain following formulas:

    Now you can go back to Exercise 1.