Scribd
Upload
8 views2 pages

Assignment

The document contains two assignments related to salary and sales reports, requiring the use of various Excel formulas. The first assignment focuses on calculating employee salaries and categorizing them based on total salary, while the second assignment involves analyzing sales performance against targets. Key tasks include using functions like Countif, Sumif, and Vlookup to extract and compute necessary data.

Uploaded by

ictyeartwostudentskyambogouniv
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
8 views2 pages

Assignment

The document contains two assignments related to salary and sales reports, requiring the use of various Excel formulas. The first assignment focuses on calculating employee salaries and categorizing them based on total salary, while the second assignment involves analyzing sales performance against targets. Key tasks include using functions like Countif, Sumif, and Vlookup to extract and compute necessary data.

Uploaded by

ictyeartwostudentskyambogouniv
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

Assignment (Salary Sheet)

Use of Formulas

NAME DEPARTMENT POST BASIC DA 2.5% HRA 3.5% PF 1.5% TOTAL GRADE
RAM COMPUTER MANAGER 5000 125 175 50 5250 D
SHYAM COMPUTER SUPERVISOR 8000 ? ? ? ? ?
MANOJ COMPUTER PION 3000 ? ? ? ? ?
POOJA ELECTRICAL GUARD 6000 ? ? ? ? ?
RAHUL ELECTRICAL CASHER 8000 ? ? ? ? ?
RAKESH ELECTRICAL ACCOUNTANT 9000 ? ? ? ? ?
ASHISH FINANCE MANAGER 10000 ? ? ? ? ?
MANISH FINANCE GUARD 5000 ? ? ? ? ?
Q.1 HOW MANY EMPLOYEE IN COMPUTER, FINANCE, ELECTRICAL DEPARTMENT Use of
Countif
Q.2 HOW MANY BASIC SALARY IN COMPUTER DFPARTMENT ONLY? Use of Sumif
Q.3 MANOJ, ASHISH POST & GRADE Use of
Vlookup
Q.4 IF TOTAL SALALRY IS GREATER THEN 20000 THEN "A", IF TOTAL SALARY GREATER THEN 10000
THEN "B", OTHERWISE "C"
Q.5 HOW MANY EMPLOYEE IS MANAGER & GUARD? Use of Countif

Assignment -5 (Sales Report)


Use of Formulas - Sum, If,

SALESMAN JAN FEB MAR APR MAY JUNE SALES TARGET RESULT
NOT ACHIVED
RAMESH 2000 1500 300 1400 1000 1400 7600 10000
RAKESH 5000 1200 500 1200 1200 2800 ? 12000 ?
RAHUL 3000 800 1200 3000 1500 3500 ? 18000 ?
POOJA 1000 900 1800 5000 1400 1200 ? 10000 ?
MANOJ 500 1000 2300 8000 1700 1400 ? 12000 ?
ASHOK 800 500 2400 1900 1800 1800 ? 10000 ?
AJEET 1200 1400 1500 700 2500 7000 ? 12000 ?
ALOK 1500 1800 1800 1800 300 1500 ? 10000 ?
AMRIT 1800 2500 1700 1500 2800 1800 ? 12000 ?
SURENDRA 200 3000 1900 1200 1500 3000 ? 10000 ?
SHASHI 1600 1200 2000 800 1700 800 ? 10000 ?
Q.1 How many salesman? Salesman Ajeet Targest & Result? Use of Counta and Vlookup
Q.2 If Sales Greater Than Target Then Target Achived otherwise Not
Achived Use of If Function

Q.3 Rahul Pooja & Ashok Targest & result? Use of Vlookup

You might also like