Data Handling - Assessment

Instructions:

1. Download file HERE
2. Follow instructions in Pink Sheet 1 and Pink Sheet 2
3. SAVE your file on desktop with the following filename format

                    <year><section>space<student name>
                  example          5D Asma

Data Handling Lesson 3

Calculating Total Profit 

Working with multiple worksheets in Excel

OBJECTIVES:

1. Describe the purpose of Profit and Loss calculation.
2. Calculate values available on other sheets.

Download Activity File

MS Excel - Adding Formulas (Prepare a Restaurant Bill)

Tune into the lesson objectives (5min):

Find Out What and How (10 min): 

Watch demonstration : How a digital spreadsheet helps in business calculations.
Question Time

Now try to calculate profit using a digital spreadsheet............. 
Link to download Activity 1 File