Scribd Logo
Upload

Welcome to Scribd!

  • 1 views

    Excel Exercise 4_241007_144049

    Uploaded by

    varnitprateek12345
    Excel practical

    Copyright:

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

    Excel Exercise 4_241007_144049

    Uploaded by

    varnitprateek12345
    1 views4 pages
    Excel practical

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    Excel practical

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    1 views4 pages

    Excel Exercise 4_241007_144049

    Uploaded by

    varnitprateek12345
    Excel practical

    Copyright:

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

    Exercise 4

    1. Use percentage format to show percentage with % symbol.


    Names Roll No. English Maths Science Total Marks Percentage
    Kunal 4 64.00 100.00 89.00
    Akanksha 8 64.00 86.00 87.00
    Kishore 11 65.00 96.00 68.00
    Akash 15 65.00 56.00 89.00
    Manish 7 94.00 42.00 65.00
    Sunil 2 68.00 35.00 98.00
    Mansi 9 21.00 76.00 98.00
    Sanjay 5 44.00 88.00 56.00
    Rajeev 14 55.00 67.00 47.00
    Saurabh 13 45.00 87.00 37.00
    Rajesh 15 55.00 85.00 25.00
    Akash 12 29.00 29.00 95.00
    Vishal 6 84.00 46.00 23.00
    Deepa 10 35.00 66.00 45.00

    Excel Data Sheet


    Output:

    Output Sheet
    2. Calculate Vat 1, Vat 2 and Vat 3 using absolute cell references.

    VAT 1= 7.5% VAT 2 = 10% VAT 3 =12.5%

    Output Sheet

    3. Draw a Table Compute the remaining Fields


    .
    Player’s Balls Played Run Scored Strike rate Team
    name
    Sachin 101 190
    Ganguly 50 51 INDIA
    Rahul 75 30

     Show any Picture in Centre Section using Header option.


     Show any picture as a background of your worksheet.

    You might also like