Spreadsheets - Complex Formulas

Objective:

To be able to transform an arithmetic expression into a computerized formula.

Activity 1:

1. Watch the demonstration carefully.
2. Discuss queries.

Activity 2:

1. Download the Activity file from HERE.
2.  Follow the instructions in the file.
3. Save your file in your folder on D drive.

Spreadsheets - Arithmetic Operations

Objectives:

1. To be able to use excel formulas to solve real life basic arithmetic problems.

Task 1:

1. Download Task 1 File.
2. Complete Activities on all 3 sheets.
3. SAVE file in your folder.

Task 2:

1. Download Task 2 File.
2. Make it a complete shopping bill.
3. SAVE file in your folder.
4. Hints:
• Recall what do you see on the shopping bills from any mall?