Scribd Logo
Upload

Welcome to Scribd!

  • 569 views

    MS Excel Practical Questions

    Uploaded by

    Stricker Man
    The document provides objectives and steps for a payroll worksheet exercise in MS Excel: - The objectives are to introduce Excel files, worksheets, columns, rows and formatting. Steps include creating a payroll worksheet, entering labels and values, using AutoFill, formatting cells and columns, and adding formulas to calculate gross pay, taxes, and net pay. - Additional steps are to set the worksheet dimensions, save the file, and use headers and footers. Formulas will be added to calculate values like gross pay from hourly rates and hours worked.

    Copyright:

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

    MS Excel Practical Questions

    Uploaded by

    Stricker Man
    569 views5 pages
    The document provides objectives and steps for a payroll worksheet exercise in MS Excel: - The objectives are to introduce Excel files, worksheets, columns, rows and formatting. Steps include creating a payroll worksheet, entering labels and values, using AutoFill, formatting cells and columns, and adding formulas to calculate gross pay, taxes, and net pay. - Additional steps are to set the worksheet dimensions, save the file, and use headers and footers. Formulas will be added to calculate values like gross pay from hourly rates and hours worked.

    Original Description:

    Excel

    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 objectives and steps for a payroll worksheet exercise in MS Excel: - The objectives are to introduce Excel files, worksheets, columns, rows and formatting. Steps include creating a payroll worksheet, entering labels and values, using AutoFill, formatting cells and columns, and adding formulas to calculate gross pay, taxes, and net pay. - Additional steps are to set the worksheet dimensions, save the file, and use headers and footers. Formulas will be added to calculate values like gross pay from hourly rates and hours worked.

    Copyright:

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

    MS Excel Practical Questions

    Uploaded by

    Stricker Man
    The document provides objectives and steps for a payroll worksheet exercise in MS Excel: - The objectives are to introduce Excel files, worksheets, columns, rows and formatting. Steps include creating a payroll worksheet, entering labels and values, using AutoFill, formatting cells and columns, and adding formulas to calculate gross pay, taxes, and net pay. - Additional steps are to set the worksheet dimensions, save the file, and use headers and footers. Formulas will be added to calculate values like gross pay from hourly rates and hours worked.

    Copyright:

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

    MS Excel Practical Questions:

    QNo. 1.
    QNo. 1.
    Objectives:
     Introduction to MS Excel files,
    Workbooks, Worksheets, Columns
    and Rows.
     Formatting Worksheets.
     AutoFill, Numeric formats,
    previewing worksheets.
    a) Create a new workbook as
    shown below and save the file with
    the name <Payroll=.
    b) Enter the labels and values in
    the exact cells locations as desired.
    c) Use AutoFill to put the
    Employee Numbers into cells
    A6:A8.
    d) Set the columns width and
    rows height appropriately.
    e) Set labels alignment
    appropriately.
    f) Use warp text and merge cells
    as desired.
    g) Apply borders, gridlines and
    shading to the table as desired.
    h) Format cell B2 to Short Date
    format.
    i) Format cells E4:G8 to include
    Rs sign with two decimal places.
    j) Calculate the Gross Pay for
    employee; enter a formula in cell
    E4 to multiply Hourly Rate by
    Hours Worked. 11. Calculate the
    Social Security Tax (S.S Tax),
    which is 6% of the Gross Pay;
    enter
    a formula in cell F4 to multiply
    Gross Pay by 6%.
    k) Calculate the Net Pay; enter a
    formula in cell G4 to subtract
    Social Security Tax from Gross
    Pay.
    l) Set the work sheet vertically
    and horizontally on the page Objectives:
     Introduction to MS Excel files, Workbooks, Worksheets, Columns and Rows.
     Formatting Worksheets.
     AutoFill, Numeric formats, previewing worksheets.
    a. Create a new workbook as shown below and save the file with the name <Payroll=.
    b. Enter the labels and values in the exact cells locations as desired.
    c. Use AutoFill to put the Employee Numbers into cells A6:A8.
    d. Create a new workbook as shown below and save the file with the name <Payroll=.
    e. Enter the labels and values in the exact cells locations as desired.
    f. Use AutoFill to put the Employee Numbers into cells A6:A8.
    g. Set the columns width and rows height appropriately.
    h. Set labels alignment appropriately.
    i. Use warp text and merge cells as desired.
    j. Apply borders, gridlines and shading to the table as desired.
    k. Format cell B2 to Short Date format.
    l. Format cells E4:G8 to include Rs sign with two decimal places.
    m. Calculate the Gross Pay for employee; enter a formula in cell E4 to multiply Hourly Rate
    by Hours Worked. 11. Calculate the Social Security Tax (S.S Tax), which is 6% of the
    Gross Pay; enter a formula in cell F4 to multiply Gross Pay by 6%.
    n. Calculate the Net Pay; enter a formula in cell G4 to subtract Social Security Tax from
    Gross Pay.
    o. Set the work sheet vertically and horizontally on the page.
    p. Save your work.
    QNo. 2.
    Objectives:
     Using Formulas.
     Header and Footers.

    You might also like