Scribd Logo
Upload

Welcome to Scribd!

  • 0 views

    TYPO SET 2 KDKVM RENUKOOT PRACTICAL PAPER 2024-25

    Uploaded by

    nv4940

    Copyright:

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

    TYPO SET 2 KDKVM RENUKOOT PRACTICAL PAPER 2024-25

    Uploaded by

    nv4940
    0 views1 page

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    0 views1 page

    TYPO SET 2 KDKVM RENUKOOT PRACTICAL PAPER 2024-25

    Uploaded by

    nv4940

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    You are on page 1of 1

    KDKVM,RENUKOOT

    Subject: Typography & Computer Applications (817)


    Time 3 Hours SET 2 M.M. : 40

    A B C D E F G
    1
    India Call Center
    2 Date 22/10/2024
    3 Name No. Calls Hourly Call per Bonus
    Worked Hour

    4 Abhimayu 42 5 ? ?
    5 Arjun 6 4 ? ?
    6 Karamveer 39 6 ? ?
    7 Dhruv 15 6 ? ?
    8 Mithla 2 7 ? ?
    9
    10 Total ? ? ? ?
    11
    12 Bonus 25%
    Rate

    1. Open a new workbook and save the file with the name “Call Statistics”.
    2. Delete Sheet 2 & 3, and rename Sheet 1 to (Call Statistics).
    3. Set labels alignment appropriately.
    4. Use Warp Test, Orientation and merge cells as desired.
    5. Apply border, gridlines and shading to the table as desired.
    6. Format column E to include euro (€) sign with two decimal places.
    7. Format cell B12 to include % sign with 0 Decimal places.
    8. Calculate the Calls per Hour, enter a formula in cell D4 to divide numbers of calls by Hours
    worked . Using AutoFill, copy the formula to the remaining cells.
    9. Calculate the Bonus. Enter a formula in cell E4 to multiply ‘Calls per Hours’ by the fixed
    Bonus Rate in cell B12, Using AutoFill, copy the formula to the remaining cells.
    10. Calculate the ‘TOTAL’.
    11. Set the worksheet vertically and horizontally on the page.
    12. Create a header that includes your name in the left section, and your ID number in the
    right section. Create the footer that includes the current Date in the center.

    2 Report/Practical Pile (15)


    3 Project (10)
    4 Viva voce (05)

    You might also like