computer_resources

The purpose of this site is for my teaching aids in Computer Studies as well as ICT subjects

Homework For Week 7 February 20, 2012

Filed under: Homework — computer_resources @ 3:57 am

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 >>>

Advertisements
 

41 Responses to “Homework For Week 7”

  1. Nurnaqiqah Morni Says:

    FORMULA AND FUNCTION: “sum”
    1. TOTAL MARKS FOR EACH SUBJECT:

    – Maths = 358
    Formula: =C5+C6+C7+C8+C9+C10

    – Eng = 479
    Formula: =D5+D6+D7+D8+D9+D10

    – Science = 277
    Formula: =E5+E6+E7+E8+E9+E10

    – Computer = 332
    Formula: =F5+F6+F7+F8+F9+F10

    – D&T = 380
    Formula: =G5+G6+G7+G8+G9+G10

    2. TOTAL MARKS FOR EACH STUDENT:

    – Angelina Jolie = 378
    Formula: =C5+D5+E5+F5+G5

    – Brad Pitt = 436
    Formula: =C6+D6+E6+F6+G6

    – Nicholas Cage = 340
    Formula =C7+D7+E7+F7+G7

    – Eddie Murphy = 215
    Formula: =C8+D8+E8+F8+G8

    – Melissa Joan Hart = 150
    Formula: =C9+D9+E9+F9+G9

    – Freddie Prince JR = 307
    Formula: =C10+D10+E10+F10+G10

    FUNCTION: “average”
    1. AVERAGE MARKS FOR EACH SUBJECT:

    – Maths = 71.6
    Function: =AVERAGE(C5:C10)
    – English = 79.83333333
    Function: =AVERAGE(D5:D10)
    – Science = 55.4
    Function: =AVERAGE(E5:E10)
    – Computer = 66.4
    Function: =AVERAGE(F5:F10)
    – D&T = 63.33333333
    Function: =AVERAGE(G5:G10)

    2. AVERAGE MARKS FOR EACH STUDENT:

    – Angelina Jolie = 75.6
    Function: =AVERAGE(C5:G5)
    – Brad Pitt = 87.2
    Function: =AVERAGE(C6:G6)
    – Nicholas Cage = 85
    Function: =AVERAGE(C7:G7)
    – Eddie Murphy = 53.75
    Function: =AVERAGE(C8:G8)
    – Melissa Joan Heart = 37.5
    Function: =AVERAGE(C9:G9)
    – Freddie Prince JR = 61.4
    Function: =AVERAGE(C10:G10)

    FUNCTION: “max, min and count”
    1. MAXIMUM MARKS:

    – Maths = 85
    Function: =MAX(C5:C10)
    – English = 95
    Function: =MAX(D5:D10)
    – Science = 87
    Function: =MAX(E5:E10)
    – Computer = 92
    Function: =MAX(F5:F10)
    – D&T = 90
    Function: =MAX(G5:G10)

    2. MINIMUM MARKS:

    – Maths = 50
    Function: =MIN(C5:C10)
    – English = 43
    Function: =MIN(D5:D10)
    – Science = 29
    Function: =MIN(E5:E10)
    – Computer = 30
    Function: =MIN(F5:F10)
    – D&T = 37
    Function: =MIN(G5:G10)

    3. COUNT:

    – Maths = 5
    Function: =COUNT(C5:C10)
    – English = 6
    Function: =COUNT(D5:D10)
    – Science = 5
    Function: =COUNT(E5:E10)
    – Computer = 5
    Function: =COUNT(F5:F10)
    – D&T = 6
    Function: =COUNT(G5:G10)

    • Just as stated on above instruction, it asked you to follow following format:

      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.

    • I have checked your EXCEL file, you can already make changes on cells for Formulae for TOTAL MARKS FOR EACH SUBJECT and TOTAL MARKS FOR EACH STUDENT by REPLACING the FORMULAE into FUNCTION.

      Is it clear to you…?

  2. Nurnaqiqah,
    There’s a little correction for you… On ‘FORMULA AND FUNCTION: “sum”’, you should ONLY FOCUS on FUNCTION, since you have answered on FORMULA part in HOMEWORK FOR WEEK 6.

    So, please do make changes… 😀

    • Nurnaqiqah Morni Says:

      Functions: “AVERAGE”

      1. Average marks for Maths: 71.6
      Function for Maths: =AVERAGE(C5:C10)

      Average marks for English: 79.83333333
      Function for English: =AVERAGE(D5:D10)

      Average marks for Science: 55.4
      Function for Science: =AVERAGE(E5:E10)

      Average marks for Computer: 66.4
      Function for Computer: =AVERAGE(F5:F10)

      Average marks for D&T: 63.33333333
      Function for D&T: =AVERAGE(G5:G10)

      2. Average marks for Angelina Jolie: 75.6
      Function for Angelina Jolie: =AVERAGE(C5:G5)

      Average marks for Brad Pitt: 87.2
      Function for Brad Pitt: =AVERAGE(C6:G6)

      Average marks for Nicholas Cage: 85
      Function for Nicholas Cage: =AVERAGE(C7:G7)

      Average marks for Eddie Murphy: 53.75
      Function for Eddie Murphy: =AVERAGE(C8:G8)

      Average marks for Melissa Joan Hart: 37.5
      Function for Melissa Joan Hart: =AVERAGE(C9:G9)

      Average marks for Freddie Prince JR: 61.4
      Function for Freddie Prince JR: =AVERAGE(C10:G10)

      Functions: “MAX, MIN, and COUNT”

      1. Maximum marks for Maths: 85
      Function for Maths: =MAX(C5:C10)

      Maximum marks for English: 95
      Function for Maths: =MAX(D5:D10)

      Maximum marks for Science: 87
      Function for Science: =MAX(E5:E10)

      Maximum marks for Computer: 92
      Function for Computer: =MAX(F5:F10)

      Maximum marks for D&T: 90
      Function for D&T: =MAX(G5:G10)

      Minimum marks for Maths: 50
      Function for Maths: =MIN(C5:C10)

      Minimum marks for English: 43
      Function for English: =MIN(D5:D10)

      Minimum marks for Science: 29
      Function for Science: =MIN(E5:E10)

      Minimum marks for Computer: 30
      Function for Computer: =MIN(F5:F10)

      Minimum marks for D&T: 37
      Function for D&T: =MIN(G5:G10)

      2. Count data for Maths: 5
      Function for Maths: =COUNT(C5:C10)

      Count data for English: 6
      Function for English: =COUNT(D5:D10)

      Count data for Science: 5
      Function for Science: =COUNT(E5:E10)

      Count data for Computer: 5
      Function for Computer: =COUNT(F5:F10)

      Count data for D&T: 6
      Function for D&T: =COUNT(G5:G10)

      • Nurnaqiqah,
        You’ve been confused. What I mean is you need to do correction ONLY for sub-topic “Formulae and Functions:SUM”.

        If you see the questions on sub-topic “Formulae and Functions:SUM”, it is asking for ‘Formulae’ and ‘Functions’. You have answered the Formulae part during previous homework, so FOR THIS WEEK, your HOMEWORK only focused on “FUNCTIONS”

        Are you clear…? 😀

      • Nurnaqiqah Morni Says:

        Functions: “SUM”

        1. Total marks for Maths: 358
        Function for Maths: =SUM(C5:C10)

        Total marks for English: 479
        Function for English: =SUM(D5:D10)

        Total Marks for Science: 277
        Function for Science: =SUM(E5:E10)

        Total marks for Computer: 332
        Function for Computer: =SUM(F5:F10)

        Total marks for D&T: 380
        Function for D&T: =SUM(G5:G10)

        2. Total marks for Angelina Jolie: 378
        Function for Angelina Jolie: =SUM(C5:G5)

        Total marks for Brad Pitt: 436
        Function for Brad Pitt: =SUM(C6:G6)

        Total marks for Nicholas Cage: 340
        Function for Nicholas Cage: =SUM(C7:G7)

        Total marks for Eddie Murphy: 215
        Function for Eddie Murphy: =SUM(C8:G8)

        Total marks for Melissa Joan Hart: 150
        Function for Melissa Joan Hart: =SUM(C9:G9)

        Total marks for Freddie Prince JR: 307
        Function for Freddie Prince JR: =SUM(C10:G10)

        Functions: “AVERAGE”

        1. Average marks for Maths: 71.6
        Function for Maths: =AVERAGE(C5:C10)

        Average marks for English: 79.83333333
        Function for English: =AVERAGE(D5:D10)

        Average marks for Science: 55.4
        Function for Science: =AVERAGE(E5:E10)

        Average marks for Computer: 66.4
        Function for Computer: =AVERAGE(F5:F10)

        Average marks for D&T: 63.33333333
        Function for D&T: =AVERAGE(G5:G10)

        2. Average marks for Angelina Jolie: 75.6
        Function for Angelina Jolie: =AVERAGE(C5:G5)

        Average marks for Brad Pitt: 87.2
        Function for Brad Pitt: =AVERAGE(C6:G6)

        Average marks for Nicholas Cage: 85
        Function for Nicholas Cage: =AVERAGE(C7:G7)

        Average marks for Eddie Murphy: 53.75
        Function for Eddie Murphy: =AVERAGE(C8:G8)

        Average marks for Melissa Joan Hart: 37.5
        Function for Melissa Joan Hart: =AVERAGE(C9:G9)

        Average marks for Freddie Prince JR: 61.4
        Function for Freddie Prince JR: =AVERAGE(C10:G10)

        Functions: “MAX, MIN, and COUNT”

        1. Maximum marks for Maths: 85
        Function for Maths: =MAX(C5:C10)

        Maximum marks for English: 95
        Function for Maths: =MAX(D5:D10)

        Maximum marks for Science: 87
        Function for Science: =MAX(E5:E10)

        Maximum marks for Computer: 92
        Function for Computer: =MAX(F5:F10)

        Maximum marks for D&T: 90
        Function for D&T: =MAX(G5:G10)

        Minimum marks for Maths: 50
        Function for Maths: =MIN(C5:C10)

        Minimum marks for English: 43
        Function for English: =MIN(D5:D10)

        Minimum marks for Science: 29
        Function for Science: =MIN(E5:E10)

        Minimum marks for Computer: 30
        Function for Computer: =MIN(F5:F10)

        Minimum marks for D&T: 37
        Function for D&T: =MIN(G5:G10)

        2. Count data for Maths: 5
        Function for Maths: =COUNT(C5:C10)

        Count data for English: 6
        Function for English: =COUNT(D5:D10)

        Count data for Science: 5
        Function for Science: =COUNT(E5:E10)

        Count data for Computer: 5
        Function for Computer: =COUNT(F5:F10)

        Count data for D&T: 6
        Function for D&T: =COUNT(G5:G10)

      • Nurnaqiqah,
        You’ve scored full marks!! WOOOOWWW!! Outstanding work you’ve got, very good!!

        You have followed all the instructions very well…Keep it up girl!!

  3. Norafazirah Binti Ramlan Says:

    Functions : ‘Average’
    1) Average marks for Maths: 71.6
    Function for Maths: =AVERAGE(C3:C8)
    Average marks for English: 79.83
    Function for English: =AVERAGE(D3:D8)
    Average marks for Science: 55.4
    Function for Science: =AVERAGE(E3:E8)
    Average marks for Computer: 66.4
    Function for Computer: =AVERAGE(F3:F8)
    Average marks for D&T: 69.33
    Funtion for D&T: =AVERAGE(G3:G8)

    2) Average marks for Angelina Jolie: 75.6
    Function for Angelina Jolie: =AVERAGE(C3:G3)
    Average marks for Brad Pitt: 87.2
    Function for Bard Pitt: =AVERAGE(C4:G4)
    Average marks Nicholas Cage: 85
    Functions for Nicholas Cage: =AVERAGE(C5:G5)
    Average marks for Eddie Murphy: 62.74
    Functions for Eddie Murphy: =AVERAGE(C6:G6)
    Average marks for Melissa Joan Hart: 37.5
    Functions for Melissa Joan Hart: =AVERAGE(C7:G7)
    Average marks for Freddie Prince JR: 61.4
    Functions for Freddie Prince JR: =AVERAGE(C8:G8)

    Funtions : ‘MAX,MIN and COUNT’
    1) Maximum marks for Maths: 85
    Functions for maths: =MAX(C3:C8)
    Maximum marks for English: 95
    Funtions for English: =MAX(D3:D8)
    Maximum marks for Science: 95
    Functions for Science: =MAX(E3:E8)
    Maximum Marks for Computer: 92
    Functions for Computer: =MAX(F3:F8)
    Maximum marks for D&T: 90
    Functions for D&T: =MAX(G3:G8)

    Minimum marks for Maths: 50
    Functions for Maths: =MIN(C3:C8)
    Minimum marks for English: 43
    Functions for English: =MIN(D3:D8)
    Minimum marks for Science: 29
    Funtions for Science: =MIN(E3:E8)
    Minimum marks for Computer: 30
    Function for Computer: =MIN(F3:F8)
    Minimum marks for D&T: 48
    Functions for D&T: =MIN(G3:G8)

    2) Count data for Maths: 5
    Functions for maths: =COUNT(C3:C8)
    Count data for English: 6
    Functions for English: =COUNT(D3:D8)
    Count data for Science: 5
    Functions for Science: =COUNT(E3:E8)
    Count data for Computer: 5
    Functions for Computer: =COUNT(F3:F8)
    Count data for D&T:6
    Funtions for D&T: =COUNT(G3:G8)

    • NOrafazirah,
      Please do FUNCTION for TOTAL MARKS FOR EACH SUBJECT and TOTAL MARKS FOR EACH STUDENT. Previous homework, you did FORMULAE. Now, for this homework you have to change the FORMULA into FUNCTION.

      please re-send your EXCEL file after you make changes. Are you clear?

    • Norafazirah,

      I wonder why your answers in this blog are TOTALLY DIFFERENT from your excel file for “RANGE” PART? Did you give me a wrong one? I guess so…

      However, I gave you 1/2 marks for all those different answers. You have scored 59 and 1/2 out of 76. You will be EXCELLENT if you focus on what you are doing. Sooo…girl, please be attentive next time.. 🙂

      I also deduct mark for wrong ‘file name’ of Excel file.

  4. jin ming Says:

    A)FORMULA AND FUNCTION: “sum”(total mark for each subject)

    1)TOTAL MARKS FOR MATHS =358
    FUNCTION=SUM(C5:C10)

    2)TOTAL MARKS FOR ENG= 479
    FUNCTION =SUM(D5:D10)

    3)TOTAL MARKS FOR SCIENCE =277
    FUNCTION=SUM(D3:D8)

    4)TOTAL MARKS FOR COMPUTER=332
    FUNCTION=SUM(E5:E10)

    5)TOTAL MARKS FOR D&T=380
    FUNCTION=SUM(F5:F10)

    B) TOTAL MARKS FOR EACH STUDENT:

    1)TOTAL MARKS FOR ANGELINA JOLIE =75.6
    FUNCTION=SUM(C5:G5)

    2)TOTAL MARKS FOR BRAD PITT=87.2
    FUNCTION=SUM (C6:G6)

    3)TOTAL MARK FOR NICHOLAS CAGE=85
    FUNCTION SUM(C7:G7)

    4)TOTAL MARK FOR EDDIE MURPHY =53.75
    FUNCTION SUM(C8:G8)

    5)TOTAL MARK FOR MELISSA JOAN HEART=37.5
    FUNCTION SUM(C9:G9)

    6)TOTAL MARK FOR FREDDIE PRINCE JR=61.4
    FUNCTION SUM(C10:G10)

    C)FUNCTION: “average”( AVERAGE MARKS FOR EACH SUBJECT)

    1)AVERAGE MARKS Maths = 71.6
    Function: =AVERAGE(C5:C10)

    2)English = 79.83333333
    Function: =AVERAGE(D5:D10)

    3) AVERAGE MARKS Science = 55.4
    Function: =AVERAGE(E5:E10)

    4)AVERAGE MARKS Computer = 66.4
    Function: =AVERAGE(F5:F10)

    5)AVERAGE MARKS D&T = 63.33333333
    Function: =AVERAGE(G5:G10)

    D).AVERAGE MARKS FOR EACH STUDENT:

    1)AVERAGE MARKS FOR Angelina Jolie = 75.6
    Function: =AVERAGE(C5:G5)

    2)AVERAGE MARKS FOR Brad Pitt = 87.2
    Function: =AVERAGE(C6:G6)

    3) AVERAGE MARKS FOR Nicholas Cage = 85
    Function: =AVERAGE(C7:G7)

    4)AVERAGE MARKS FOR Eddie Murphy = 53.75
    Function: =AVERAGE(C8:G8)

    5) AVERAGE MARKS FOR Melissa Joan Heart = 37.5
    Function: =AVERAGE(C9:G9)

    6)AVERAGE MARKS FOR Freddie Prince JR = 61.4
    Function: =AVERAGE(C10:G10)

    E)FUNCTION: “max, min and count”(MAXIMUM MARKS )

    1)MAXIMUM MARKS FOR Maths = 85
    Function: =MAX(C5:C10)

    -2) MAXIMUM MARKS FOR English = 95
    Function: =MAX(D5:D10)

    3) MAXIMUM MARKS FOR Science = 87
    Function: =MAX(E5:E10)

    4)MAXIMUM MARKS FOR Computer = 92
    Function: =MAX(F5:F10)

    5)MAXIMUM MARKS FOR D&T = 90
    Function: =MAX(G5:G10)

    B). MINIMUM MARKS :

    1)MINIMUM MARKS FOR Maths = 50
    Function: =MIN(C5:C10)

    2)MINIMUM MARKS FOR English = 43
    Function: =MIN(D5:D10)

    3)MINIMUM MARKS FOR Science = 29
    Function: =MIN(E5:E10)

    4) MINIMUM MARKS FOR Computer = 30
    Function: =MIN(F5:F10)

    5)MINIMUM MARKS FOR D&T = 37
    Function: =MIN(G5:G10)

    C) COUNT:

    1)COUNT FOR Maths = 5
    Function: =COUNT(C5:C10)

    2)COUNT FOR English = 6
    Function: =COUNT(D5:D10)

    3)COUNT FOR Science = 5
    Function: =COUNT(E5:E10)

    4)COUNT FOR Computer = 5
    Function: =COUNT(F5:F10)

    5)COUNT FOR D&T = 6
    Function: =COUNT(G5:G10)

    • Jin Ming,
      Thank you for being early in handing your work. I have received your e-mail too… Happy Independence Day!!

    • Jin Ming,
      I wonder why the RANGE of your cell for every FUNCTIONS in this blog are different from you EXCEL FILE? Perhaps, you give me a wrong EXCEL FILE.

      Do you check it very carefully before you write down your answer in this blog?

      However, I gave you 1/2 for those different answers. You’ve scored 50 and 1/2 out of 76. Not bad, boy… I also deducted 1 mark for the wrong FILE NAME.

      The filename should be typed in “Activity 5.4.1 FUNCTION – Jin Ming” NOT “Book1 original’.

      I would like to remind you to be focus on everything that you do, to avoid any careless mistake.

  5. Nurul Nabillah Binti Abdullah Says:

    FORMULA & FUNCTION.

    A) TOTAL MARKS FOR EACH STUDENTS.

    1. ANGELINA JOLIE = 378.
    FORMULA ; =SUM(C3:G3)

    2. BRAD PITT = 436.
    FORMULA ; =SUM(C4:G4)

    3. NICHOLAS CAGE = 340.
    FORMULA ; =SUM(C5:G5)

    4. EDDIE MURPHY = 215.
    FORMULA ; =SUM(C6:G6)

    5. MELISSA JOAN HART = 150.
    FORMULA ; =SUM(C7:G7)

    6. FREDDIE PRINCE JR = 307.
    FORMULA ; =SUM(C8:G8)

    B) TOTAL MARKS FOR EACH SUBJECTS.

    1. TOTAL MARKS FOR MATHS = 358
    FUNCTION ; =SUM(C3:C8)

    2. TOTAL MARKS FOR ENGLISH = 479
    FUNCTION ; =SUM(D3;D8)

    3. TOTAL MARKS FOR SCIENCE = 277
    FUNCTION ; =SUM(E3:E8)

    4. TOTAL MARKS FOR COMPUTER = 332
    FUNCTION ; =SUM(F3:F8))

    5. TOTAL MARKS FOR D&T = 380
    FUNCTION ; =SUM(G3:G8)

    C) AVERAGE MARKS FOR EACH SUBJECTS.

    1. AVERAGE MARKS MATHS = 71.6
    Function ; =AVERAGE(C3:C8)

    2. AVERAGE MARKS FOR ENGLISH = 79.83333
    Function ; =AVERAGE(D3:D8)

    3. AVERAGE MARKS SCIENCE = 55.4
    Function ; =AVERAGE(E3:E8)

    4. AVERAGE MARKS COMPUTER = 66.4
    Function ; =AVERAGE(F3:F8)

    5. AVERAGE MARKS D&T = 63.33333
    Function ; =AVERAGE(G3:G8)

    D) AVERAGE MARKS FOR EACH STUDENTS.

    1. AVERAGE MARKS FOR ANGELINA JOLIE = 75.6
    Function ; =AVERAGE(C3:G3)

    2. AVERAGE MARKS FOR BRAD PITT = 87.2
    Function ; =AVERAGE(C4:G4)

    3. AVERAGE MARKS FOR NICHOLAS CAGE= 85
    Function: =AVERAGE(C5:G5)

    4. AVERAGE MARKS FOR EDDIE MURPHY = 53.75
    Function: =AVERAGE(C6:G6)

    5. AVERAGE MARKS FOR MELISSA JOAN HART = 37.5
    Function ; =AVERAGE(C7:G7)

    6)AVERAGE MARKS FOR FREDDIE PRINCE JR = 61.4
    Function ; =AVERAGE(C8:G8)

    E) MAXIMUM MARKS.

    1. MAXIMUM MARKS FOR MATHS = 85
    Function ; =MAX(C3:C8)

    2. MAXIMUM MARKS FOR ENGLISH = 95
    Function ; =MAX(D3:D8)

    3. MAXIMUM MARKS FOR SCIENCE = 87
    Function ; =MAX(E3:E8)

    4. MAXIMUM MARKS FOR Computer = 92
    Function ; =MAX(F3:F8)

    5. MAXIMUM MARKS FOR D&T = 90
    Function ; =MAX(G3:G8)

    F) MINIMUM MARKS.

    1. MINIMUM MARKS FOR MATHS = 50
    Function ; =MIN(C3:C8)

    2. MINIMUM MARKS FOR ENGLISH = 43
    Function ; =MIN(D3:D8)

    3. MINIMUM MARKS FOR SCIENCE = 29
    Function ; =MIN(E3:E8)

    4. MINIMUM MARKS FOR COMPUTER = 30
    Function ; =MIN(F3:F8)

    5. MINIMUM MARKS FOR D&T = 37
    Function ; =MIN(G3:G8)

    G) COUNT.

    1. COUNT FOR MATHS = 5
    Function ; =COUNT(C3:C8)

    2. COUNT FOR ENGLISH = 6
    Function ; =COUNT(D3:D8)

    3. COUNT FOR SCIENCE = 5
    Function ; =COUNT(E3;E8)

    4. COUNT FOR COMPUTER = 5
    Function ; =COUNT(F3:F8)

    5. COUNT FOR D&T = 6
    Function ; =COUNT(G3:G8))

  6. chien yin Says:

    A)FORMULA AND FUNCTION: “sum”(total mark for each subject)

    1)TOTAL MARKS FOR MATHS =358
    FUNCTION=SUM(C5:C10)

    2)TOTAL MARKS FOR ENG= 479
    FUNCTION =SUM(D5:D10)

    3)TOTAL MARKS FOR SCIENCE =277
    FUNCTION=SUM(D3:D8)

    4)TOTAL MARKS FOR COMPUTER=332
    FUNCTION=SUM(E5:E10)

    5)TOTAL MARKS FOR D&T=380
    FUNCTION=SUM(F5:F10)

    B) TOTAL MARKS FOR EACH STUDENT:

    1)TOTAL MARKS FOR ANGELINA JOLIE =75.6
    FUNCTION=SUM(C5:G5)

    2)TOTAL MARKS FOR BRAD PITT=87.2
    FUNCTION=SUM (C6:G6)

    3)TOTAL MARK FOR NICHOLAS CAGE=85
    FUNCTION SUM(C7:G7)

    4)TOTAL MARK FOR EDDIE MURPHY =53.75
    FUNCTION SUM(C8:G8)

    5)TOTAL MARK FOR MELISSA JOAN HEART=37.5
    FUNCTION SUM(C9:G9)

    6)TOTAL MARK FOR FREDDIE PRINCE JR=61.4
    FUNCTION SUM(C10:G10)

    C)FUNCTION: “average”( AVERAGE MARKS FOR EACH SUBJECT)

    1)AVERAGE MARKS Maths = 71.6
    Function: =AVERAGE(C5:C10)

    2)English = 79.83333333
    Function: =AVERAGE(D5:D10)

    3) AVERAGE MARKS Science = 55.4
    Function: =AVERAGE(E5:E10)

    4)AVERAGE MARKS Computer = 66.4
    Function: =AVERAGE(F5:F10)

    5)AVERAGE MARKS D&T = 63.33333333
    Function: =AVERAGE(G5:G10)

    D).AVERAGE MARKS FOR EACH STUDENT:

    1)AVERAGE MARKS FOR Angelina Jolie = 75.6
    Function: =AVERAGE(C5:G5)

    2)AVERAGE MARKS FOR Brad Pitt = 87.2
    Function: =AVERAGE(C6:G6)

    3) AVERAGE MARKS FOR Nicholas Cage = 85
    Function: =AVERAGE(C7:G7)

    4)AVERAGE MARKS FOR Eddie Murphy = 53.75
    Function: =AVERAGE(C8:G8)

    5) AVERAGE MARKS FOR Melissa Joan Heart = 37.5
    Function: =AVERAGE(C9:G9)

    6)AVERAGE MARKS FOR Freddie Prince JR = 61.4
    Function: =AVERAGE(C10:G10)

    E)FUNCTION: “max, min and count”(MAXIMUM MARKS )

    1)MAXIMUM MARKS FOR Maths = 85
    Function: =MAX(C5:C10)

    -2) MAXIMUM MARKS FOR English = 95
    Function: =MAX(D5:D10)

    3) MAXIMUM MARKS FOR Science = 87
    Function: =MAX(E5:E10)

    4)MAXIMUM MARKS FOR Computer = 92
    Function: =MAX(F5:F10)

    5)MAXIMUM MARKS FOR D&T = 90
    Function: =MAX(G5:G10)

    B). MINIMUM MARKS :

    1)MINIMUM MARKS FOR Maths = 50
    Function: =MIN(C5:C10)

    2)MINIMUM MARKS FOR English = 43
    Function: =MIN(D5:D10)

    3)MINIMUM MARKS FOR Science = 29
    Function: =MIN(E5:E10)

    4) MINIMUM MARKS FOR Computer = 30
    Function: =MIN(F5:F10)

    5)MINIMUM MARKS FOR D&T = 37
    Function: =MIN(G5:G10)

    C) COUNT:

    1)COUNT FOR Maths = 5
    Function: =COUNT(C5:C10)

    2)COUNT FOR English = 6
    Function: =COUNT(D5:D10)

    3)COUNT FOR Science = 5
    Function: =COUNT(E5:E10)

    4)COUNT FOR Computer = 5
    Function: =COUNT(F5:F10)

    5)COUNT FOR D&T = 6
    Function: =COUNT(G5:G10)

    • Chien Yin,
      I wonder why the RANGE of your cell for every FUNCTIONS in this blog are different from you EXCEL FILE? Perhaps, you give me a wrong EXCEL FILE.

      In your EXCEL FILE, you didn’t calculate using FUNCTION for AVERAGE MARKS FOR EACH STUDENT

      Do you check it very carefully before you write down your answer in this blog?

      However, I gave you 1/2 for those different answers. You’ve scored 48 and 1/2 out of 76. Not bad, boy… I also deducted 1 mark for the wrong FILE NAME.

      The filename should be typed in “Activity 5.4.1 FUNCTION – Chien YIn” NOT “Book1’.

      I would like to remind you to be focus on everything that you do, to avoid any careless mistake.

  7. Norafazirah Binti Ramlan Says:

    1)Total marks for Maths: 358
    Functions for Maths: =SUM(C5:C10)
    Total marks for English: 479
    Functions for English: =SUM(D5:D10)
    Total marks for Science:277
    Funtions for Science: =SUM(E5:E10)
    Total marks for Computer: 332
    Functions for Computer: =SUM(F5:F10)
    Total marks for D&T: 416
    Funtions for D&T: =SUM(G5:G10)

    2)Total marks for Angelina Jolie: 378
    Functions for Angelina Jolie: =SUM(C5:G5)
    Total marks for Brad Pitt: 436
    Functions for Brad Pitt: =C6:G6)
    Total marks for Nicholas Cage: 340
    Funtions for Nicholas Cage: =SUM(C7:G7)
    Total marks for Eddie Murphy: 251
    Functions for Eddie Murphy: =SUM(C8:G8)
    Total marks for Melissa Joan Hart: 150
    Functions for Melissa Joan Hart: =SUM(C9:G9)
    Total marks for Freddie Prince JR: 307
    Functions for Freddie Prince JR: =SUM(C10:G10)

  8. Mohd Wusalim Bin Abdullah Says:

    A)FORMULA AND FUNCTION: “sum”(total mark for each subject)

    1)TOTAL MARKS FOR MATHS =358
    FUNCTION=SUM(C5:C10)

    2)TOTAL MARKS FOR ENG= 479
    FUNCTION =SUM(D5:D10)

    3)TOTAL MARKS FOR SCIENCE =277
    FUNCTION=SUM(D3:D8)

    4)TOTAL MARKS FOR COMPUTER=332
    FUNCTION=SUM(E5:E10)

    5)TOTAL MARKS FOR D&T=380
    FUNCTION=SUM(F5:F10)

    B) TOTAL MARKS FOR EACH STUDENT:

    1)TOTAL MARKS FOR ANGELINA JOLIE =75.6
    FUNCTION=SUM(C5:G5)

    2)TOTAL MARKS FOR BRAD PITT=87.2
    FUNCTION=SUM (C6:G6)

    3)TOTAL MARK FOR NICHOLAS CAGE=85
    FUNCTION SUM(C7:G7)

    4)TOTAL MARK FOR EDDIE MURPHY =53.75
    FUNCTION SUM(C8:G8)

    5)TOTAL MARK FOR MELISSA JOAN HEART=37.5
    FUNCTION SUM(C9:G9)

    6)TOTAL MARK FOR FREDDIE PRINCE JR=61.4
    FUNCTION SUM(C10:G10)

    C)FUNCTION: “average”( AVERAGE MARKS FOR EACH SUBJECT)

    1)AVERAGE MARKS Maths = 71.6
    Function: =AVERAGE(C5:C10)

    2)English = 79.83333333
    Function: =AVERAGE(D5:D10)

    3) AVERAGE MARKS Science = 55.4
    Function: =AVERAGE(E5:E10)

    4)AVERAGE MARKS Computer = 66.4
    Function: =AVERAGE(F5:F10)

    5)AVERAGE MARKS D&T = 63.33333333
    Function: =AVERAGE(G5:G10)

    D).AVERAGE MARKS FOR EACH STUDENT:

    1)AVERAGE MARKS FOR Angelina Jolie = 75.6
    Function: =AVERAGE(C5:G5)

    2)AVERAGE MARKS FOR Brad Pitt = 87.2
    Function: =AVERAGE(C6:G6)

    3) AVERAGE MARKS FOR Nicholas Cage = 85
    Function: =AVERAGE(C7:G7)

    4)AVERAGE MARKS FOR Eddie Murphy = 53.75
    Function: =AVERAGE(C8:G8)

    5) AVERAGE MARKS FOR Melissa Joan Heart = 37.5
    Function: =AVERAGE(C9:G9)

    6)AVERAGE MARKS FOR Freddie Prince JR = 61.4
    Function: =AVERAGE(C10:G10)

    E)FUNCTION: “max, min and count”(MAXIMUM MARKS )

    1)MAXIMUM MARKS FOR Maths = 85
    Function: =MAX(C5:C10)

    -2) MAXIMUM MARKS FOR English = 95
    Function: =MAX(D5:D10)

    3) MAXIMUM MARKS FOR Science = 87
    Function: =MAX(E5:E10)

    4)MAXIMUM MARKS FOR Computer = 92
    Function: =MAX(F5:F10)

    5)MAXIMUM MARKS FOR D&T = 90
    Function: =MAX(G5:G10)

    B). MINIMUM MARKS :

    1)MINIMUM MARKS FOR Maths = 50
    Function: =MIN(C5:C10)

    2)MINIMUM MARKS FOR English = 43
    Function: =MIN(D5:D10)

    3)MINIMUM MARKS FOR Science = 29
    Function: =MIN(E5:E10)

    4) MINIMUM MARKS FOR Computer = 30
    Function: =MIN(F5:F10)

    5)MINIMUM MARKS FOR D&T = 37
    Function: =MIN(G5:G10)

    C) COUNT:

    1)COUNT FOR Maths = 5
    Function: =COUNT(C5:C10)

    2)COUNT FOR English = 6
    Function: =COUNT(D5:D10)

    3)COUNT FOR Science = 5
    Function: =COUNT(E5:E10)

    4)COUNT FOR Computer = 5
    Function: =COUNT(F5:F10)

    5)COUNT FOR D&T = 6
    Function: =COUNT(G5:G10)

    • Wusalim,
      As you don’t provide your EXCEL FILE, I can see the logic of your function. Only the part that I wondering is why your answers in “TOTAL MARKS FOR EACH STUDENT” is different??
      Is it logic you have got ‘point’ answers for TOTAL MARKS FOR EACH STUDENT?

      I also deducted your 2 marks (attachment & file name) because you didn’t send your EXCEL FILE. So… your overall mark that you scored is 60 out of 76. Put little effort to your good work so it can be the BEST ONE!

  9. Ammirul Adiq Bin Yanam Says:

    A)FORMULA AND FUNCTION: “sum”(total mark for each subject)

    1)TOTAL MARKS FOR MATHS =358
    FUNCTION=SUM(C5:C10)

    2)TOTAL MARKS FOR ENG= 479
    FUNCTION =SUM(D5:D10)

    3)TOTAL MARKS FOR SCIENCE =277
    FUNCTION=SUM(D3:D8)

    4)TOTAL MARKS FOR COMPUTER=332
    FUNCTION=SUM(E5:E10)

    5)TOTAL MARKS FOR D&T=380
    FUNCTION=SUM(F5:F10)

    B) TOTAL MARKS FOR EACH STUDENT:

    1)TOTAL MARKS FOR ANGELINA JOLIE =75.6
    FUNCTION=SUM(C5:G5)

    2)TOTAL MARKS FOR BRAD PITT=87.2
    FUNCTION=SUM (C6:G6)

    3)TOTAL MARK FOR NICHOLAS CAGE=85
    FUNCTION SUM(C7:G7)

    4)TOTAL MARK FOR EDDIE MURPHY =53.75
    FUNCTION SUM(C8:G8)

    5)TOTAL MARK FOR MELISSA JOAN HART=37.5
    FUNCTION SUM(C9:G9)

    6)TOTAL MARK FOR FREDDIE PRINCE JR=61.4
    FUNCTION SUM(C10:G10)

    C)FUNCTION: “average”( AVERAGE MARKS FOR EACH SUBJECT)

    1)AVERAGE MARKS Maths = 71.6
    Function: =AVERAGE(C5:C10)

    2)English = 79.83333333
    Function: =AVERAGE(D5:D10)

    3) AVERAGE MARKS Science = 55.4
    Function: =AVERAGE(E5:E10)

    4)AVERAGE MARKS Computer = 66.4
    Function: =AVERAGE(F5:F10)

    5)AVERAGE MARKS D&T = 63.33333333
    Function: =AVERAGE(G5:G10)

    D).AVERAGE MARKS FOR EACH STUDENT:

    1)AVERAGE MARKS FOR Angelina Jolie = 75.6
    Function: =AVERAGE(C5:G5)

    2)AVERAGE MARKS FOR Brad Pitt = 87.2
    Function: =AVERAGE(C6:G6)

    3) AVERAGE MARKS FOR Nicholas Cage = 85
    Function: =AVERAGE(C7:G7)

    4)AVERAGE MARKS FOR Eddie Murphy = 53.75
    Function: =AVERAGE(C8:G8)

    5) AVERAGE MARKS FOR Melissa Joan Hart = 37.5
    Function: =AVERAGE(C9:G9)

    6)AVERAGE MARKS FOR Freddie Prince JR = 61.4
    Function: =AVERAGE(C10:G10)

    E)FUNCTION: “max, min and count”(MAXIMUM MARKS )

    1)MAXIMUM MARKS FOR Maths = 85
    Function: =MAX(C5:C10)

    -2) MAXIMUM MARKS FOR English = 95
    Function: =MAX(D5:D10)

    3) MAXIMUM MARKS FOR Science = 87
    Function: =MAX(E5:E10)

    4)MAXIMUM MARKS FOR Computer = 92
    Function: =MAX(F5:F10)

    5)MAXIMUM MARKS FOR D&T = 90
    Function: =MAX(G5:G10)

    B). MINIMUM MARKS :

    1)MINIMUM MARKS FOR Maths = 50
    Function: =MIN(C5:C10)

    2)MINIMUM MARKS FOR English = 43
    Function: =MIN(D5:D10)

    3)MINIMUM MARKS FOR Science = 29
    Function: =MIN(E5:E10)

    4) MINIMUM MARKS FOR Computer = 30
    Function: =MIN(F5:F10)

    5)MINIMUM MARKS FOR D&T = 37
    Function: =MIN(G5:G10)

    C) COUNT:

    1)COUNT FOR Maths = 5
    Function: =COUNT(C5:C10)

    2)COUNT FOR English = 6
    Function: =COUNT(D5:D10)

    3)COUNT FOR Science = 5
    Function: =COUNT(E5:E10)

    4)COUNT FOR Computer = 5
    Function: =COUNT(F5:F10)

    5)COUNT FOR D&T = 6
    Function: =COUNT(G5:G10)

    • Adiq,
      I guess that you have sent a wrong EXCEL FILE. Your FUNCTION & RANGE of CELL in this blog is totally different from the EXCEL FILE that you sent.

      For example in FORMULA AND FUNCTION: “SUM”, TOTAL MARKS FOR EACH SUBJECT:
      Your answer in this blog: TOTAL MARKS FOR MATHS =358
      FUNCTION =SUM(C5:C10)

      **Note: In your EXCEL FILE, you type =C5+C6+C7+C8+C9+C10

      For example, in TOTAL MARKS FOR EACH STUDENT:
      Your answer in this blog: TOTAL MARKS FOR ANGELINA JOLIE=75.6
      FUNCTION =SUM(C5:G5)

      **Note: In your EXCEL FILE, you are using FORMULA instead of FUNCTION. I wondering that why you give answers in ‘point’? is it logic when you calculate them manually and your answer is point, while the input data has no point at all..?
      Think carefully…

      Overall mark that you scored is 48 and 1/2 out of 76. Good Try!! I also deducted 1 mark because the FILE NAME for your EXCEL FILE should be:

      “Activity 5.4.1 FUNCTION – Ammirul Adiq” NOT “Activity 5.4.1’.

      Gentle reminder, please be extra careful and focus in doing your work boy.. to avoid any careless mistake. Alright…

  10. Muhd Faris Syarifuddinbin Hj Hirwan Says:

    Formulae and functions: “SUM”

    1.Total marks for Maths: 358
    Function for Maths: =SUM(C3:C8)

    Total marks for English: 479
    Function for English: =SUM(D3:D8)

    Total marks for Science: 277
    Function for Science: =SUM(E3:E8)

    Total marks for Computer: 332
    Function for Computer: =SUM(F3:F8)

    Total marks for D&T: 380
    Function for D&T: =SUM(G3:G8)

    2.Total marks for Angelina Jolie: 378
    Function for Angelina Jolie: =SUM(C3:G3)

    Total marks for Brad Pitt: 436
    Function for Brad Pitt: =SUM(C4:G4)

    Total marks for Nicholas Cage: 340
    Function for Nicholas Cage: =SUM(C5:G5)

    Total marks for Eddie Murphy: 215
    Function for Eddie Murphy: =SUM(C6:G6)

    Total marks for Melissa Joan Hart: 150
    Function for Melissa Joan Hart: =SUM(C7:G7)

    Total marks for Freddie Prince JR: 307
    Function for Freddie Prince JR: =SUM(C8:G8)

    Functions: “AVERAGE”

    1. Average marks for Maths: 71.6
    Function for Maths:=AVERAGE(C3:C8)

    Average marks for English: 72.75
    Function for English:=AVERAGE(D3:D8)

    Average marks for Science: 55.4
    Function for Science:=AVERAGE(E3:E8)

    Average marks for Computer: 66.4
    Function for Computer:=AVERAGE(F3:F8)

    Average marks for D&T: 63.333333
    Function for D&T:=AVERAGE(G3:G8)

    2. Average marks for Angelina Jolie: 75.6
    Function for Angelina Jolie: =AVERAGE(C3:G3)

    Average marks for Brad Pitt: 87.2
    Function for Brad Pitt: =AVERAGE(C4:G4)

    Average marks for Nicholas Cage: 85
    Function for Nicholas cage: =AVERAGE(C5:G5)

    Average marks for Eddie Murphy: 53.75
    Function for Eddie Murphy: =AVERAGE(C6:G6)

    Average marks for Melissa Joan Heart: 37.5
    Function for Melissa Joan Heart: =AVERAGE(C7:G7)

    Average marks for Freddie Prince JR: 61.4
    Function for Freddie Prince JR: =AVERAGE(C8:G8)

    Functions: “MAX, MIN, and COUNT”

    1. Maximum marks for Maths: 85
    Function for Maths:=MAX(C3:C8)

    Maximum marks for English: 95
    Function for English:=MAX(D3:D8)

    Maximum marks for Science: 87
    Function for Science:=MAX(E3:E8)

    Maximum marks for Computer: 92
    Function for Computer:=MAX(F3:F8)

    Maximum marks for D&T: 90
    Function for D&T:=MAX(G3:G8)

    Minimum marks for Maths: 50
    Function for Maths: =MIN(C3:C8)

    Minimum marks for English: 43
    Function for English: =MIN(D3:D8)

    Minimum marks for Science: 29
    Function for Science: =MIN(E3:E8)

    Minimum marks for Computer: 30
    Function for Computer: =MIN(F3:F8)

    Minimum marks for D&T: 37
    Function for D&T: =MIN(G3:G8)

    2. Count data for Maths: 5
    Function for Maths:=COUNT(C3:C8)

    Count data for English: 6
    Function for English:=COUNT(D3:D8)

    Count data for Science: 5
    Function for Science:=COUNT(E3:E8)

    Count data for Computer: 5
    Function for Computer:=COUNT(F3:F8)

    Count data for D&T: 6
    Function for D&T:=COUNT(G3:G8)

    • Faris,

      EXCELLENT WORK!! I like the way you think boy!! Your work is very neat and organize in a good manner. You have complete your work with good formatting skill.

      You also followed the instruction very well; you attached the excel file AND file name is in a correct format.

      You scored 75 out of 76. You know why you miss 1 mark? The reason is:

      Your answer for AVERAGE MARKS FOR ENGLISH: 72.75
      Function for English: =AVERAGE(D3:D8)

      ****NOTE: Your answer should be 79.83. Your function “=AVERAGE(D3:D8)” is already correct BUT in your EXCEL FILE you have typed “=AVERAGE(D5:D8)”

      Please be extra careful boy… However, I like what you did!!

  11. Nurmajidah Hazirah Binti Majid Says:

    total marks for maths: 358
    function: =SUM(C2:C7)
    total marks for english: 479
    function: =SUM(D2:D7)
    total marks for science: 277
    function: =SUM(E2:E7)
    total marks for computer: 332
    function: =SUM(F2:F7)
    total marks for D&T: 380
    function: =SUM(G2:G7)

    total marks for Angelina Jolie: 378
    function: =SUM(C2:G2)
    total marks for Brad Pitt: 436
    function: =SUM(C3:G3)
    total marks for Nicholas Cage: 340
    function: =SUM(C4:G4)
    total marks for Eddie Murphy: 215
    function: =SUM(C5:G5)
    total marks for Melissa Joan Hart: 150
    function: =SUM(C6:G6)
    total marks for Freddie Prince JR: 307
    function: =SUM(C7:G7)

    average marks for maths: 71.6
    function: =AVERAGE(C2:C7)
    average marks for english: 79.83333
    function: =AVERAGE(D2:D7)
    average marks for science: 55.4
    function: =AVERAGE(E2:E7)
    average marks for computer: 66.4
    function: =AVERAGE(F2:F7)
    average marks for D&T: 63.33333
    function: =AVERAGE(G2:G7)

    average marks for Angelina Jolie: 75.6
    function: =AVERAGE(C2:G2)
    average marks for Brad Pitt: 87.2
    function: =AVERAGE(C3:G3)
    average marks for Nicholas Cage: 85
    function: =AVERAGE(C4:G4)
    average marks for Eddie Murphy: 53.75
    function: =AVERAGE(C5:G5)
    average marks for Melissa Joan Hart: 37.5
    function: =AVERAGE(C6:G6)
    average marks for Freddie Prince JR: 61.4
    function: =AVERAGE (C7:G7)

    maximum marks for maths: 85
    function: =MAX(C2:C7)
    maximum marks for english: 95
    function: =MAX(D2:D7)
    maximum marks for science: 87
    function: =MAX(E2:E7)
    maximum marks for computer: 92
    function: =MAX(F2:F7)
    maximum marks for D&T: 90
    function: =MAX(G2:G7)

    minimum marks for maths: 50
    function: =MIN(C2:C7)
    minimum marks for english: 43
    function: =MIN(D2:D7)
    minimum marks for science: 29
    function: =MIN(E2:E7)
    minimum marks for computer: 30
    function: =MIN(F2:F7)
    minimum marks for D&T: 37
    function: =MIN(G2:G7)

    count data for maths: 5
    function: =COUNT(C2:C7)
    count data for english: 6
    function: =COUNT(D2:D7)
    count data for science: 5
    function: =COUNT(E2:E7)
    count data for computer: 5
    function: =COUNT(F2:F7)
    count data for D&T: 6
    function: =COUNT(G2:G7)

    • Nurmajidah,
      It is so enjoyable to mark your work, HOWEVER it would be MORE enjoyable if you provide me your EXCEL FILE.

      You have lost 2 marks for not providing me EXCEL FILE. Overall score is 74 out of 76. Not bad huh… 🙂 VERY GOOD!! keep it up girl…

  12. Nurazirah Binti Ismail Says:

    Total marks for maths:358
    Function: =sum(c3:c8)
    Total marks for english:479
    Function: =sum(d3:d8)
    Total marks for science:277
    Function: =sum(e3:e8)
    Total marks for computer:332
    Function: =sum(f3:f8)
    Total marks for d&t:380
    Function: =sum(g3:g8)

    Total marks for Angelina Jolie:378
    Function: =sum(c3:g3)
    Total marks for Brad Pitt:436
    Function: =sum(c4:g4)
    Total marks for Nicholas Cage:340
    Function: =sum(c5:g5)
    Total marks for Eddie Murphy:215
    Function: =sum(c6:g6)
    Total marks for Melissa Joan Hart:150
    Function: =sum(c7:g7)
    Total marks for Freddie Prince JR:307
    Function: =sum(c8:g8)

    Average mark for Maths:71.6
    Function: =average(c3:c8)
    Average mark for english:79.3333333
    Function: =average(d3:d8)
    Average mark for science:55.4
    Function: =average(e3:e8)
    Average mark for computer:66.4
    Function: =average(f3:f8)
    Average mark for d&t:63.33333333
    Function: =average(g3:g8)

    Average mark for Angelina Jolie:75.6
    Function: =average(c3:g3)
    Average mark for Brad Pitt:87.2
    Function: =average(c4:g4)
    Average mark for Nicholas Cage:85
    Function: =average(c5:g5)
    Average mark for Eddie Murphy:53.75
    Function: =average(c6:g6)
    Average mark for Melissa Joan Hart:37.5
    Function: =average(c7:g7)
    Average mark for Freddie Prince JR:61.4
    Function: =average(c8:g8)

    Maximum marks for maths:85
    Function: =max(c3:c8)
    Maximum marks for eng:95
    Function: =max(d3:d8)
    Maximum marks for science:87
    Function: =max(e3:e8)
    Maximum marks for computer:92
    Function: =max(f3:f8)
    Maximum marks for d&t:90
    Function: =max(g3:g8)

    Minimum marks for maths:50
    Function: =min(c3:c8)
    Minimum marks for eng:43
    Function: =min(d3:d8)
    Minimum marks for science:29
    Function: =min(e3:e8)
    Minimum marks for computer:30
    Function: =min(f3:f8)
    Minimum marks for d&t:37
    Function: =min(g3:g8)

    Count data for maths:5
    Function: =count(c3:c8)
    Count data for eng:6
    Function: =count(d3:d8)
    Count data for science:5
    Function: =count(e3:e8)
    Count data for computer:5
    Function: =count(f3:f8)
    Count data for d&t:6
    Function: =count(g3:g8)

    • Nurazirah,
      I guess you have sent me a wrong file because your FUNCTIONS in the EXCEL FILE are not complete.

      However, I see your logic. You have used correct ‘RANGE’ in your functions. 😦 it would be more fun to mark if I see the correct EXCEL FILE sent.

      Okay, your overall mark that you score is 75 out of 76. 1 mark lost is because the file name of your excel file is wrong.

      The correct one should be:
      “Activity 5.4.1 FUNCTION – Nurazirah”

      Above all, good work Nurazirah. Keep it up!!

  13. zulzaimirul zambreen bin zulkefli Says:

    A)FORMULA AND FUNCTION: “sum
    ”(total mark for each subject) 1)TOTAL MARKS FOR MATHS =358
    FUNCTION=SUM(C5:C10)
    2)TOTAL MARKS FOR ENG= 479
    FUNCTION =SUM(D5:D10)
    3)TOTAL MARKS FOR SCIENCE =277
    FUNCTION=SUM(D3:D8)
    4)TOTAL MARKS FOR
    COMPUTER=332
    FUNCTION=SUM(E5:E10)
    5)TOTAL MARKS FOR D&T=380
    FUNCTION=SUM(F5:F10) B) TOTAL MARKS FOR EACH
    STUDENT: 1)TOTAL MARKS FOR ANGELINA
    JOLIE =75.6
    FUNCTION=SUM(C5:G5)
    2)TOTAL MARKS FOR BRAD
    PITT=87.2
    FUNCTION=SUM (C6:G6)
    3)TOTAL MARK FOR NICHOLAS
    CAGE=85
    FUNCTION SUM(C7:G7)
    4)TOTAL MARK FOR EDDIE MURPHY
    =53.75
    FUNCTION SUM(C8:G8)
    5)TOTAL MARK FOR MELISSA JOAN
    HART=37.5
    FUNCTION SUM(C9:G9)
    6)TOTAL MARK FOR FREDDIE PRINCE
    JR=61.4
    FUNCTION SUM(C10:G10)
    C)FUNCTION: “average”( AVERAGE
    MARKS FOR EACH SUBJECT)
    1)AVERAGE MARKS Maths = 71.6
    Function: =AVERAGE(C5:C10)
    2)English = 79.83333333
    Function: =AVERAGE(D5:D10)
    3) AVERAGE MARKS Science = 55.4
    Function: =AVERAGE(E5:E10)
    4)AVERAGE MARKS Computer =
    66.4
    Function: =AVERAGE(F5:F10)
    5)AVERAGE MARKS D&T =
    63.33333333
    Function: =AVERAGE(G5:G10)
    D).AVERAGE MARKS FOR EACH
    STUDENT:
    1)AVERAGE MARKS FOR Angelina
    Jolie = 75.6
    Function: =AVERAGE(C5:G5)
    2)AVERAGE MARKS FOR Brad Pitt =
    87.2
    Function: =AVERAGE(C6:G6)
    3) AVERAGE MARKS FOR Nicholas
    Cage = 85
    Function: =AVERAGE(C7:G7)
    4)AVERAGE MARKS FOR Eddie
    Murphy = 53.75
    Function: =AVERAGE(C8:G8)
    5) AVERAGE MARKS FOR Melissa
    Joan Hart = 37.5
    Function: =AVERAGE(C9:G9)
    6)AVERAGE MARKS FOR Freddie
    Prince JR = 61.4
    Function: =AVERAGE(C10:G10)
    E)FUNCTION: “max, min and count
    ”(MAXIMUM MARKS )
    1)MAXIMUM MARKS FOR Maths = 85
    Function: =MAX(C5:C10)
    2) MAXIMUM MARKS FOR English =
    95
    Function: =MAX(D5:D10)
    3) MAXIMUM MARKS FOR Science =
    87
    Function: =MAX(E5:E10)
    4)MAXIMUM MARKS FOR Computer =
    92
    Function: =MAX(F5:F10)
    5)MAXIMUM MARKS FOR D&T = 90
    Function: =MAX(G5:G10) B). MINIMUM MARKS :
    1)MINIMUM MARKS FOR Maths = 50
    Function: =MIN(C5:C10)
    2)MINIMUM MARKS FOR English = 43
    Function: =MIN(D5:D10)
    3)MINIMUM MARKS FOR Science =
    29
    Function: =MIN(E5:E10)
    4) MINIMUM MARKS FOR Computer =
    30
    Function: =MIN(F5:F10)
    5)MINIMUM MARKS FOR D&T = 37
    Function: =MIN(G5:G10)
    C) COUNT: 1
    )COUNT FOR Maths = 5
    Function: =COUNT(C5:C10)
    2)COUNT FOR English = 6
    Function: =COUNT(D5:D10)
    3)COUNT FOR Science = 5
    Function: =COUNT(E5:E10)
    4)COUNT FOR Computer = 5
    Function: =COUNT(F5:F10)
    5)COUNT FOR D&T = 6
    Function: =COUNT(G5:G10)

    • zulzaimirul zambreen bin zulkefli Says:

      how to make the excel cher? And sorry for late sumbit the homework . 🙂

      • Zulzamirul,
        I’ve accepted your work in this wordpress blog.. What do you mean by “how to make the excel?” Don’t you calculate your function using EXCEL?

        It’s alright for the late submit..the most important thing is you submit your work! and that’s good

    • Zulzamirul,
      Sorry to say this…but this is what I feel… I assumed that you didn’t do your work using EXCEL because I found out that the RANGE that you used in FUNCTION for calculation are not consistent UNLESS you sent me your SOFTCOPY of your excel.

      For example, your answer:
      TOTAL MARKS FOR SCIENCE =277
      FUNCTION =SUM(D3:D8)

      ****NOTE: Isn’t column D has been used for English?

      I also wonder why your answers in “TOTAL MARKS FOR EACH STUDENT” is in “point”? Is it logic you have got ‘point’ answers while the input data has no “point” at all?

      For example, your answer:
      TOTAL MARKS FOR ANGELINA JOLIE =75.6
      FUNCTION =SUM(C5:G5)

      INPUT DATA for Angelina Jolie are: 85, 95, 58, 74, 66
      which gives answer: 378

      However, your final score is 62 out of 76. Not bad… good work!! I deducted 2 marks for not sending your Excel file. 1 mark for inconsistency RANGE in functions. 1 mark for not organized in typing the answers in this blog.

      Please make a big effort, be organized, as well as attentive in your work.

  14. Formulae and functions: “SUM”
    1. Total marks for Maths:358
    Function for Maths:=SUM(C3:C8)

    Total marks for English:479
    Function for English:=SUM(D3:D8)

    Total marks for Science:277
    Function for Science:=SUM(E3:E8)

    Total marks for Computer : 332
    Function for Computer : =SUM(F3:F8)

    Total marks for D&T:380
    Function for D&T:=SUM(G3:G8)

    2. Total marks for Angelina Jolie: 378
    Function for Angelina Jolie: =SUM(C3:G3)

    Total marks for Brad Pitt: 436
    Function for Brad Pitt: =SUM(C4:G4)

    Total marks for Nicholas Cage:340
    Function for Nicholas Cage:=SUM(C5:G5)

    Total marks for Eddie Murphy:215
    Function for Eddie Murphy:=SUM(C6:G6)

    Total marks for Melissa Joan Hart:150
    Function for Melissa Joan Hart:=SUM(C7:G7)

    Total marks for Freddie Prince JR:307
    Function for Freddie Prince JR:=SUM(C8:G8)

    Functions: “AVERAGE”
    1. Average marks for Maths:71.6
    Function for Maths:=AVERAGE(C3:C8)

    Average marks for English:79.83333
    Function for English:=AVERAGE(D3:D8)

    Average marks for Science:55.4
    Function for Science:=AVERAGE(E3:E8)

    Average marks for Computer :66.4
    Function for Computer :=AVERAGE(F3:F8)

    Average marks for D&T:63.3333
    Function for D&T:=AVERAGE(G3:G8)

    2. Average marks for Angelina Jolie: 75.6
    Function for Angelina Jolie:=AVERAGE(C3:G3)

    Average marks for Brad Pitt:87.2
    Function for Brad Pitt:=AVERAGE(C4:G4)

    Average marks for Nicholas Cage:85
    Function for Nicholas Cage:=AVERAGE(C5:G5)

    Average marks for Eddie Murphy:53.75
    Function for Eddie Murphy:=AVERAGE(C6:G6)

    Average marks for Melissa Joan Heart:37.5
    Function for Melissa Joan Heart:=AVERAGE(C7:G7)

    Average marks for Freddie Prince JR:61.4
    Function for Freddie Prince JR:=AVERAGE(C8:G8)

    Functions: “MAX, MIN, and COUNT”
    1. Maximum marks for Maths: 85
    Function for Maths:=MAX(C3:C8)

    Maximum marks for English:95
    Function for English: =MAX(D3:D8)

    Maximum marks for Science:87
    Function for Science:=MAX(E3:E8)

    Maximum marks for Computer :92
    Function for Computer :=MAX(F3:F8)

    Maximum marks for D&T:90
    Function for D&T:=MAX(G3:G8)

    Minimum marks for Maths: 50
    Function for Maths:=MIN(C3:C8)

    Minimum marks for English:43
    Function for English: =MIN(D3:D8)

    Minimum marks for Science:29
    Function for Science:=MIN(E3:E8)

    Minimum marks for Computer :30
    Function for Computer :=MIN(F3:F8)

    Minimum marks for D&T:37
    Function for D&T:=MIN(G3:G8)

    2. Count data for Maths: 5
    Function for Maths:=COUNT(C3:C8)

    Count data for English: 6
    Function for English:=COUNT(D3:D8)

    Count data for Science:5
    Function for Science:=COUNT(E3:E8)

    Count data for Computer :5
    Function for Computer :=COUNT(F3:F8)

    Count data for D&T:6
    Function for D&T:=COUNT(G3:G8)

    • Joanishah,
      You are very good in using functions. The only thing that you have to be bear in your mind is that you need to organize your table by formatting it using border and colour so that it will be neat and easy to look on. 😀

      However, you scored quite high mark: 75 out of 76. You know why you missed 1 mark? Your file name should be typed in a correct format, such as:

      “Activity 5.4.1 FUNCTION – Joanishah”, NOT ““Activity 5.4.1 – Joanishah”

      WELLDONE boy!!

  15. Mohammad iman bin abdullah Says:

    FUNCTION ‘SUM’

    1.TOTAL MARKS FOR MATHS:358
    FUNCTION:=SUM(C3:C8)

    TOTAL MARKS FOR ENGLISH:479
    FUNCTION:=SUM(D3:D8)

    TOTAL MARKS FOR SCIENCE:277
    FUNCTION:=SUM(E3:E8)

    TOTAL MARKS FOR COMPUTER:332
    FUNCTION:=SUM(F3:F8)

    TOTAL MARKS FOR D & T:380
    FUNCTION:=SUM(G3:G8)

    2.TOTAL MARKS FOR ANGELINA JOLIE:378
    FUNCTION:=SUM(C3:G3)

    TOTAL MARKS FOR BRAD PITT:436
    FUNCTION:=SUM(C4:G4)

    TOTAL MARKS FOR NICHOLAS CAGE: 340
    FUNCTION:=SUM(C5:G5)

    TOTAL MARKS FOR EDDIE MURPHY: 215
    FUNCTION:=SUM(C6:G6)

    TOTAL MARKS FOR MELISSA JOAN HART:150
    FUNCTION:=SUM(C7:G7)

    TOTAL MARKS FOR FREDDIE PRINCE JR:307
    FUNCTION:=SUM(C8:G8)

    FUNCTION ‘AVERAGE’

    AVERAGE MARKS FOR MATHS:71.6
    FUNCTION:=AVERAGE(C3:C8)

    AVERAGE MARKS FOR ENGLISH:79.3333333
    FUNCTION:=AVERAGE(D2:D8)

    AVERAGE MARKS FOR SCIENCE:55.4
    FUNCTION:=AVERAGE(E3:E8)

    AVERAGE MARKS FOR COMPUTER:66.4
    FUNCTION:=AVERAGE(F3:F8)

    AVERAGE MARKS FOR D & T:63.33333333
    FUNCTION:=AVERAGE(G3:G8)

    4.AVERAGE MARKS FOR ANGELINA JOLIE:75.6
    FUNCTION:=AVERAGE(C3:G3)

    AVERAGE MARKS FOR BRAD PITT:87.2
    FUNCTION:=AVERAGE(C4:G4)

    AVERAGE MARKS FOR NICHOLAS CAGE:85
    FUNCTION:=AVERAGE(C5:G5)

    AVERAGE MARKS FOR EDDIE MURPHY:53.75
    FUNCTION:=AVERAGE(C6:G6)

    AVERAGE MARKS FOR MELISSA JOAN HART:37.5
    FUNCTION:=AVERAGE(C7:G7)

    AVERAGE MARKS FOR FREDDIE PRINCE JR:61.4
    FUNCTION:=AVERAGE(C8:G8)

    FUNCTION ‘MAX,MIN AND COUNT’

    MAXIMUM MARKS

    MAXIMUM MARKS FOR MATHS:85
    FUNCTION:=MAX(C3:C8)

    MAXIMUM MARKS FOR ENGLISH:95
    FUNCTION:=MAX(D3:D8)

    MAXIMUM MARKS FOR SCIENCE:87
    FUNCTION:=MAX(E3:E8)

    MAXIMUM MARKS FOR COMPUTER:92
    FUNCTION:=MAX(F3:F8)

    MAXIMUM MARKS FOR D&T:90
    FUNCTION:=MAX(G3:G8)

    2.MINIMUM MARKS

    MINIMUM MARKS FOR MATHS:50
    FUNCTION:=MIN(C3:C8)

    MINIMUM MARKS FOR ENGLISH:43
    FUNCTION:=MIN(D3:D8)

    MINIMUM MARKS FOR SCIENCE:29
    FUNCTION:=MIN(E3:E8)

    MINIMUM MARKS FOR COMPUTER:30
    FUNCTION:=MIN(F3:F8)

    MINIMUM MARKS FOR D&T:37
    FUNCTION:=MIN(G3:G8)

    3.COUNT

    COUNT FOR MATHS:5
    FUNCTION:=COUNT(C3:C8)

    COUNT FOR ENGLISH:6
    FUNCTION:=COUNT(D3:D8)

    COUNT FOR SCIENCE:5
    FUNCTION:=COUNT(E3:E8)

    COUNT FOR COMPUTER:5
    FUNCTION:=COUNT(F3:F8)

    COUNT FOR D&T:6
    FUNCTION:=COUNT(G3:G8)

    SORRY TEACHER……LATE SUBMIT I WASNT AT HOME YESTERDAY SORRY 🙂 BY THE WAY TEACHER HAVE YOU RECEIVE MY EMAIL ALREADY??

    • Iman,
      You are good in using formula and function. Additionally, you are also very good in using ‘comment’ to inform me what you did. Keep it up boy!!

      However, you need to organise a bit on your table. You need to put the ‘function’ as well instead by just typing the answer.

      Your score is 72 and 1/2 out of 76. 1 and 1/2 mark lost is because you have type down answer:

      AVERAGE MARKS FOR ENGLISH: 79.3333333
      FUNCTION: =AVERAGE(D2:D8)

      The correct one should be:

      AVERAGE MARKS FOR ENGLISH: 79.8333333
      FUNCTION: =AVERAGE(D3:D8)

      ***Since in your excel file is given correct answer, so I give you 1/2.

      Another 1 mark lost is because you have type wrong format of file name. It should be typed in such format:

      “Activity 5.4.1 FUNCTION – Mohammad Iman”

      Well,
      Keep up the good work boy!!

  16. Ezzul syazwan Says:

    FORMULA AND FUNCTION: “sum”
    1. TOTAL MARKS FOR EACH SUBJECT:

    – Maths = 358
    Formula: =C5+C6+C7+C8+C9+C10

    – Eng = 479
    Formula: =D5+D6+D7+D8+D9+D10

    – Science = 277
    Formula: =E5+E6+E7+E8+E9+E10

    – Computer = 332
    Formula: =F5+F6+F7+F8+F9+F10

    – D&T = 380
    Formula: =G5+G6+G7+G8+G9+G10

    2. TOTAL MARKS FOR EACH STUDENT:

    – Angelina Jolie = 378
    Formula: =C5+D5+E5+F5+G5

    – Brad Pitt = 436
    Formula: =C6+D6+E6+F6+G6

    – Nicholas Cage = 340
    Formula =C7+D7+E7+F7+G7

    – Eddie Murphy = 215
    Formula: =C8+D8+E8+F8+G8

    – Melissa Joan Hart = 150
    Formula: =C9+D9+E9+F9+G9

    – Freddie Prince JR = 307
    Formula: =C10+D10+E10+F10+G10

    FUNCTION: “average”
    1. AVERAGE MARKS FOR EACH SUBJECT:

    – Maths = 71.6
    Function: =AVERAGE(C5:C10)
    – English = 79.83333333
    Function: =AVERAGE(D5:D10)
    – Science = 55.4
    Function: =AVERAGE(E5:E10)
    – Computer = 66.4
    Function: =AVERAGE(F5:F10)
    – D&T = 63.33333333
    Function: =AVERAGE(G5:G10)

    2. AVERAGE MARKS FOR EACH STUDENT:

    – Angelina Jolie = 75.6
    Function: =AVERAGE(C5:G5)
    – Brad Pitt = 87.2
    Function: =AVERAGE(C6:G6)
    – Nicholas Cage = 85
    Function: =AVERAGE(C7:G7)
    – Eddie Murphy = 53.75
    Function: =AVERAGE(C8:G8)
    – Melissa Joan Heart = 37.5
    Function: =AVERAGE(C9:G9)
    – Freddie Prince JR = 61.4
    Function: =AVERAGE(C10:G10)

    FUNCTION: “max, min and count”
    1. MAXIMUM MARKS:

    – Maths = 85
    Function: =MAX(C5:C10)
    – English = 95
    Function: =MAX(D5:D10)
    – Science = 87
    Function: =MAX(E5:E10)
    – Computer = 92
    Function: =MAX(F5:F10)
    – D&T = 90
    Function: =MAX(G5:G10)

    2. MINIMUM MARKS:

    – Maths = 50
    Function: =MIN(C5:C10)
    – English = 43
    Function: =MIN(D5:D10)
    – Science = 29
    Function: =MIN(E5:E10)
    – Computer = 30
    Function: =MIN(F5:F10)
    – D&T = 37
    Function: =MIN(G5:G10)

    3. COUNT:

    – Maths = 5
    Function: =COUNT(C5:C10)
    – English = 6
    Function: =COUNT(D5:D10)
    – Science = 5
    Function: =COUNT(E5:E10)
    – Computer = 5
    Function: =COUNT(F5:F10)
    – D&T = 6
    Function: =COUNT(G5:G10)

    • Ezzul,
      I see the logic of the range. However it will be more fun for me to mark your work if you provide me your excel file.

      Since you didn’t provide excel file. Your mark is deducted as described below:

      File name & Attachment: -2

      TOTAL MARKS FOR EACH SUBJECT & TOTAL MARKS FOR EACH STUDENT should be calculated by using FUNCTION, NOT FORMULA.

      Example, your answer:
      -Maths =358
      Formula: =C5+C6+C7+C8+C9+C10

      Instead formula, it should be written in FUNCTION:
      -Maths =358
      Function: =SUM(C5:C10)

      **So for these mistakes, I deduct 10 marks for the wrong format of calculation.

      Overall score: 62 out of 76. Good work!!


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s