Students,

This homework has to be completed on** 24 FEBRUARY 2012, FRIDAY.**

You have done a group work on ACTIVITY 5.4, page 65. I hope you get the positive feedback of doing it collaboratively.

** Your homework is focused on ACTIVITY 5.4.1**. Before this you have worked on the FORMULAE. **COMPLETE the activity by ANSWERING ALL THE UNANSWERED QUESTIONS LEFT.**

………………………………..

**??HOW TO DO??**

**INSTRUCTION: You must do this activity using ONLY Microsoft Office Excel, no calculator is allowed.**

STEP 1 – Continue with your SAVED EXCEL FILE.

STEP 2 – Do calculations by entering the **FUNCTION** in **appropriate cell** for all the questions.

STEP 3 – **SAVE** your work as “*Activity 5.4.1 FUNCTION -your name*” in pendrive. (for your next class purpose)

STEP 4 – **E-mail** your work to *qistinah.jalil@ripas.moe.edu.bn* (It is for my copy to verify your answer)

STEP 5 -Once you figured out the answer, **PRESS “***Leave a comment*” in THIS POST and start TYPING YOUR ANSWER as format below:

**Formulae and functions: “SUM”**

1. Total marks for Maths: ‘your answer’

Function for Maths:’your answer’

…………

Total marks for English: ‘your answer’

Function for English: ‘your answer’

………..

……….

……

*and the rest of the subjects.*

2. Total marks for Angelina Jolie: ‘your answer’

Function for Angelina Jolie: ‘your answer’

…………

Total marks for Brad Pitt: ‘your answer’

Function for Brad Pitt: ‘your answer’

…………

…….

….

*and the rest of the students*.

**Functions: “AVERAGE”**

1. Average marks for Maths: ‘your answer’

Function for Maths:’your answer’

…………

Average marks for English: ‘your answer’

Function for English: ‘your answer’

………..

……….

……

*and the rest of the subjects.*

2. Average marks for Angelina Jolie: ‘your answer’

Function for Angelina Jolie: ‘your answer’

…………

Average marks for Brad Pitt: ‘your answer’

Function for Brad Pitt: ‘your answer’

…………

…….

….

*and the rest of the students*.

**Functions: “MAX, MIN, and COUNT”**

1. Maximum marks for Maths: ‘your answer’

Function for Maths:’your answer’

…………

Maximum marks for English: ‘your answer’

Function for English: ‘your answer’

………..

……….

……

*and the rest of the subjects.*

Minimum marks for Maths: ‘your answer’

Function for Maths:’your answer’

…………

Minimum marks for English: ‘your answer’

Function for English: ‘your answer’

………..

……….

……

*and the rest of the subjects.*

2. Count data for Maths: ‘your answer’

Function for Maths:’your answer’

…………

Count data for English: ‘your answer’

Function for English: ‘your answer’

………..

……….

……

*and the rest of the subjects.*

**DUEDATE**!! As you can see on the right >>>