Scribd Logo
Upload

Welcome to Scribd!

  • 172 views

    MS Excel Praticals

    Uploaded by

    Cornelius Chiko Mwansa
    The document provides instructions for creating two worksheets using formulas and formatting. The first worksheet involves creating a call statistics table with formulas to calculate calls per hour and bonuses. The second worksheet involves creating an employee data table with formulas to calculate commissions, total salaries, and totals/averages/minimums/maximums. Both worksheets require setting up headers, footers, formatting numbers and cells, and other formatting details.

    Copyright:

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

    MS Excel Praticals

    Uploaded by

    Cornelius Chiko Mwansa
    172 views3 pages
    The document provides instructions for creating two worksheets using formulas and formatting. The first worksheet involves creating a call statistics table with formulas to calculate calls per hour and bonuses. The second worksheet involves creating an employee data table with formulas to calculate commissions, total salaries, and totals/averages/minimums/maximums. Both worksheets require setting up headers, footers, formatting numbers and cells, and other formatting details.

    Original Description:

    Practical advice

    Original Title

    MS EXCEL PRATICALS

    Copyright

    © © All Rights Reserved

    Available Formats

    DOCX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document provides instructions for creating two worksheets using formulas and formatting. The first worksheet involves creating a call statistics table with formulas to calculate calls per hour and bonuses. The second worksheet involves creating an employee data table with formulas to calculate commissions, total salaries, and totals/averages/minimums/maximums. Both worksheets require setting up headers, footers, formatting numbers and cells, and other formatting details.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    172 views3 pages

    MS Excel Praticals

    Uploaded by

    Cornelius Chiko Mwansa
    The document provides instructions for creating two worksheets using formulas and formatting. The first worksheet involves creating a call statistics table with formulas to calculate calls per hour and bonuses. The second worksheet involves creating an employee data table with formulas to calculate commissions, total salaries, and totals/averages/minimums/maximums. Both worksheets require setting up headers, footers, formatting numbers and cells, and other formatting details.

    Copyright:

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

    lOMoARcPSD|2847416

    1. Objectives:
     Using Formulas.

     Header and Footers.

    a) Create a new workbook as shown below and save the file with the name “Call Statistics”.

    b) Rename Sheet 1 to (Call Statistics).

    c) Enter the labels and values in the exact cells locations as desired.

    d) Set the row height of rows 1 & 3 to size 30; and rows 4 until 10 to size 20.

    e) Set labels alignment appropriately.

    f) Use Warp Text, Orientation and merge cells as desired.


    g) Apply border, gridlines and shading to the table as desired.

    h) Format column E to include Rs sign with two decimal places.

    i) Format cell B12 to include % sign with 0 Decimal places.


    j) 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.
    k) 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.
    l) Calculate the ‘TOTAL’. 13. Set the worksheet vertically and horizontally on the page.

    m) 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.
    3. Objectives:
    lOMoARcPSD|2847416

     Number, Commas and Decimal numeric formats.

     Working with Formulas (Maximum, Minimum, Average, Count and Sum).

     Percentage Numeric Formats.

    a) Create the worksheet shown above.

    b) Set the column widths as follows: Column A: 8, Column B: 14, Columns C & D: 15,
    Columns E & F: 14.
    c) Enter the formula to find COMMISSION for the first employee. The commission
    rate is 2% of sales, COMMISSION = SALES * 2% Copy the formula to the
    remaining employees.
    d) Enter the formula to find TOTAL SALARY for the first employee where: TOTAL
    SALARY = SALARY + COMMISSION Copy the formula to the remaining
    employees.
    e) Enter formula to find TOTALS, AVERAGE, HIGHEST, LOWEST, and COUNT
    values. Copy the formula to each column.
    f) Format numeric data to include commas and two decimal places.
    g) Align all column title labels horizontally and vertically at the center.

    h) Create a Header that includes your name in the left section, page number in the center
    section, and your ID number in the right section.
    i) Create footer with DATE in the left section and TIME in the right section.
    j) Save the file with name panda EST.
    lOMoARcPSD|2847416

    You might also like