Information Technology Center

Introduction To Microsoft Excel

Excel Lesson Three

A grocer records all the funds he receives from customers each month. He also records all the monies he spends called EXPENSES

Lesson Three - A Simple Sales & Expenses Worksheet

DESCRIPTION:

This lesson reenforces the use of sum function. Students learn how to calculate profit using Excel.

SPECIFIC OBJECTIVES:

At the end of the lesson students should be able to :

  1. Identify Sales and Expenses figures
  2. Calculate Profit
  3. Correctly use the Sum Function

Remember the Format for the SUM function

=SUM(first cell address : last cell address)

  1. Remember to start the function with the equal sign
  2. The word SUM follows the equal sign
  3. An open baracket is next followed by the address of the first cell in the range
  4. A colon comes next followed by a closing bracket

Sales & Expenses Worksheet

Activity 2

A B C D
1 Trinidad Wholesalers Ltd
2 January February March
3 Sales 50400 65875 60456
4 Expenditure 40356 45765 42348
5 Profit =B3-B4

  1. Go to Chapter 14 - Spreadsheets - Log On to IT for CSEC 3rd edition
  2. Complete Activity 1 on page 308 if you have not already done so
  3. Add the Label Profit in cell A5
  4. Place formulae in cells B5, C5 and D5 to subtract Expenditure from Sales
  5. Use the Sum function in column E where needed - E3, E4
  6. Save the file on your flash drive as Wholesalers

3.0 Change the Worksheet

  1. Change from 50400 in cell B3 to 54000
  2. Centre align all the values
  3. Change the orientation of the lables in cells B2, C2 and D2 to 45 degrees
  4. Wrap the lable in cell B1

What formula do you think should go in cell E3?

Use the SUM function in the range E3:E5. That is Cells E3, E4 and E5.

Test Yourself

Choose the correct answer
Questions Options Verify
 1)  Worksheet above has five rows and four columns True False
 2)  The value 40356 is located in cell C3 True False
 3)  The value 50400 is now located in cell B3 True False
 4)  Range B1:D1 contains labels. True False
 5)  We add Sales to Expenses to get profit. True False

Exercise 3

  1. Activity 2 must be completed before attempting this activity
  2. Use the Sum function in column E
  3. Change the Sheet name to QRT1
  4. Save the file on your flash drive

Activity 3

  1. Go to Log On To IT for CSEC chapter 14 - Spreadsheets - page 315
  2. Start a new sheet
  3. Enter the data as seen in Figure 14.24
  4. Follow the instructions from 1 to 10
  5. Rename the sheet Payroll
  6. Send your worksheet as an attachment to an email with the title Spreadsheet Activity 3

Excel Lesson Four - Home Expenses Worksheet

...........

End of Lesson Three - A Simple Sales & Expenses Worksheet

The Tutor
Do you have a question or a comment?
tutordam@yahoo.com

Site Comments to: Webmaster