Spreadsheet - Fractions

Task

Create a spreadsheet that solves problems involving fractions.

Instructions

(a) Create a new spreadsheet, called "Fractions.xlsx".

(b) On part of your spreadsheet, design a section that performs fraction multiplication. For each fraction that needs to be input or shown, use two cells (one cell for the numerator, one for the denominator).

(c) Design a second section that performs fraction division.

(d) Design a second section that performs fraction addition.

(e) Design a second section that performs fraction subtraction.

(f) Can you use Excel to perform fraction "cancelling down"? If you can, incorporate this into the four calculation sections of your spreadsheet.