Scribd Logo
Upload

Welcome to Scribd!

  • 26 views

    Mark Sheet: Subject Name UT - 1 TM - 1 Total Marks Obt

    Uploaded by

    sanchit jeena
    The document is a mark sheet that provides subject scores and percentages for 5 students across 5 subjects. It calculates total marks and percentage for each student. The summary is: 1) The mark sheet shows subject scores for 5 students across 5 subjects. 2) It calculates total marks scored and percentage for each student. 3) Formulas are used to automatically sum scores and calculate percentages.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd

    Mark Sheet: Subject Name UT - 1 TM - 1 Total Marks Obt

    Uploaded by

    sanchit jeena
    26 views23 pages
    The document is a mark sheet that provides subject scores and percentages for 5 students across 5 subjects. It calculates total marks and percentage for each student. The summary is: 1) The mark sheet shows subject scores for 5 students across 5 subjects. 2) It calculates total marks scored and percentage for each student. 3) Formulas are used to automatically sum scores and calculate percentages.

    Original Description:

    excel

    Original Title

    excel

    Copyright

    © © All Rights Reserved

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document is a mark sheet that provides subject scores and percentages for 5 students across 5 subjects. It calculates total marks and percentage for each student. The summary is: 1) The mark sheet shows subject scores for 5 students across 5 subjects. 2) It calculates total marks scored and percentage for each student. 3) Formulas are used to automatically sum scores and calculate percentages.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    26 views23 pages

    Mark Sheet: Subject Name UT - 1 TM - 1 Total Marks Obt

    Uploaded by

    sanchit jeena
    The document is a mark sheet that provides subject scores and percentages for 5 students across 5 subjects. It calculates total marks and percentage for each student. The summary is: 1) The mark sheet shows subject scores for 5 students across 5 subjects. 2) It calculates total marks scored and percentage for each student. 3) Formulas are used to automatically sum scores and calculate percentages.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    of 23

    MARK SHEET

    Subject Name UT - 1 TM - 1 Total Marks Obt.


    English 56 62

    Accounts 48 75

    IT 67 56

    IT 75 70

    IT 87 93

    Total Marks out of 500

    Total Precentage Obt.


    MARK SHEET
    Subject Name UT - 1 TM - 1 Total Marks Obt. Formula
    Marks Out Marks Out
    of 100 of 100
    English 56 62 118 =SUM(B4:C4)
    Accounts 48 75 123 =SUM(B5:C5)
    IT 67 56 123 =SUM(B6:C6)
    IT 75 70 145 =SUM(B7:C7)
    IT 87 93 180 =SUM(B8:C8)
    Total Marks 333 356 689 =SUM(D4:D8)
    Total Percentage Obt. 66.6 71.2 68.9 =D9*100/1000
    EXCEL PERCENTILE FUNCTION
    Name Part Name
    Ankit Anki
    Tushar Tush
    Rohit Rohi
    Mahesh Mahe
    Abhinav Abhi
    EXCEL PERCENTILE FUNCTION
    Formula
    =LEFT(A3,4)
    =LEFT(A4,4)
    =LEFT(A5,4)
    =LEFT(A6,4)
    =LEFT(A7,4)
    USE OF PERCENTILE METHOD
    First Name Last Name Name Formula
    Ankit Ahuja Ankit Ahuja =A3&" "&B3
    Tushar Agarwal Tushar Agarwal =A4&" "&B4
    Rohit Sharma Rohit Sharma =A5&" "&B5
    Mahesh Dutta Mahesh Dutta =A6&" "&B6
    Abhaniv Khurana Abhaniv Khurana =A7&" "&B7
    Name Subject English Accounts Web Application Data Application Informatics
    Ram ut 1 56 48 67 75 87
    tm 1 62 75 56 70 93
    Prem ut 1 50 42 67 75 87
    tm 1 62 75 86 76 90
    Rohit ut 1 69 67 67 75 87
    tm 1 82 75 76 98 92
    M A R K S

    Comparison of MARK Sheet


    100
    80 English
    60 Accounts
    40 Web Application
    Data Application
    20
    Informatics
    0

    S T U D E N T S
    English
    Accounts
    Web Application
    Data Application
    Informatics
    FIND OUT THE GREATER NUMBER
    Physics Maths Result Formula

    56 45 Physics is Greater =IF(A3>B3,"Physics is Greater","Maths is Greater")

    67 43 Physics is Greater =IF(A4>B4,"Physics is Greater","Maths is Greater")

    89 98 Maths is Greater =IF(A5>B5,"Physics is Greater","Maths is Greater")

    76 45 Physics is Greater =IF(A6>B6,"Physics is Greater","Maths is Greater")

    28 36 Maths is Greater =IF(A7>B7,"Physics is Greater","Maths is Greater")

    34 58 Maths is Greater =IF(A8>B8,"Physics is Greater","Maths is Greater")

    56 67 Maths is Greater =IF(A9>B9,"Physics is Greater","Maths is Greater")

    68 53 Physics is Greater =IF(A10>B10,"Physics is Greater","Maths is Greater")


    RESULT SHEET OF 12 Studentes
    Roll No Name Phy Maths Bio Eng Comp Total Percent
    age(%) Grade Formula's

    1 A 56 45 27 67 69 264 52.8 PASS =IF(I3>=40,"PASS","FAIL")


    2 B 67 43 54 64 48 276 55.2 PASS =IF(I4>=40,"PASS","FAIL")
    3 C 89 98 58 58 53 356 71.2 PASS =IF(I5>=40,"PASS","FAIL")
    4 D 23 26 51 23 56 179 35.8 FAIL =IF(I6>=40,"PASS","FAIL")
    5 E 76 45 63 59 45 288 57.6 PASS =IF(I7>=40,"PASS","FAIL")
    6 F 28 36 59 64 56 243 48.6 PASS =IF(I8>=40,"PASS","FAIL")
    7 G 34 58 87 39 43 261 52.2 PASS =IF(I9>=40,"PASS","FAIL")
    8 H 22 26 21 23 56 148 29.6 FAIL =IF(I10>=40,"PASS","FAIL")
    9 I 56 67 56 42 47 268 53.6 PASS =IF(I11>=40,"PASS","FAIL")
    10 J 68 53 67 54 87 329 65.8 PASS =IF(I12>=40,"PASS","FAIL")
    11 K 78 50 89 65 65 347 69.4 PASS =IF(I13>=40,"PASS","FAIL")
    12 L 76 26 76 55 56 289 57.8 PASS =IF(I14>=40,"PASS","FAIL")
    MARKS

    Phy
    Maths
    Bio
    Eng
    Comp
    A B C D E F G H I J K L
    RESULT FOR TOTAL SALES OF GOODS
    Region Jan Feb Mar Total Sales Avg Sales Target Achived Formula
    Delhi 1000 890 1200 3090 1030.0 25.750% =E3/12000*100
    Chennai 750 1000 850 2600 866.7 21.667% =E4/12000*100
    Mumbai 1200 1200 1100 3500 1166.7 29.167% =E5/12000*100
    Kolkatta 1440 1500 1150 4090 1363.3 34.083% =E6/12000*100

    TARGET SALES - 12000


    Target Achived in different Region

    4300 Jan
    Target Achived

    3300 Feb
    Mar
    2300
    Total Sales
    1300 Avg Sales
    300 Target Achived

    -700 Delhi Chennai Mumbai Kolkatta

    Region
    Target Achived
    T
    300

    -700 Delhi Chennai Mumbai Kolkatta

    Region
    4500

    4000

    3500

    3000 Jan
    2500 Feb
    Mar
    2000 Total Sales
    1500 Avg Sales
    Target Achived
    1000

    500

    0
    Delhi Chennai Mumbai Kolkatta
    Target Achived
    1000

    500

    0
    Delhi Chennai Mumbai Kolkatta

    d
    d
    PIVOT TABLES
    Product Quarter Sales
    Car First 1000
    Bike Second 1400
    Bike Fourth 1300
    Car Third 1200
    Scooter First 1000
    Scooter Second 900
    PROFIT and LOSS ACCOUNT
    Date Particular Amt. Date Particular Amt. Formula
    To Bal. bd By Bal bd 1500
    To Salary 2000
    To Rent 4500
    To Depreciation 450
    To Interest 1200

    To Bal. cd By Bal. cd 6650 =F11-F4


    8150 8150 =SUM(C5:C10) and =C11
    RESULT FOR TOTAL SALES OF GOODS
    Region Jan Feb Mar Total Sales Avg Sales Target Achived
    Delhi 1000 890 1200 3090 1030.0 25.75%
    Chennai 750 1000 850 2600 866.7 21.67%
    Mumbai 1200 1200 1100 3500 1166.7 29.17%
    Kolkatta 1440 1500 1150 4090 1363.3 34.08%

    TARGET SALES - 12000


    ODS
    Formula
    =E3/12000*100
    =E4/12000*100
    0
    =E5/12000*100 00 Jan
    12 0
    =E6/12000*100 00 Feb
    10 0
    0
    80 Mar
    00
    60 Total
    00
    40 Sales
    00
    20 Avg
    0
    Delhi Chennai Mumbai Kolkatta Sales

    Target
    Achived
    Jan

    Feb

    Mar

    Total
    Sales

    Avg
    Sales

    Target
    Achived
    RESULT FOR TOTAL SALES OF GOODS
    Avg Target
    Region Jan Feb Mar Total Sales Sales Achived
    Delhi 1000 890 1200 3090 1030.0 25.75%
    Chennai 750 1000 850 2600 866.7 21.67%
    Mumbai 1200 1200 1100 3500 1166.7 29.17%
    Kolkatta 1440 1500 1150 4090 1363.3 34.08%
    TARGET SALES - 12000
    ODS
    Formula
    =E3/12000*100
    =E4/12000*100
    =E5/12000*100
    =E6/12000*100

    You might also like