Three examples of resistors: in series, parallel and series/parallel.
User selects the values of the resistances and voltage. Spreadsheet calculates the total resistance and the current.
Demonstrates the relationships between the resistances of the components and the total resistance depending upon the configuration (series / parallel).
[Updated with 'cleaner' version of spreadsheet]