Excel Practical class

MS-EXCEL 2007 PRACTICAL TASK

1:- What is Excel: = Excel is an Electronic spreadsheet package for performing calculations related work.

        This spreadsheet program allows you to manipulate and present your data in almost any way you choose. It allows you work on a tabular pad consisting of columns and rows where you can perform all your mathematical, financial and statistical calculations. These calculation can be as simple as totaling a row or a column of values or as complex as figuring the rate of return on an investment under varying circumstances. It also allows you to make a graphical representation of all your data in the form of 2-dimentional or 3-dimentional graph or pie chart.

Example: – Microsoft Office Excel, Lotus 1-2-3, Symphony, VP-Planner etc.

2:- How to Open Excel in Your Computer: =

i) Startè All programsè Microsoft Officeè Microsoft Office Excel 2007

        ii)Startè Run…. (Type Excel in the Open Box) èPress OK/Enter key from the Keyboard

3:- What is Cell in Excel: = A cell is the intersection of a column and row. Each and every cell has a unique address known as cell address. Cell address is the combination of Column name and Row number. For example, A1 is a cell address; where A is the Column name and 1 is the Row number.

4:-What is Worksheet in Excel: – Worksheet consists of horizontal numbered rows and vertical columns identified with letters. The resulting boxes are called cells. A cell can hold number, text and formula. A worksheet consists of 16384 columns (A to XFD) and 1048576 rows (ver. – 2007).

5:-What is Workbook in Excel: – A workbook is a collection of worksheets and the number of sheets for a workbook is limited to your permanent storage area. Whenever you save the file in Excel, it is stored as workbook file that has the default extension name (Excel-2007) .xlsx. By default a workbook can hold three worksheet as sheet1, sheet2, sheet3.

6:- What is Workspace in Excel 2007:- Workspace is a file having extension name .xlw, which holds the references of other workbook files. You can open a group of workbooks in one step by creating a workspace file. A workspace file saves information about all open workbooks, such as their locations, window sizes, and screen positions. Procedure== Fileè save workspaceè save.

6:-   Number of Rows in a worksheet in version 2007 Excel – 1048576.

        Numbers of Columns in a worksheet in version 2007 Excel– 16384.

7:- How you insert a New sheet in Excel 2007 Version:-

i)                                          Right click on the sheet tab.

ii)                                       Select insert option.

iii)                                   Choose worksheet.

iv)                                    Click Ok.

8:- How we Delete a Sheet in Excel 2007 Version:-

i)                                          Right click on the sheet tab, which you want to delete.

ii)                                       Select delete option.

iii)                                   Click ok.

9:- How we Rename a Sheet in Excel 2007 Version:-

i)                                          Right click on the sheet tab, which you want to rename.

ii)                                       Select rename option.

iii)                                   Give the name.

iv)                                    Press enter.

10:- How to move a sheet within the current workbook?

i)                                          Click the sheet on the sheet tab, which you want to move.

ii)                                       Drag the selected sheets along the row of sheet tabs holding the left mouse button.

iii)                                   Release the mouse button at the place where you want to keep the sheet.

11:- How to copy a sheet within the current workbook?

i)                                          Click the sheet on the sheet tab, which you want to copy.

ii)                                       Hold down CTRL, and then drag the sheet along the row of sheet tabs holding the left mouse button.

iii)                                   Release the mouse button before you release the CTRL key at the place where you want to keep the copy of the sheet.

13:- Operators in Excel 2007:-

i)                 Mathematical Operator in Excel: – to perform basic mathematical operations such as addition, subtraction, or multiplication etc.

Arithmetic operatorMeaningExample
+ (plus sign)Addition       3+3=6
– (minus sign)Subtraction       3–1=2
* (asterisk)Multiplication       3*3=9
/ (forward slash)Division       5/3=1.666667
% (percent sign)Percent20%
^ (caret)Exponentiation3^2 (the same as 3*3)=9

ii)             Comparison Operator / Logical Operator in Excel: – To compare two values.

Comparison operatorMeaningExample
 = (equal sign)Equal toA1=B1
> (greater than sign)Greater thanA1>B1
< (less than sign)Less thanA1<B1
>= (greater than or equal to sign)Greater than or equal toA1>=B1
<= (less than or equal to sign)Less than or equal toA1<=B1
<> (not equal to sign)Not equal toA1<>B1

iii)          Text concatenation operator:-   Text concatenation operator Use the ampersand (&) to join, or concatenate, one or more text strings to produce a single piece of text.

Text operatorMeaningExample
& (ampersand)Connects, or concatenates, two values to produce one continuous text value  “Super” & “star”       produce “Superstar”
SOME EXCEL FUNCTION
TEXT FUNCTION IN EXCEL 2007
FUNCTION NAMECALCULATIONRESULT
UPPER() =UPPER(“abcd”)ABCD
LOWER() =LOWER(“ABCD”)abcd
LEN() =LEN(“RAJ”)3
REPT() =REPT(“RAJ  “,3)RAJ  RAJ  RAJ 
RIGHT() =RIGHT(“RAHUL”,3)HUL
LEFT() =LEFT(“RAHUL”,3)RAH
MID() =MID(“KARAN”,2,3)ARA
CONCATENATE() =CONCATENATE(“GOOD”,”MORNING”)GOODMORNING
PROPER() =PROPER(“WEBEL COMPUTER CENTRE”)Webel Computer Centre
TRIM() =TRIM(“      WEBEL”)WEBEL
VALUE() =VALUE(“123”)123
ROWS() =ROWS(A:A)65536
COLUMNS() =COLUMNS(1:1)256
MATHEMATICAL AND TRIGONOMETRIC FUNCTION IN EXCEL 2007
FUNCTION NAMECALCULATIONRESULT
ABS()=ABS(-210.67)210.67
COS()=COS(0.2)0.980066578
EVEN()=EVEN(210.61)212
EXP()=EXP(3)20.08553692
FACT()=FACT(3)6
INT()=INT(210.67)210
LOG()=LOG(20)1.301029996
MOD()=MOD(5,2)1
ODD()=ODD(210.61)211
PI()=PI(19)30141592654
POWER()=POWER(5,2)25
PRODUCT()=PRODUCT(5,5,5)125
ROMAN()=ROMAN(5)V
ROUND()=ROUND(210.67,0)211
SQRT()=SQRT(25)5
SUBTOTAL()=SUBTOTAL()
SUM()=SUM(5,5,5) OR SUM(A1:A10) OR SUM(A1+A2)15
SUMIF()=SUMIF()
STATISTICAL FUNCTION IN EXCEL 2007
FUNCTION NAMECALCULATIONRESULT
AVERAGE()=AVERAGE(5,5,5)5
COUNT()=COUNT(1,7,8,6,3)5
COUNTIF()=COUNTIF()
MAX()=MAX(4,5,7,9,3)9
MIN()=MIN(4,7,3,1,4)1
LOOKUP AND REFERENCE FUNCTION IN EXCEL 2007
FUNCTION NAMECALCULATIONRESULT
VLOOKUP()VERTICAL LOOK UP CALCULATION 
HLOOKUP()HORIZANTAL LOOK UP CALCULATION 
DATE AND TIME FUNCTION IN EXCEL 2007
FUNCTION NAMECALCULATIONRESULT
DATE()=DATE(2014,4,2)2/4/2014
DAY()=DAY(2/4/2014)2
HOUR()=HOUR(12:00:15)12
MINUTE()=MINUTE(12:01:12)1
MONTH()=MONTH(2/4/2014)4
NOW()=NOW()4/2/2014 12:02
SECOND()=SECOND(12:00:15)15
TIME()=TIME(12,2,5)12:02PM
TODAY()=TODAY()2/4/2014
WEEKDAY()=WEEKDAY(2/4/2014)4
YEAR()=YEAR(2/4/2014)2014
FINANCIAL FUNCTION IN EXCEL 2007
FUNCTION NAMECALCULATIONRESULT
PMT()=PMT(interest_rate, number_payments, PV, [FV], [Type] ) 
IPMT()=IPMT(interest_rate, period, number_payments, PV, [FV], [Type]) 
PPMT()=PPMT(interest_rate, period, number_payments, PV, [FV], [Type]) 
FV()=FV() 
IRR()=IRR() 
NPV()=NPV(discount_rate, value1, [value2, … value_n]) 
PV()=PV(interest_rate, number_payments, payment, [FV], [Type]) 
RATE()=RATE(number_payments, payment, PV, [FV], [Type], [Estimate]) 
NPER()=NPER(interest_rate, payment, PV, [FV], [Type]) 
SYD()=SYD(cost, salvage, life, period) 
SLN()=SLN() 
LOGICAL FUNCTION IN EXCEL 2007
FUNCTION NAMECALCULATIONRESULT
AND()=AND( condition1, [condition2], … ) 
IF()=IF( condition, [value_if_true], [value_if_false] ) 
NOT()=NOT( logical_value ) 
OR()=OR( condition1, [condition2], … ) 
FALSE()=FALSE( ) 
TRUE()=TRUE( ) 

ð  PRACTICAL TASK-1

 STOCK SHEET CALCULATION 
       
SL NOPRODUCT NAMEQUANTITYPRICE/QUANTITYTOTAL PRICEDISCOUNT (10%)TOTAL PRICE (AFTER DISCOUNT 10%)VAT (4%)TOTAL PRICE (WITH VAT 4%)
1COMPUTER12Rs. 18,500.00Rs. 222,000.00Rs. 22,200.00Rs. 199,800.00Rs. 7,992.00Rs. 207,792.00
2PRINTER25Rs. 2,600.00Rs. 65,000.00Rs. 6,500.00Rs. 58,500.00Rs. 2,340.00Rs. 60,840.00
3UPS45Rs. 1,850.00Rs. 83,250.00Rs. 8,325.00Rs. 74,925.00Rs. 2,997.00Rs. 77,922.00
4KEYBOARD200Rs. 225.00Rs. 45,000.00Rs. 4,500.00Rs. 40,500.00Rs. 1,620.00Rs. 42,120.00
5CD-R/W25Rs. 1,250.00Rs. 31,250.00Rs. 3,125.00Rs. 28,125.00Rs. 1,125.00Rs. 29,250.00
6DVD-R/W45Rs. 1,600.00Rs. 72,000.00Rs. 7,200.00Rs. 64,800.00Rs. 2,592.00Rs. 67,392.00
7MOUSE120Rs. 150.00Rs. 18,000.00Rs. 1,800.00Rs. 16,200.00Rs. 648.00Rs. 16,848.00
8PEN DRIVE35Rs. 425.00Rs. 14,875.00Rs. 1,487.50Rs. 13,387.50Rs. 535.50Rs. 13,923.00
   GRAND TOTALRs. 551,375.00Rs. 55,137.50Rs. 496,237.50Rs. 19,849.50Rs. 516,087.00

CALCULATION:-

          TOTAL PRICE= (PRICE/QUANTITY*QUANTITY)

          DISCOUNT= (TOTAL PRICE*10%)

          TOTAL PRICE AFTER DISCOUNT=TOTAL PRICE-DISCOUNT

          VAT (4%) = (TOTAL PRICE AFTER DISCOUNT*4%)

          TOTAL PRICE WITH VAT (4%) =TOTAL PRICE AFTER DISCOUNT+ VAT(4%)

ð  PRACTICAL TASK-2

ð      IF() Function :- IF is a Logical Function are used to compare values and perform calculations accordingly.

ð      Syntax:- IF(Condition, True Value , False Value), where Condition is a logical expression that can be evaluated to TRUE or FALSE, True Value is the value or expression that is returned if the condition is true and False Value is the value or expression that is returned if condition is false.

ð      Example:- IF(100>50, “100 is Greater than 50” , “100 is less than 50”)

§  Return:- 100 is Greater than 50

ð      Example:- IF(100<50,1,0)

§  Return:- 0

ð      Example: – IF (F2>=7000, F2*15%, F2*10%)

ð      Nested IF() Statement Structure for Three Conditions:-

§  Syntax:- IF(Condition1, True Value , IF(Condition2 , True Value , False Value))

§  Syntax:- IF(Condition1,IF(Condition2, True Value, False Value), False Value)

ð  PRACTICAL TASK-3

SL NONAMEAGESTATUS
1RIJU15NONVOTER
2NILAS21VOTER
3RAJU12NONVOTER
4NILAVA20VOTER
5SUMAN17NONVOTER

CONDITION:-

          STATUS=IF AGE>=18 THE HE/SHE IS VOTER OR HE/SHE WILL BE NOT VOTER

ð      AND() Function:- This Function is used to check whether multiple conditions are true simultaneously or not.

ð      Syntax:- AND( LogicalArgument1, LogicalArgument2, LogicalArgument3, ………., LogicalArgumentN)

ð      Example:-

§  AND(1+2=3, 2+3=5) Return TRUE

§  AND(1+2=3, 2+3=4) Return FALSE

§  AND(1<B15,B15<100) Return TRUE

ð  PRACTICAL TASK-4

SELECTION PROCEDURE
NAMEHEIGHTWEIGHTCHESTAGEMARKS(M.P)STATUS
ANIRBAN16851802160SELECTED
SUMAN15542823278CANCLED
TARUN14555841754CANCLED
RAMESH16658812261SELECTED
NIRMAL16557801962CANCLED
BISWAJIT16851892367SELECTED

CONDITION:-

       STATUS= IF HEIGHT>=165 AND WEIGHT>=45 AND CHEST>=80 AND AGE>=20 AND MARKS (M.P)>=60 THEN HE/SHE WILL BE SELECTED OTHERWISE HE/SHE WILL BE CANCLED

ð      OR() Function:- This Function is used to check whether at least a single condition out of multiple condition out of multiple is true or not.

ð      Syntax:- OR(LogicalArgument1, LogicalArgumrnt2, LogicalArgument3, ……., LogicalArgumrntN)

ð      Example:-

§  OR(1+2=3, 2+3=5) Return TRUE

§  OR(1+2=3, 2+3=4) Return TRUE

§  OR(1+2=4, 2+3=4) Return FALSE

ð      IF() AND() Condition:-

§  IF(AND(Logical Condition1 , Logical Condition2),True Value, False Value)

ð      IF() OR() Condition:-

§  IF(OR(Logical Condition1, Logical Condition2), True Value, False Value)

ð  PRACTICAL TASK-5

GRADE OF SALESMAN
SALSEMANSALE AMOUNTPROFITGRADE
AA700008000A
BB800005500A
CC450001000C
DD500004000B
EE520003400C
FF600001000C

CONDITION:-

              1:- IF SALE AMOUNT IS MORE THAN 70000 OR PROFIT IS MORE THAN OR EQUAL TO 10% OF SALE AMOUNT THEN GRADED AS A.

                2:- IF SALE AMOUNT IS MORE THAN 60000 OR PROFIT IS MORE THAN OR EQUAL TO 8% OF SALE AMOUNT THEN GRADED AS B OTHERWISE GRADED AS C .                                                                       

ð  PRACTICAL TASK-6

MARK SHEET OF M.P  (RESULT)
  FIRST LANGUAGESECOND LANGUAGEHISTORYGEOGRAPHYLIFE SC.PHY. SC.MATHEMATICSOVER ALL STATUS
  
ROLL NOSTUDENT NAMEMARKS OBTAINEDGRADEMARKS OBTAINEDGRADEMARKS OBTAINEDGRADEMARKS OBTAINEDGRADEMARKS OBTAINEDGRADEMARKS OBTAINEDGRADEMARKS OBTAINEDGRADETOTALPERCENTAGEOVERALL GRADEPERFORMANCE INDICATOR
1ANIRBAN KUNDU35B58B+65A37B69A54B+65A38354.71%B+GOOD
2SUKUMAR PATRA29C57B+39B35B45B+38B58B+30143.00%BSATISFACTORY
3SAIKAT JANA48B+69A84A+69A84A+69A79A50271.71%AVERY GOOD
4RAMGOPAL BARMAN14D23D47B+27C24D21D18D17424.86%DDISQUALIFIED
5SANJU MAITY82A+89A+86A+88A+92AA96AA99AA63290.29%AAOUTSTANDING

CONDITION:-

        GRADE=1:- IF MARKS>=90 THEN GRADED IS AA

                        2:- IF MARKS>=80 THEN GRADED IS A+

                        3:- IF MARKS>=60 THEN GRADED IS A

                        4:- IF MARKS>=45 THEN GRADED IS B+

                        5:- IF MARKS>=35 THEN GRADED IS B

                        6:- IF MARKS>=25 THEN GRADED IS C

                        7:- IF MARKS>BELOW 25 THEN GRADED IS D

ð  PRACTICAL TASK-7

CALCULATIONQUATERLYFIXEDMONTHLYINSTALLMENT
DEPOSITE AMOUNT1000050000 5000
DURATION15121015
RATE6.50%5.50%6%6%
INSTALLMENT500 1250Rs557.98
RETURN AMOUNTRs76,473.05Rs95,060.37Rs205,873.43150000

ð  PRACTICAL TASK-8

TET APPEAR TESTING-2014(FEB-MAR)
EXAM NAMEGRADUATEPOST GRADUATEMARKS(GRADUATE)TET STATUS
WBSSCPASSP/G50%TET APPEAR
WBSSCHONSNILL60%TET APPEAR
WBSSCPASSAPPEAR41%NOT APPEAR
WBSSCPASSNILL36%NOT APPEAR
WBSSCPASSP/G45%TET APPEAR
WBSSCHONSP/G47%TET APPEAR
WBSSCPASSNILL61%TET APPEAR

ð  PRACTICAL TASK-9

PIVOT TABLE
NAMEDESIGNATIONSALARY
S.ROYMANAGER20000
R.SENACCOUNTER18000
K.MAJICASHIER15000
P.SAMANTAWORKER10000
A.SENPEON12000
K.SAMANTAMANAGER20000
P.ROYCASHIER15000
S.KHANWORKER10000
S.SENPEON12000
G.MAJIACCOUNTER18000
PIVOT TABLE RESULT
Sum of SALARYDESIGNATION     
NAMEACCOUNTERCASHIERMANAGERPEONWORKERGrand Total
A.SEN   12000 12000
G.MAJI18000    18000
K.MAJI 15000   15000
K.SAMANTA  20000  20000
P.ROY 15000   15000
P.SAMANTA    1000010000
R.SEN18000    18000
S.KHAN    1000010000
S.ROY  20000  20000
S.SEN   12000 12000
Grand Total3600030000400002400020000150000

ð  PRACTICAL TASK-10

FINANCIAL FUNCTION
LOAN AMOUNTRs100,000.00 
RATE OF INTEREST6% 
DURATION8 
INSTALLMENTRs1,314.14PMT
LOAN PORTIONRs814.14PPMT
INTEREST PORTIONRs500.00IPMT

ð  PRACTICAL TASK-11

A to Z Software Pvt. Ltd. 
     Staff Salary for the month of March 30, 2014     
Staff Salary Sheet         Date: 01/03/2014
IDNamePostBasicHouse Rent AllowanceMedical AllowanceVehicle AllowanceOther AllowanceGross SalaryWorking dayAttendanceHolidayOvertime HoursGross PayableLife InsuranceAdvanceOther DeductionNet PayableSignature of Receiver
1AMITMD60000600030003000120073200302641884180.001200  82980.00 
2ANUPCHAIRMAN50000500025002500100061000302641267100.001000 70065400.00 
3SUMANACCOUNTS450004500225022509005490030154235685.00900  34785.00 
4TAPASCLARK1000010005005002001220030254 11793.332005000 6593.33 
5SAMIRASST. MANAGER400004000200020008004880030264 48800.00800  48000.00 
6PULAKTYPIST1500015007507503001830030234517232.503002357.5 14575.00 
7SANDIPINCHARGE250002500125012505003050030124 16266.67500  15766.67 
8TARUNPION1200012006006002401464030264 14640.00240  14400.00 
9SUBHAHELPER1000010005005002001220030264 12200.00200 50011500.00 
10SAGARSECURITY5000500250250100610030264 6100.00100  6000.00 
Total313997.5054407357.51200300000.00 
TOTAL (IN WORDS): THREE LAKH ONLY.    

ð  PRACTICAL TASK-12

PROFIT SHEET OF A COMPANY
 COST PURPOSECOMPANY NAME 
AABB
VARIABLE COST(VC)Rs. 50.00Rs. 75.00
METIRIAL COST(MC)Rs. 100.00Rs. 150.00
FIXED COST(FC)Rs. 7,000.00Rs. 7,000.00
SELLING PRICE(SP)Rs. 250.00Rs. 275.00
COMPANY RESULT = AA
DATEUNITV.C.M.C.F.C.T.C.S.P.PROFIT
1/1/20140Rs. 0.00Rs. 0.00Rs. 7,000.00Rs. 7,000.00Rs. 0.00-Rs. 7,000.00
2/1/2014200Rs. 10,000.00Rs. 20,000.00Rs. 7,000.00Rs. 37,000.00Rs. 50,000.00Rs. 13,000.00
3/1/2014500Rs. 25,000.00Rs. 50,000.00Rs. 7,000.00Rs. 82,000.00Rs. 125,000.00Rs. 43,000.00
4/1/2014350Rs. 17,500.00Rs. 35,000.00Rs. 7,000.00Rs. 59,500.00Rs. 87,500.00Rs. 28,000.00
5/1/2014700Rs. 35,000.00Rs. 70,000.00Rs. 7,000.00Rs. 112,000.00Rs. 175,000.00Rs. 63,000.00
6/1/2014480Rs. 24,000.00Rs. 48,000.00Rs. 7,000.00Rs. 79,000.00Rs. 120,000.00Rs. 41,000.00
7/1/2014610Rs. 30,500.00Rs. 61,000.00Rs. 7,000.00Rs. 98,500.00Rs. 152,500.00Rs. 54,000.00
TOTAL PROFITRs. 235,000.00

ð  PRACTICAL TASK-13

GOAL SEEK EXAMPLE
EX:=1     
SALESMANSALEAMOUNTBASICCOMMISSIONTATOTAL
A ROY650002000325013006550
 85714.2857120004285.714286171480
EX:= 2     
PURCHASE PRICERs42,027.02Rs57,923.17  
DOWN PAYMENTRs8,405.40Rs14,480.79  
REST AMOUNTRs33,621.61Rs43,442.38  
RATE6%6.50%  
DURATION55  
INSTALLMENTRs650.00Rs850.00   

ð  PRACTICAL TASK-14

SUBTOTALS EXAMPLE
AC NONAMEDATEDEPOSITE
AC1AAM1850
AC1AAM21200
AC1AAM3920
AC1 Total  2970
AC2BBM1700
AC2BBM2580
AC2BBM31200
AC2 Total  2480
AC3CCM1900
AC3CCM2960
AC3CCM31650
AC3 Total  3510
Grand Total  8960

ð  PRACTICAL TASK-15

BANKING SYSTEM
AC NONAMEDATEDEPOSITWITHDRAWLCURRENT BALANCEAC BALANCE
SB/001SAGAR1/4/20145000 50005000
SB/001SAGAR2/4/20142000 20007000
     07000
     07000

ð  PRACTICAL TASK-16

VALIDATION EXAMPLE
NAMECOURSEFEESCATEGORYFEES TO BE PAID
RAJUDSA7000EXCHANGE3500
SYAMDTP4800OTHER4320
NIRMALIMPACT2400EXCHANGE1200
SUDIPDFA4800GENERAL4800
 
DSA7000 GENERALFULL PAID
DFA4800 EXCHANGEHALF PAID
CCA1500 OTHER10% LESS
IMP2400   
IMP+3600   
DITA6000   

ð  PRACTICAL TASK-17

DEPOSITE50000EX:- 1TABLE CALCULATION 
DURATION5 
RATE6%D             E            P             O            S          I           T                E
RETURNRs66,911.28Rs.55,000.00Rs60,000.00Rs75,000.00Rs100,000.00Rs125,000.00
Y
E
A
R
887,661.6495,630.88119,538.61159,384.81199,231.01
1098,496.62107,450.86134,313.58179,084.77223,855.96
12110,670.81120,731.79150,914.74201,219.65251,524.56
15131,810.70143,793.49179,741.86239,655.82299,569.77
18156,988.65171,260.35214,075.44285,433.92356,792.39
  
DEPOSITE50000 
DURATION5EX:- 2 
RATE6% 
RETURNRs66,911.28550006000075000100000125000
R A T E7%Rs55,224.8Rs60,245.2Rs75,306.5Rs100,408.7Rs125,510.9
8%Rs55,257.0Rs60,280.3Rs75,350.4Rs100,467.2Rs125,584.0
9%Rs55,289.2Rs60,315.5Rs75,394.3Rs100,525.8Rs125,657.2
10%Rs55,321.4Rs60,350.6Rs75,438.3Rs100,584.4Rs125,730.5
11%Rs55,353.7Rs60,385.8Rs75,482.3Rs100,643.0Rs125,803.8

ð  PRACTICAL TASK-18

  GRADE SCALEGRADEPERFORMANCE INDICATOR
                                                            VLOOK UP90AAOUTSTANDING
80A+EXCELLENT
60AVERY GOOD
45B+GOOD
35B+SATISFACTORY
25CMARGINAL
24DDISQUALIFIED
RESULT CALCULATION
ROLL NONAMEMARKSGRADEPERFORMANCE INDICATOR
200571BSANDIP90AAOUTSTANDING
200572BSUVENDU45B+GOOD
200573BTAPAS60AVERY GOOD
200574BLAXMI80A+EXCELLENT
200575BDILIP25CMARGINAL

ð  PRACTICAL TASK-19

 HLOOK UP CALCULATION 
ITEM CODE101102103104105
ITEM NAMECOMPUTERMONITORUPSHARD DISKMOUSE
ITEM PRICE25000600025006000200
ITEM STOCK1525302520

ð  PRACTICAL TASK-20

PIE CHART
COLUMN CHART

Leave a Comment

Your email address will not be published. Required fields are marked *

Shopping Cart