Scribd Logo
Upload

Welcome to Scribd!

  • 78 views

    Open The Column E For Marks of 50 or Greater, and "Fail" For Marks Below 50. in Next Column Print The Grades of Students

    Uploaded by

    Shaun Pollock
    1. Use the IF function to evaluate student marks and assign a "pass" or "fail" in one column and letter grades in another based on marks above or below 50. 2. Create a spreadsheet to calculate employee deductions and net pay using data from a file called "deduction.xls". 3. Use formulas to assign prizes of GOLD, SILVER, or BRONZE to student results based on their POINTS and categories defined in the document.

    Copyright:

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

    Open The Column E For Marks of 50 or Greater, and "Fail" For Marks Below 50. in Next Column Print The Grades of Students

    Uploaded by

    Shaun Pollock
    78 views3 pages
    1. Use the IF function to evaluate student marks and assign a "pass" or "fail" in one column and letter grades in another based on marks above or below 50. 2. Create a spreadsheet to calculate employee deductions and net pay using data from a file called "deduction.xls". 3. Use formulas to assign prizes of GOLD, SILVER, or BRONZE to student results based on their POINTS and categories defined in the document.

    Original Title

    Session 5

    Copyright

    © © All Rights Reserved

    Available Formats

    DOCX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    1. Use the IF function to evaluate student marks and assign a "pass" or "fail" in one column and letter grades in another based on marks above or below 50. 2. Create a spreadsheet to calculate employee deductions and net pay using data from a file called "deduction.xls". 3. Use formulas to assign prizes of GOLD, SILVER, or BRONZE to student results based on their POINTS and categories defined in the document.

    Copyright:

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

    Open The Column E For Marks of 50 or Greater, and "Fail" For Marks Below 50. in Next Column Print The Grades of Students

    Uploaded by

    Shaun Pollock
    1. Use the IF function to evaluate student marks and assign a "pass" or "fail" in one column and letter grades in another based on marks above or below 50. 2. Create a spreadsheet to calculate employee deductions and net pay using data from a file called "deduction.xls". 3. Use formulas to assign prizes of GOLD, SILVER, or BRONZE to student results based on their POINTS and categories defined in the document.

    Copyright:

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

    Session 5: Microsoft Excel- If Function/Choose/ Small/ Large

    1. Open the student-marks.xls spreadsheet. Use IF function to enter “pass” in


    column E for marks of 50 or greater, and “fail” for marks below 50. In next
    column print the grades of students

    Marks Grade
    Greater than 70 A
    Greater than 50 B
    Less than 50 D

    2. Company ABC asked you to create a spreadsheet which will calculate deductions and net
    pay of their employees. The date is given in deduction.xls

    3. In department “ Hindi Sikho” Completion’s results are out and its been decided to award medals
    as POINTS>=80 – GOLD, POINTS>=70 – SILVER, POINTS>=60 – BRONZE, POINTS LESS THAN 60 –
    TAI TAI FISH

    The results are :

    A B C

    1 Name Points Prize

    2 A 82

    3 B 55

    4 C 72

    5 D 61

    6 E 76

    4. Find out total salary to be paid in the month of March for IT department
    A B C D E F G H I J K L M N

    1 Income Deductions

    STAYI AVAIL-
    Name Total NG IN ING
    2
    Grade Basic GOVT TRAN TR. Grand CH OTH
    Basic Pay Pay DA QTR HRA PORT ALL Total GPF SS CGEIS RS

    4 Ramesh 15600 6600 Y N 100 200 1

    5 Ram 20600 7600 Y N 100 200 1

    6 Raj 25600 8000 Y N 100 200 1

    7 Priya 15600 6600 Y N 100 200 1

    8 Pallavi 13600 3400 Y N 100 200 1

    15 Manish 15600 6600 N Y 100 200 1

    16 Total

    Rules

    1) Total Basic Pay = GPF


    2) DA is 113% of total Badic
    3) Those who are not staying in Quarters will get 30% HRA
    4) Those Who are not availing transport facility will get 3700
    5) Use Auto sum function for total Basic Grade ___
    5. Calculate the income Tax for following employees

    A C D

    1 NAME TAXABLE INCOME TAX

    INCOME

    2 A 310000

    3 B 700000

    4 C 320000

    5 D 510000

    6 E 1950000

    7 F 350000

    8 G 310000

    9 H 156000

    10 I 320000

    11 J 850000

    Taxable Salary <= 250000 No tax


    250000 to 500000 10%
    500000 to 1000000 20%
    1000000 30%

    6. The list of students who appeared for BARC entrance is given (Enter data for 5 students).
    The columns are name of applicant, roll no., category, Marks for P1, P2,P3 are given.
    Based on following conditions find out how many cleared the first round of exam.
    Conditions are
    Open Category – P1 >=50 P2>=50, P3 >= 50 and total >=60
    OBS --- P1 >=45 P2 >= 45 p3 >=45 and total >=50
    ST/Sc --- P1>=35 P2>= 35 P3>=35 and total >=40

    7. Large and Small Function use choose function file Choose function

    You might also like