dates week/month

1 st
8/6/2025 Wednesday August
2 nd
8/7/2025 Thursday September
3rd 8/8/2025 Friday October
4 th
8/9/2025 Saturday November
Green1
5 th
8/10/2025 Sunday December
6th 8/11/2025 Monday January
7 th
8/12/2025 Tuesday February
8th 8/13/2025 Wednesday March
9 th
8/14/2025 Thursday April

Green 2

Text Functions

Concatenate
1stRon jacobWednesday

Upper 1STRON JACOBWEDNESDAY

Lower 1stron jacobwednesday

Proper 1Stron Jacobwednesday

Left
 Left
1St

Right Mid
wednesday

Len
 Names Year Percentage no. letters in each name
Ron jacob 2025 10% 10
Jose 2026 20% 4
Shree 2027 30% 5
Ijaz 2028 40% 4
Green 2 Ali 2029 50% 3
Sharma 2030 60% 6
Reddy 2031 70% 5
Arthur 2032 80% 6
Rani 2033 90% 4
Taniya 2034 100% 6

sum
average
25 product
5 count
40 min
2 max
mod
 1St 1 1Stron

Mid ron

24
Len

Trim 1Stron Jacobwednesday

Left and find

 10
15
20
25
30
35
40
45
50
55

325
32.5
3.898125E+14
10
10
55
10
Sheet for Mathematical Function

IF function

Roll no.
1
2
3
4
5
6
7
8
9
using count if 10
1

how many got >20 hindi 4 4 4

how many got <15 hindi 1
1
how mant got >20 english 0
how many got <15 english 6

how many got >20 Math #REF!

how many got <15 Math #REF!

how mant got >20 physics 0

how mant got <15 physics 7

how many got >20 chemistry 0

how many got <15 chemistry 1

SRN no.
1
2
3
4
5
6
7
8
9
 10

NAME
RAM
Shyam
Manoj
Pooja
Rahul
Rakesh
Ashish
Manish

vlookup

Ajeet 12000 #N/A

Pooja 10000
Ashok 10000
Ashok Not Achived
Student Name Hindi English Physics Chemistry Total Average
Ram 20 10 18 15 63 15.75
Ashok 21 12 12 18 63 15.75
Manoj 33 15 14 17 79 19.75
Rajesh 15 14 16 20 65 16.25
Ranjana 14 17 13 18 62 15.5
Pooja 16 8 17 15 56 14
Mahesh 18 19 10 14 61 15.25
Ahusthosh 19 20 14 18 71 17.75
Anil 22 13 12 19 66 16.5
Prem 26 12 11 20 69 17.25

9
9 10 1
10
63
79
14

ITEMS QTY RATE amount Grade

AC 20 40000 800000
FRIDGE 30 20000 600000 amnt found throug formula
COOLER 15 10000 150000
WASHING MACHINE 14 15000 210000 10
TV 18 20000 360000
FAN 17 2000 34000 3
COMPUTER 10 25000 250000 6
KEYBOARD 5 250 1250
MOUSE 25 100 2500
PRINTER 30 12000 360000

Department Post Basic DA 2.5% HRA 3.5% PF 1.5% Total

Computer Manager 5000 125 175 75 5225
Computer Supervisor 8000 200 280 120 8360
Computer Pion 3000 75 105 45 3135
Electrical Guard 6000 150 176 90 6236
Electrical Cashier 8000 200 280 120 8360
Electrical Accountant 9000 225 315 135 9405
Finance Manager 10,000 250 177 150 10277
Finance Guard 5000 125 175 75 5225

Salesman Jan Feb Mar Apr May Jun

Ramesh 2000 1500 300 1400 1000 1400
Rakesh 5000 1200 500 1200 1200 2800
Rahul 3000 800 1200 3000 1500 3500
Pooja 1000 900 1800 5000 1400 1200
Manoj 500 1000 2300 8000 1700 1400
Ashok 800 500 2400 1900 1800 1800
Ajeet 1200 1400 1500 700 2500 7000
Alok 1500 1800 1800 1800 300 1500
Amrit 1800 2500 1700 1500 2800 1800
Surendra 200 3000 1900 1200 1500 3000
Shashi 1600 1200 2000 800 1700 800

11

#N/A Ajeet Achived Manoj 12000

Pooja Achived Manoj Not Achived
 Shashi 10000
Shashi Not Achived

#N/A

Shashi Shashi Ashok Pooja

Amrit Pooja

Ashok

Items Date Cost

Brakes 1/1/2016 800
Tyres 12/5/2016 2000 19
Brakes 18/05/2016 500
Service 20/05/2016 800 4
Service 10/2/2016 1000 5
Window 8/5/2016 1000 5
Tyres 10/5/2016 1200
7/8/1905 0
Tyres 25/05/2016 1500
Clutch 10/7/2016 1800
Tyres 10/1/2016 2000 #N/A
Clutch 15/06/2016 1500
Clutch 12/1/2016 1000
Window 1/1/2016 1200
Window 10/5/2016 1500
Window 10/5/2016 1800
Brakes 10/5/2016 1000
Brakes 14//08/2016 1200
Tyres 15/08/2016 1500
Window 20/08/2016 1800

Name Date of Birth Day Month Year

Ramesh 15-05-1980 10 11 40
 Rakesh 20-08-1981
Rahul 15-10-2003
Pooja 25-05-1990
Manoj 24-08-1992
Ashok 23-08-1998
Ajeet 12/5/1980
Alok 18-03-2005
Amrit 15-08-2007
Surendra 25-05-2010
Shashi 25-08-1993

Student Name Subject Result

Name Math English Physics Total Percentage Grade
 Grade
A
A 9
A 1
A
A
B 0 9
A 10
A
A
A

9 count if , how many people have goto "A"

1 count if how much manooj got as average
sumif 15.75 how many people have got b

19.75 0

9
1

amnt found throug formula = select quantity*rate = amount

how many items in list checked through = count formula

how many items gty greater than >20 found through = countif formula
how many items qty less than <20 found through = count if formula
Grade found the grade using IF function
C IF select total and then use >20,000,"A
C
C
C
C 16720
C 24001
B 2
C 2

Sales Target Result use count if to get achived or not achived

7600 10000 NOT ACHIVED
11900 12000 Not Achived
13000 18000 Not Achived
11300 10000 Achived
7601 12000 Not Achived
9200 10000 Not Achived
14300 12000 Achived
8700 10000 Not Achived
7602 12000 Not Achived 3
10800 10000 Achived
8100 10000 Not Achived

Rahul 18000
Rahul Not Achived
 Amrit 12000
Amrit Not Achived

12
4
Employee ID Last Name First Name
110608 Doe John
253072 Cline Andy
352711 Smith John
391006 Pan Peter
392128 Favre Bret
549457 Elway John
580622 Manning Eli
602693 Vick Micheal
611810 Woods Tiger
612235 Jordan Micheal
795574 Stark Tony
830385 Williams Prince
990678 Pitt Brad

Employee ID Full Name SSN Department

EMP001 Faith K Macias 845-04-3962 Marketing
EMP002 callie I.Forbes 345-28-4935 IT/IS
EMP003 Blaze V. Bridges 503-53-8350 Marketing

Employee ID Full Name SSN Department

EMP001 Faith K Macias 845-04-3962 Marketing
EMP002 callie I.Forbes 345-28-4935 IT/IS
EMP003 Blaze V. Bridges 503-53-8350 Marketing
EMP004 Denton Q. Dale 858-39-7967 Marketing
EMP005 Blossom K.Fox 245-18-5890 Engineering
EMP006 Kerry V.David 873-45-8675 Finance
EMP007 Melanie X.Baker 190-08-3679 Finance
EMP008 Adele M.Fulton 352-36-9553 Engineering
EMP009 Justina O.Jensen 645-74-0451 Marketing
EMP010 Yoshi J.England 558-53-1475 Marketing
EMP011 Brooke Y.Mccarty 129-42-6148 IT/IS
EMP012 Kay G.colon 796-50-4767 Marketing
EMP013 Callie I.Forbes 266-48-1339 Human Resource
EMP014 Zachery O.Mann 663-00-3285 Marketing
 classic Favorites
Caffe Latte
Cappuccino
Caramel Macchiato
White Chocolate Mocha
Caffe Americano
Cinnamon Dolce Latte
Steamer
Drip Coffee

ID 101 102 103

Brand Dell Logitech Logitech
Product Computer Keyboard Mouse

ID Product Brand
104 Printer HP
103 Mouse Logitech
104 Printer HP
101 Computer Dell
102 Keyboard Logitech
103 Mouse Logitech
101 Computer Dell
104 Printer HP
101 Computer Dell
102 Keyboard Logitech

Months January February March

Sale 240 180 310

Months April
Sale 445
Name Roger Mat Jim
Science 36 45 52
English 82 71 56
Maths 32 45 52

Marks in English Jim

56

Name Roger Mat Jim

Science 36 45 52
English 82 71 56
Maths 32 45 52

Marks in Maths Mat

45

Emp FIS6067 FIS5228 FIS6799

Sales1 66 43 36
Sales2 51 83 41
Sales3 35 97 92
Sales4 84 76 35
Sales5 110 77 90

EMP FIS1149
Sales 4 48

Temprature 21 33 39
Cities New Delhi Patna Mumbai

Temprature 42
City Pune

Employee Albert Aaron Albama

Sales 200 125 320

Employee Cathy
Sales 421

Product Name Jan Feb Mar

Apples $2,773 $17,462 $5,954
Grapefruit $12,908 $3,083 $24,492
Lemons $6,554 $14,262 $8,377
Lime $28,913 $1,437 $20,019
Oranges 4,768 $7,622 $28,918
Peaches $13,390 $3,611 $6,226
Pears $17,585 $28,508 $9,614
Pineapples $22,579 $16,301 $6,469

Assignement 14-

Season Year Type

Fall 1998 Amber Ale
Fall 1998 Hefeweizen
Fall 1998 Pale Ale
Fall 1998 Pilsner
Fall 1998 Porter
Fall 1998 Stout
Fall 1998 Amber Ale
Fall 1998 Hefeweizen
Fall 1998 Pale Ale
Fall 1998 Pilsner
Fall 1998 Porter
Fall 1998 Stout
Fall 1998 Amber Ale
Fall 1998 Hefeweizen
Fall 1998 Pale Ale
Fall 1998 Pilsner
Fall 1998 Porter
Fall 1998 Stout
Spring 1998 Amber Ale
Spring 1998 Hefeweizen
Spring 1998 Pale Ale
Spring 1998 Pilsner
Spring 1998 Porter
Spring 1998 Stout
Spring 1998 Amber Ale
Spring 1998 Hefeweizen
Spring 1998 Pale Ale
Spring 1998 Pilsner
Spring 1998 Porter
Spring 1998 Stout
Spring 1998 Amber Ale
Spring 1998 Hefeweizen
Spring 1998 Pale Ale
 Spring 1998 Pilsner
Spring 1998 Porter
Spring 1998 Stout

Assignment - 16 Countif,Countifs,Sum

Name Gender
Richard Male
Jennifer Female
James Male
Lisa Female
Sharon Female
Elizabeth Female
Carol Female
Mark Male
John Male
Suzan Female
David Male

Assignement -19 , Use of Formulas- Index with Ma

Region Jan
North 5535
South 5013
East 6597
West 3195

East Mar
West Feb
South Jan
North March

Assignment - 21 , Index + Match

Employee Name Salary Department

Raju 92,671 Sales
Ramesh 84,120 Operations
Ramila 50,793 Marketing
Rajeshwari 77,833 HR
Karan 58,914 Finance
Rohith 51,096 IT
Jacob 83,735 Marketing
Fleming 74,418 IT
 Navya 51,366 Sales
Kavya 54,600 Finance
Santosh 93,509 Operations

Name Physics Chemistry

Nitin Pass Pass
Feroz Pass Pass
Anitha Pass Fail
Madan Pass Pass
Harry Pass Fail
Sumith Fail Pass
Harsh Pass Pass
Trivedi Pass Pass
Ashish Pass Pass

Product Name Unit Sold

A 250
D 110
E 300
B 50
C 45
D 23
F 25
A 90
D 450
C 23
A 250

Average of B 37.5
Average of D

Zone City Sales

South Chennai
East Patna
North Delhi
North Kanpur
West Gandhinagar
East Hubli
South Manglore
North Chandigarh
West Pune
South Hyderabad
North Meerut
West Nagpur

List 1 List 2 Result

Raju Ankita Not Matching
Rohit Rohit Matching
Kajal Abhay Not Matching
Rohan Rohan Matching
Akshay Puneet Not Matching

Use Vlookup one sheet to Another

EMP ID First Name

101 Donald
102 Samuel
103 Ian
104 David
105 Ian
106 Henry
107 Ronica

EMP ID First Name

101 Donald
102
103
104
105
106
107
108
109
110
 Date of Sale Month
19-01-2018 January
16-01-2018 January
22-01-2018 January
12/1/2018 January
5/1/2018 January
2/2/2018 February
13/2/2018 February
15-2-2018 February
15-02-2018 February
9/2/2018 February
22-02-2018 February
26-02-2018 February
26-02-2018 February
26-02-2018 February
27-02-2018 February
28-02-2018 February
28-02-2018 February
28-02-2018 February

Order ID Product
1 Carrots
2 Broccoli
3 Banana
4 Banana
5 Beans
6 Orange
7 Broccoli
8 Banana
9 Apple
10 Apple
11 Banana
12 Broccoli
13 Carrots
14 Broccoli
15 Apple
16 Banana
17 Banana
18 Banana
19 Broccoli
20 Apple
21 Orange
 22 Banana
23 Banana
24 Banana
25 Beans
26 Carrots
27 Mango
28 Beans
29 Beans
30₭ Apple

Category Sum of Amount

Fruit $82,070
Vegetables $62,051
Total Result $144,121

Match and Vlookup with Match

Classic Favorites TALL

Caffe Latte $2.95
Cappuccino $2.95
Caramel Macchiato $3.75
Caffe Mocha $3.25
White Chocolate Mocha $3.45
Caffe Americano $2.00
Cinnamon Dolce Latte $3.95
Steamer $2.25
Drip Coffee $1.75

Classic Favorites result

Caffe Mocha
3.95

Cappuccino

3.95

0
Caffe Mocha 4

Caffe Americano 7
Employee ID Pay First N. Last Name
602693 $84,289 Michea Vick
611810 $1,37,670 Tiger Woods using lookup found first name
549457 $1,90,024 John Elway
612235 $1,22,604 Micheal Jordan
580622 $1,11,709 Eli Manning
830385 $85,931 Prince Williams Brad
253072 $1,68,114 Andy Cline
391006 $89,627 Peter Pan
990678 $1,49,946 Brad Pitt Brad
795574 $1,45,893 Tony Stark
392128 $64,757 Bret Favre

110608 $1,21,444 John Doe

VLOOKUP

Start Date Earnings

27/01/2008 73500
1/3/2008 80000
16/04/2008 95000

Start Date Earnings 14

27/01/2008 $73,500.00 0 0
1/3/2008 $80,000 0
16/04/2008 $95,000 2
3/5/2008 $1,05,000 0
11/7/2008 $90,000
17/07/2008 $60,000
5/10/2008 $87,000
28/10/2008 $1,04,000
5/11/2008 $3,80,050
9/12/2008 $93,000.00
12/2/2009 $1,80,000
19/03/2009 $1,00,000
13/04/2009 $1,36,000
28/04/2009 $68,000
 Tall Grande Venti
$2.95
$2.95
$3.75
$3.25
$3.45
$2.00
$3.95
$2.25
$

h-lookup

104
HP
Printer

Assignment - 25 hlookup

April May June

445 650 700
Cole Ricky Mary Apil #N/A
66 75 40
32 81 66
51 71 74

Cole Ricky Mary

66 75 40
32 81 66
51 71 74

FIS1149 FIS5834
82 89
125 79
41 39
48 37
37 34

42 50
Pune Banglore

Abeey Carol Cathy

250 300 421

Counta and Vlookup

Apr May Jun July Aug Total Sale

$1,348 $28,158 $28,799 $25,415 $17,227 $127,136
$5,825 $1,080 $2,188 $11,087 $15,544 $76,207
 $24,982 $12,184 $6,430 $21,159 $18,597 $112,545
$13,026 $26,952 $27,076 $7,040 $10,884 $135,347
$27,141 $3,578 $10,092 $15,207 $12,771 $110,097
$27,567 $29,962 $2,967 $5,740 $2,137 $91,600
$17,110 $12,143 $7,365 $24,185 $1,643 $118,153
$22,050 $8,740 $18,806 $3,334 $3,597 $101,876

countif,countifs,sumifs

State Sales
California $554,536
California $540,643
California $577,548 18 how many fall
California $455,905 18 18 how many Spring
California $490,871 18 6 how many Fall season i
California $446,383 6 6 how many Fall season i
Oregon $457,726 6 6 how many spring seaso
Oregon $347,696 6 2891339 total sales if spring seas
Oregon $384,541 2895913 Total sales if Spring Sea
Oregon $386,420 2378107 Total sales if Fall Season
Oregon $370,970 2749625 total sales if spring seas
Oregon $430,754 6 how many spring Seaso
Washington $500,847
Washington $507,070
Washington $482,346
Washington $608,713
Washington $150,000
Washington $500,649
California $545,780
California $440,644
California $580,359
California $536,225
California $414,908
California $377,997
Oregon $331,289
Oregon $384,572
Oregon $365,813
Oregon $396,338
Oregon $453,761
Oregon $356,538
Washington $606,332
Washington $535,218
Washington $493,364
 Washington $559,100
Washington $220,350
Washington $476,975

Assignment - 16 Countif,Countifs,Sumifs and Vlookup

Country Score
United States 74
United Kingdom 92
United States 65
Canada 82
Australia 50
Canada 91
United States 96
United States 58
Canada 67
United Kingdom 54
United States 83

ment -19 , Use of Formulas- Index with Match

Feb March
5414 9027
5107 11667
3858 1507
3654 7225

1507 3654
3654
5013 5013
9027

ent - 21 , Index + Match

EMP ID EMP ID Salary

Prd001 Prd001 92671
Prd002 Prd002 84120
Prd003 Prd003 50793
Prd004 Prd004 77833 find salary using Index+
Prd005 Prd005 58914
Prd006 Prd006 51096
Prd007 Prd007 83735
Prd008 Prd008 74418
 Prd009 Prd009 51366
Prd001 Prd001 92671
Prd001 Prd001 92671

Assignment - 23, AND formula

Maths Biology Passed the Exam

Fail Pass FALSE
Pass Pass true
Pass Pass
Pass Pass
Pass Pass
Pass Pass
Pass Fail
Fail Pass
Pass Pass

Assignement - 24 Averageif

Student Semester Score

John Second 90
Gary Third 77
Richa Second 80
Hari Second 65
Tom Third 45
Will Third 55

Second 78.333
Third

Product Name Units Sold

A 250
D 110
E 300
B 50
C 45
D 23
F 25
 A 90
D 450
C 23
A 250

Assignment - 26 compare List 1 to List 2

List 1 List 2 Result

343749 160466 160466
183257 183257 Value not in List 1
160466 249447 249447
249447 343749 343749
532765 35616 Value not in list

Assignment - 29
Use Vlookup one sheet to Another

Last Name Department Location

Patrick Finance Banglore
Samson Marketing Hyderabad
Jacob Finance Hyderabad Sheet 1
Jhonson Marketing Pune
Smith Marketing Banglore
Madrid IT Pune
Brave Finance Hyderabad

Last Name Department Location

Patrick Finance Banglore Sheet 2

Assignment - 30
Get Pivot Table
 Sales Amnt
2,01,440
3,52,519
1,72,406
2,40,000
15205
24,327
50,549
50,549
15,106
19,901
15,205
3,00,000
1,50,000
3,30,000
1,50,000
3,30,000
1,63,282
5,64,030

Assignment -15
Create Pivot Table Using Data Separate Fruit and Vegitables

Category Amount Date Country

Vegetables $4,270 6/1/2016 US How many fruits and vegitable item
Vegetables $8,239 7/1/2016 UK
Fruit $617 8/1/2016 US
Fruit $8,384 9/1/2016 CANADA Total Apple and Banana Amount
Vegetables $2,626 10/1/2016 GERMANY
Fruit $3,610 11/1/2016 US
Vegetables $9,062 12/1/2016 AUSTRALIA How many product in a list
Fruit $6,906 1/1/2017 NEW ZEALAND
Fruit $2,417 2/1/2017 FRANCE how many Apple and Banana use i
Fruit $7,431 3/1/2017 CANADA
Fruit $8,250 4/1/2017 GERMANY
Vegetables $7,012 5/1/2017 US
Vegetables $1,903 6/1/2017 GERMANY
Vegetables $2,824 7/1/2017 CANADA Apple and Banana sales in US
Fruit $6,946 8/1/2017 FRANCE
Fruit $2,320 9/1/2017 UK
Fruit $2,116 10/1/2017 US
Fruit $1,004 11/1/2017 UK
Vegetables $3,642 12/1/2017 UK
Fruit $4,582 1/1/2018 US
Fruit $3,559 2/1/2018 FRANCE
 Fruit $5,154 3/1/2018 NEW ZEALAND
Fruit $7,388 4/1/2018 CANADA
Fruit $7,163 5/1/2018 US
Vegetables $5,101 6/1/2018 UK
Vegetables $7,602 7/1/2018 AUSTRALIA
Fruit $1,903 8/1/2018 FRANCE
Vegetables $2,824 9/1/2018 US
Vegetables $6,946 10/1/2018 GERMANY
Fruit $2,320 11/1/2018 FRANCE

Assignment - 11

nd Vlookup with Match MATCH FORMULA

GRANDE VENTI question What is the column no. for the size GRANDE,
$3.75 $4.15
$3.65 $4.15 Grande $3.00
$3.95 $4.25 VENTI
$3.95 $4.40 TALL
$4.15 $4.55
$2.40 $2.75 Question What is the price of a Caffe Mocha, size Gra
$4.75 $5.15
$2.50 $2.75 Caffe Mocha GRANDE
$1.95 $2.05 Caffe Mocha TALL
Caffe Mocha VETI

Index

ROWNO COLNO
6 2 3.45

6 2 3.45 method 1
2.95
5 3 3.95

4.25 method 2
1.75
lookup found first name and last name

Prince Williams
Andy Cline
Peter Pan
Brad Pitt
Tony Stark
Bret

=Look
how many fall COUNTIF
how many Spring COUNTIF
how many Fall season in Californ COUNTIFS
how many Fall season in Washington COUNTIFS
how many spring season in Oregon COUNTIFS
total sales if spring season in washington SUMIFS
Total sales if Spring Season in California SUMIFS
Total sales if Fall Season in Oregon
total sales if spring season in washington
how many spring Season in Washington only
find salary using Index+Match
y fruits and vegitable items in a list 18 fruit
12 vegitable

le and Banana Amount 23696 Apple

49302 Banana

y product in a list 30

y Apple and Banana use in Canada & UK 0 apple UK

2 Banana UK
1 Apple Canada
2 Banana Canada

d Banana sales in US 4582 apple

9896 Banana
no. for the size GRANDE, TALL, VENTI ?

Use Vlookup with Match formula

f a Caffe Mocha, size Grande, Tall, Venti ?

$3.95
 Assignment -15
Create Pivot Table Using Data Separate Fruit and Veg

Order ID Product Category Amount Date

1 Carrots Vegetables $4,270 6/1/2016
2 Broccoli Vegetables $8,239 7/1/2016
3 Banana Fruit $617 8/1/2016
4 Banana Fruit $8,384 9/1/2016
5 Beans Vegetables $2,626 10/1/2016
6 Orange Fruit $3,610 11/1/2016
7 Broccoli Vegetables $9,062 12/1/2016
8 Banana Fruit $6,906 1/1/2017
9 Apple Fruit $2,417 2/1/2017
10 Apple Fruit $7,431 3/1/2017
11 Banana Fruit $8,250 4/1/2017
12 Broccoli Vegetables $7,012 5/1/2017
13 Carrots Vegetables $1,903 6/1/2017
14 Broccoli Vegetables $2,824 7/1/2017
15 Apple Fruit $6,946 8/1/2017
16 Banana Fruit $2,320 9/1/2017
17 Banana Fruit $2,116 10/1/2017
18 Banana Fruit $1,004 11/1/2017
19 Broccoli Vegetables $3,642 12/1/2017
20 Apple Fruit $4,582 1/1/2018
21 Orange Fruit $3,559 2/1/2018
22 Banana Fruit $5,154 3/1/2018
23 Banana Fruit $7,388 4/1/2018
24 Banana Fruit $7,163 5/1/2018
25 Beans Vegetables $5,101 6/1/2018
26 Carrots Vegetables $7,602 7/1/2018
27 Mango Fruit $1,903 8/1/2018
28 Beans Vegetables $2,824 9/1/2018
29 Beans Vegetables $6,946 10/1/2018
30 Apple Fruit $2,320 11/1/2018
a Separate Fruit and Veg

Country Order ID Product Category Amount

US 1 Carrots Vegetables 4270
UK 2 Broccoli Vegetables 8239
US 3 Banana Fruit 617
CANADA
GERMANY 5 Beans Vegetables 2626
US 6 Orange Fruit 3610
AUSTRALIA 7 Broccoli Vegetables 9062
NEW ZEALAND 8 Banana Fruit 6906
FRANCE 9 Apple Fruit 2417
CANADA 10 Apple Fruit 7431
GERMANY 11 Banana Fruit 8250
US 12 Broccoli Vegetables 7012
GERMANY
CANADA
This chart isn't available in your version of Excel.
FRANCE
UK Editing this shape or saving this workbook into a different file format will
US permanently break the chart.
UK
UK
US
FRANCE
NEW ZEALAND
CANADA
US
UK
AUSTRALIA
FRANCE
US
GERMANY
FRANCE
ormat will
Employee ID Last Name First Name Column1
110608 Doe John 1
253072 Cline Andy Andy
352711 Smith John John
391006 Pan Peter Peter
392128 Favre Bret BretDepartment
549457 Elway John JohnMarketing
580622 Manning Eli Eli
602693 Vick Micheal Micheal
611810 Woods Tiger Tiger
612235 Jordan Micheal MichealDepartment
795574 Stark Tony TonyMarketing
830385 Williams Prince PrinceIT/IS
990678 Pitt Brad BradMarketing
Total 13
0 "@cloud.com"

Employee ID Full Name SSN Department

EMP001 Faith K Macias 845-04-3962 Marketing
EMP002 callie I.Forbes 345-28-4935
EMP003 Blaze V. Bridges 503-53-8350

Employee ID Full Name SSN Department

EMP001 Faith K Macias 845-04-3962 Marketing
EMP002 callie I.Forbes 345-28-4935 IT/IS
EMP003 Blaze V. Bridges 503-53-8350 Marketing
EMP004 Denton Q. Dale 858-39-7967 Marketing
EMP005 Blossom K.Fox 245-18-5890 Engineering
EMP006 Kerry V.David 873-45-8675 Finance
EMP007 Melanie X.Baker 190-08-3679 Finance
EMP008 Adele M.Fulton 352-36-9553 Engineering
EMP009 Justina O.Jensen 645-74-0451 Marketing
EMP010 Yoshi J.England 558-53-1475 Marketing
EMP011 Brooke Y.Mccarty 129-42-6148 IT/IS
EMP012 Kay G.colon 796-50-4767 Marketing
EMP013 Callie I.Forbes 266-48-1339 Human Resource
EMP014 Zachery O.Mann 663-00-3285 Marketing
Months January February March
Sale 240 180 310

Months April
Sale 445

Name Roger Mat Jim

Science 36 45 52
English 82 71 56
Maths 32 45 52

Marks in English Jim

56

Name Roger Mat Jim

Science 36 45 52
English 82 71 56
Maths 32 45 52

Marks in Maths Mat

45

Emp FIS6067 FIS5228 FIS6799

Sales1 66 43 36
Sales2 51 83 41
Sales3 35 97 92
Sales4 84 76 35
Sales5 110 77 90

EMP FIS1149
Sales 4 48

Temprature 21 33 39
Cities New Delhi Patna Mumbai

Temprature 42
City

Employee Albert Aaron Albama

Sales 200 125 320
Employee Cathy
Sales

Season Year Type

Fall 1998 Amber Ale
Fall 1998 Hefeweizen
Fall 1998 Pale Ale
Fall 1998 Pilsner
Fall 1998 Porter
Fall 1998 Stout
Fall 1998 Amber Ale
Fall 1998 Hefeweizen
Fall 1998 Pale Ale
Fall 1998 Pilsner
Fall 1998 Porter
Fall 1998 Stout
Fall 1998 Amber Ale
Fall 1998 Hefeweizen
Fall 1998 Pale Ale
Fall 1998 Pilsner
Fall 1998 Porter
Fall 1998 Stout
Spring 1998 Amber Ale
Spring 1998 Hefeweizen
Spring 1998 Pale Ale
Spring 1998 Pilsner
Spring 1998 Porter
Spring 1998 Stout
Spring 1998 Amber Ale
Spring 1998 Hefeweizen
Spring 1998 Pale Ale
Spring 1998 Pilsner
Spring 1998 Porter
Spring 1998 Stout
Spring 1998 Amber Ale
Spring 1998 Hefeweizen
Spring 1998 Pale Ale
Spring 1998 Pilsner
Spring 1998 Porter
Spring 1998 Stout
 Type State Sales
Amber Ale California $554,536
Hefeweizen California $540,643
Pale Ale California $577,548
Pilsner California $455,905
Porter California $490,871
Stout California $446,383
Amber Ale Oregon $457,726
Hefeweizen Oregon $347,696
Pale Ale Oregon $384,541
Pilsner Oregon $386,420
Porter Oregon $370,970
Stout Oregon $430,754
Amber Ale Washington $500,847
Hefeweizen Washington $507,070
Pale Ale Washington $482,346
Pilsner Washington $608,713
Porter Washington $150,000
Stout Washington $500,649
Amber Ale California $545,780
Hefeweizen California $440,644
Pale Ale California $580,359
Pilsner California $536,225
Porter California $414,908
Stout California $377,997
Amber Ale Oregon $331,289
Hefeweizen Oregon $384,572
Pale Ale Oregon $365,813
Pilsner Oregon $396,338
Porter Oregon $453,761
Stout Oregon $356,538
Amber Ale Washington $606,332
Hefeweizen Washington $535,218
Pale Ale Washington $493,364
Pilsner Washington $559,100
Porter Washington $220,350
Stout Washington $476,975

Order ID Product Category

14 Broccoli Vegetables
15 Apple Fruit
16 Banana Fruit
17 Banana Fruit
18 Banana Fruit
19 Broccoli Vegetables
20 Apple Fruit
21 Orange Fruit
22 Banana Fruit
23 Banana Fruit
24 Banana Fruit
25 Beans Vegetables
26 Carrots Vegetables
Roll no. Student Name Hindi English Physics
1 Ram 20 10 18
2 Ashok 21 12 12
3 Manoj 33 15 14
4 Rajesh 15 14 16
5 Ranjana 14 17 13
6 Pooja 16 8 17
7 Mahesh 18 19 10
8 Ahusthosh 19 20 14
9 Anil 22 13 12
10 Prem 26 12 11

Product Category
Apple Fruit
Apple Fruit
Apple Total
Banana Fruit
Banana Fruit
Banana Fruit
Banana Fruit
Banana Fruit
Banana Fruit
Banana Total
Beans Vegetables
Beans Total
Broccoli Vegetables
Broccoli Vegetables
Broccoli Total
Carrots Vegetables
Carrots Total
Orange Fruit
Orange Total
Grand Total
 lookup( lookup_value, array )
Employee ID Pay first name Last Name
602693 $84,289 Micheal Vick Tiger
611810 $1,37,670 Tiger Woods Peter
549457 $1,90,024 John Elway Peter
612235 $1,22,604 Micheal Jordan
580622 $1,11,709 Eli Manning
830385 $85,931 Prince Williams
253072 $1,68,114 Andy Cline
391006 $89,627
990678 $1,49,946
795574 $1,45,893
392128 $64,757

110608 $1,21,444
Total 7

Order ID Product Category Amount Vlookup lookup_Value, Table array, col_index_nu

14 Broccoli Vegetables $2,824
15 Apple Fruit $6,946
Start Date 16 Banana Fruit $2,320
27/01/2008 17 Banana Fruit $2,116
18 Banana Fruit $1,004
19 Broccoli Vegetables $3,642
20 Apple Fruit $4,582
Start Date 21 Orange Fruit $3,559
27/01/2008 22 Banana Fruit $5,154
1/3/2008 23 Banana Fruit $7,388
16/04/2008 24 Banana Fruit $7,163
3/5/2008 25 Beans Vegetables $5,101
11/7/2008 26 Carrots Vegetables $7,602
17/07/2008 $60,000
5/10/2008 $87,000
28/10/2008 $1,04,000
5/11/2008 $3,80,050
9/12/2008 $93,000.00
12/2/2009 $1,80,000
19/03/2009 $1,00,000
13/04/2009 $1,36,000
28/04/2009 $68,000

Hlookup Assignment 25
 (lookup_value, Table array, row_index(range lookup
April May June
445 650 700

Cole Ricky Mary

66 75 40
32 81 66
51 71 74

Cole Ricky Mary

66 75 40
32 81 66
51 71 74

FIS1149 FIS5834
82 89
125 79
41 39
48 37
37 34

42 50
Pune Banglore

Abeey Carol Cathy

250 300 421
 Assignementcountif,countifs,sumifs

State Sales
California $554,536
California $540,643 Q1 how many spring and fall season ?
California $577,548
California $455,905 Ans: 18
California $490,871 Ans: 18
California $446,383
Oregon $457,726 Q2 how many fall season in California and Washington ?
Oregon $347,696
Oregon $384,541 Ans: 6
Oregon $386,420
Oregon $370,970 Ans 6
Oregon $430,754
Washington $500,847 Q3 Total sales if spring season in washington and california ?
Washington $507,070
Washington $482,346 Ans: 2891339
Washington $608,713
Washington $150,000 Ans: 2895913
Washington $500,649
California $545,780 Q4 How many spring season in washington only ?
California $440,644
California $580,359 Ans 6
California $536,225
California $414,908 Q5 Create pivt table using Data?
California $377,997
Oregon $331,289 Ans Season
Oregon $384,572 Fall
Oregon $365,813
Oregon $396,338
Oregon $453,761
Oregon $356,538
Washington $606,332
Washington $535,218
Washington $493,364
Washington $559,100
Washington $220,350
Washington $476,975
Spring

Total Result
Amount
$2,824 Order ID Product Category Amount
$6,946 1 Carrots Vegetables 3270
$2,320 2 Broccoli Vegetables 8239
$2,116 3 Banana Fruit 617
$1,004 4 Banana Fruit 8384
$3,642 5 Beans Vegetables 2626
$4,582 6 Orange Fruit 3610
$3,559 7 Broccoli Vegetables 9062
$5,154 8 Banana Fruit 6906
$7,388 9 Apple Fruit 2417
$7,163 10 Apple Fruit 7431
$5,101 11 Banana Fruit 8250
$7,602 12 Broccoli Vegetables 7012
 Product Category Amount
Carrots Vegetables 3270
Broccoli Vegetables 3270
Banana Fruit 617
Orange Fruit 617
Broccoli Vegetables 2626
Orange Fruit 3610
Broccoli Vegetables 9062
#N/A #N/A

Chemistry Total Average Grade

15 63 15.75 A
18 63 15.75 A
17 79 19.75 A
20 65 16.25 A
18 62 15.5 A
15 56 14 B
14 61 15.25 A
18 71 17.75 A
19 66 16.5 A
20 69 17.25 A

Amount
$6,946
$4,582
$11,528
$2,320
$2,116
$1,004
$5,154
$7,388
$7,163
$25,145
$5,101 Category Amount
$5,101
$2,824 Fruit 617
$3,642 Fruit 8384
$6,466
$7,602 Fruit 3610
$7,602
$3,559 Fruit 6906
$3,559
$59,401
Fruit 2417
Fruit 7431
Fruit 8250
Fruit 617
Fruit 8384
Fruit 3610
Fruit 6906
Fruit 2417
Fruit 7431
Fruit 8250
Fruit 617
Fruit 8384
Fruit 3610
Fruit 6906
Fruit 2417
Fruit 7431
Fruit 8250
Vegetables 3270
Vegetables 8239
Vegetables 2626
Vegetables 9062
Vegetables 7012
Vegetables 3270
Vegetables 8239
Vegetables 2626
Vegetables 9062
Vegetables 7012
Vegetables 3270
Vegetables 8239
Vegetables 2626
Vegetables 9062
Vegetables 7012
, array ) Assignment 9

alue, Table array, col_index_num,(rangelookup ) Assignment - 10

Assignment 25
array, row_index(range lookup )
ountifs,sumifs

countif formula

Fall
spring

a and Washington ? countifs formula

fall season in California

shington and california ? Sumifs formula

sales during spring season in washington

sales during spring season in California

hington only ?

Type State Sum of Year

35964
Amber Ale 5994
California 1998
Oregon 1998
Washington 1998
Hefeweizen 5994
California 1998
Oregon 1998
Washington 1998
Pale Ale 5994
California 1998
 Oregon 1998
Washington 1998
Pilsner 5994
California 1998
Oregon 1998
Washington 1998
Porter 5994
California 1998
Oregon 1998
Washington 1998
Stout 5994
California 1998
Oregon 1998
Washington 1998
35964
Amber Ale 5994
California 1998
Oregon 1998
Washington 1998
Hefeweizen 5994
California 1998
Oregon 1998
Washington 1998
Pale Ale 5994
California 1998
Oregon 1998
Washington 1998
Pilsner 5994
California 1998
Oregon 1998
Washington 1998
Porter 5994
California 1998
Oregon 1998
Washington 1998
Stout 5994
California 1998
Oregon 1998
Washington 1998
Total Result 71928
 Product Category Amount
Apple Fruit 617

Product Category Amount Product Category Amount

Carrots Vegetables Broccoli Vegetables 3270
Broccoli Vegetables Banana
Banana
Banana
Beans
Orange
Broccoli
Banana
 Apple
Apple
Banana
Broccoli
Product Category Amount
Carrots Vegetables 3270
Broccoli Vegetables 3270
Banana Fruit 617
Banana Fruit 617
Beans Vegetables 2626
Orange Fruit 3610
Broccoli Vegetables 9062
Banana Fruit 6906
Apple Fruit 6906
Apple Fruit 2417
Banana Fruit 7431
Broccoli

Order ID Product Category

1 Carrots Vegetables
2 Broccoli Vegetables
3 Banana Fruit Product Category Amount
4 Banana Fruit Carrots #N/A #N/A
6 Orange Fruit Broccoli #N/A #N/A
7 Broccoli Vegetables Banana #N/A #N/A
5 Banana #N/A #N/A
Beans #N/A #N/A
Orange #N/A #N/A
Broccoli #N/A #N/A
Banana #N/A #N/A
Apple #N/A #N/A
Apple #N/A #N/A

Banana #N/A #N/A

Product Category Amount
Broccoli Vegetables 3270
Banana Fruit 617
Banana Fruit 617
Broccoli Vegetables 2626
Broccoli Vegetables 2626
Beans Vegetables 2626
#N/A #N/A
#N/A #N/A
#N/A #N/A
#N/A #N/A
#N/A #N/A
#N/A #N/A
#N/A #N/A
 Type State Sales
Pilsner California $455,905
Pilsner Oregon $386,420
Pale Ale California $577,548
Amber Ale California $554,536
Hefeweizen California $540,643
Amber Ale Washington $500,847
Porter California $490,871
Amber Ale Oregon $457,726
Stout California $446,383
Stout Oregon $430,754
Pale Ale Oregon $384,541
Porter Oregon $370,970
Hefeweizen Oregon $347,696
$5,944,840
$849,263
#VALUE!
$13

Order ID
3
9
5
6
1
Product Category 8
Banana Fruit 10
2
11
4
7

Order ID Product Category Amount Date

1 Banana Fruit $2,116 10/1/2017
2 Banana Fruit $1,004 11/1/2017
6 Banana Fruit $5,154 3/1/2018
7 Banana Fruit $7,388 4/1/2018
8 Banana Fruit $7,163 5/1/2018
 >2000
Category Amount
Fruit >=2000
Order ID Product Category Amount Date Country
1 Banana Fruit $2,116 10/1/2017 US
4 Apple Fruit $4,582 1/1/2018 US
5 Orange Fruit $3,559 2/1/2018 FRANCE
6 Banana Fruit $5,154 3/1/2018 NEW ZEALAND
7 Banana Fruit $7,388 4/1/2018 CANADA
8 Banana Fruit $7,163 5/1/2018 US
14 Apple Fruit $2,320 11/1/2018 FRANCE

Product Amount
Beans >=2000
Order ID Product Category Amount Date Country
12 Beans Vegetables $2,824 9/1/2018 US
9 Beans Vegetables $5,101 6/1/2018 UK
13 Beans Vegetables $6,946 10/1/2018 GERMANY

slno name
 $457,726

Order ID Product Category Amount Date Country

Product Category Amount 1 Banana Fruit $2,116 10/1/2017 US
Banana Fruit $617 2 Banana Fruit $1,004 11/1/2017 UK
Apple Fruit $2,417 3 Broccoli Vegetables $3,642 12/1/2017 UK
Beans Vegetables $2,626 4 Apple Fruit $4,582 1/1/2018 US
Orange Fruit $3,610 5 Orange Fruit $3,559 2/1/2018 FRANCE
Carrots Vegetables $4,270 6 Banana Fruit $5,154 3/1/2018 NEW ZEALAND
Banana Fruit $6,906 7 Banana Fruit $7,388 4/1/2018 CANADA
Apple Fruit $7,431 8 Banana Fruit $7,163 5/1/2018 US
Broccoli Vegetables $8,239 9 Beans Vegetables $5,101 6/1/2018 UK
Banana Fruit $8,250 10 Carrots Vegetables $7,602 7/1/2018 AUSTRALIA
Banana Fruit $8,384 11 Mango Fruit $1,903 8/1/2018 FRANCE
Broccoli Vegetables $9,062 12 Beans Vegetables $2,824 9/1/2018 US
13 Beans Vegetables $6,946 10/1/2018 GERMANY
14 Apple Fruit $2,320 11/1/2018 FRANCE

Country
US
UK
NEW ZEALAND
CANADA
US
 Category Amount
Fruit $4,582
Order ID Product Category Amount Date Country
1 Banana Fruit $2,116 10/1/2017 US
2 Banana Fruit $1,004 11/1/2017 UK
3 Broccoli Vegetables $3,642 12/1/2017 UK
4 Apple Fruit $4,582 1/1/2018 US
5 Orange Fruit $3,559 2/1/2018 FRANCE
NEW ZEALAND 6 Banana Fruit $5,154 3/1/2018 NEW ZEALAND
7 Banana Fruit $7,388 4/1/2018 CANADA
8 Banana Fruit $7,163 5/1/2018 US
9 Beans Vegetables $5,101 6/1/2018 UK
10 Carrots Vegetables $7,602 7/1/2018 AUSTRALIA
11 Mango Fruit $1,903 8/1/2018 FRANCE
12 Beans Vegetables $2,824 9/1/2018 US
13 Beans Vegetables $6,946 10/1/2018 GERMANY
14 Apple Fruit $2,320 11/1/2018 FRANCE

amount date
 Banana

Product
Banana banana Full Name full full Name full
Apple apple Faith K Macias faith k faith Macias faith
NEW ZEALAND Beans beans callie I.Forbes callie i callie Forbes callie
Orange orange Blaze V. Bridges blaze v blaze Bridges blaze
Carrots carrots Denton Q. Dale denton q denton Dale denton
Banana banana Blossom K.Fox blossom k blossom Fox blossom
AUSTRALIA Apple apple Kerry V.David kerry v kerry David kerry
Broccoli broccoli Melanie X.Baker melanie x melanie Baker melanie
Banana banana Adele M.Fulton adele m adele Fulton adele
GERMANY Banana banana Justina O.Jensen justina o justina Jensen justina
Broccoli broccoli Yoshi J.England yoshi j yoshi England yoshi
Brooke Y.Mccarty brooke y brooke Mccarty brooke
Kay G.colon kay g kay colon kay
Callie I.Forbes callie i callie Mann callie
Zachery O.Mann zachery o zachery Name zachery
Macias

Product
Banana
 Broccoli
Apple
Orange
Beans
Carrots
Mango

NEW ZEALAND

AUSTRALIA

GERMANY
faith
\
 400 Grade A
2050
519
528
537 501
546
555

dd

ghghs
Sl.no Product MRP Sale
1 book 200
2 pen 200
3 scale 205
4 rubber 105
5 sharper 1005
6 ink 800
Name Mark
joel 2
adil 3
sam 4
karthik 5

Roll no. Student Name Hindi English Physics Chemistry Total

1 Ram 20 10 18 15 63
2 Ashok 21 12 12 18 63
3 Manoj 33 15 14 17 79
4 Rajesh 15 14 16 20 65
5 Ranjana 14 17 13 18 62
6 Pooja 16 8 17 15 56
7 Mahesh 18 19 10 14 61
8 Ahusthosh 19 20 14 18 71
9 Anil 22 13 12 19 66
10 Prem 26 12 11 20 69
1 Ram 20 10 18 15 63
2 Ashok 21 12 12 18 63
3 Manoj 33 15 14 17 79
4 Rajesh 15 14 16 20 65
5 Ranjana 14 17 13 18 62
6 Pooja 16 8 17 15 56
7 Mahesh 18 19 10 14 61
8 Ahusthosh 19 20 14 18 71
9 Anil 22 13 12 19 66
10 Prem 26 12 11 20 69
Ram 20 10 18 15 63
Ashok 21 12 12 18 63
Manoj 33 15 14 17 79
Rajesh 15 14 16 20 65
Ranjana 14 17 13 18 62
Pooja 16 8 17 15 56
Mahesh 18 19 10 14 61
Ahusthosh 19 20 14 18 71
Anil 22 13 12 19 66
Prem 26 12 11 20 69
Student Name Hindi English Physics Chemistry Total
Ahusthosh 19 20 14 18 71
Ahusthosh 19 20 14 18 71
Ahusthosh 19 20 14 18 71
Ahusthosh Total 57 60 42 54
Anil 22 13 12 19 66
Anil 22 13 12 19 66
Anil 22 13 12 19 66
Anil Total 66 39 36 57
Ashok 21 12 12 18 63
Ashok 21 12 12 18 63
Ashok 21 12 12 18 63
Ashok Total 63 36 36 54
Mahesh 18 19 10 14 61
Mahesh 18 19 10 14 61
Mahesh 18 19 10 14 61
Mahesh Total 54 57 30 42
Manoj Total 99 45 42 51
Pooja Total 48 24 51 45
Prem Total 78 36 33 60
Rajesh Total 45 42 48 60
Ram Total 60 30 54 45
Ranjana Total 42 51 39 54
Grand Total 612 420 411 522
Ranjana Total 186
Grand Total 1965

0 1 2 3 4 5
1
2
3
4
5
 राम 20 10 18 15 अशोक 21 1

4 Rajesh 15 14 16
5 Ranjana 14 17 13
6 Pooja 16 8 17
7 Mahesh 18 19 10
8 Ahusthosh 19 20 14
9 Anil 22 13 12
10 Prem 26 12 11
1 Ram 20 10 18
2 Ashok 21 12 12
3 Manoj 33 15 14
4 Rajesh 15 14 16
5 Ranjana 14 17 13
6 Pooja 16 8 17
7 Mahesh 18 19 10

1 Student N Hindi English Physics Chemistry

Ahusthosh 19 20 14 18
 4 Rajesh 15 14 16 20
5 Ranjana 14 17 13 18
6 Pooja 16 8 17 15
7 Mahesh 18 19 10 14
8 Ahusthosh 19 20 14 18
9 Anil 22 13 12 19
10 Prem 26 12 11 20

1 Ram 20 10
2 Ashok 21 12
3 Manoj 33 15
4 Rajesh 15 14
5 Ranjana 14 17
6 Pooja 16 8
7 Mahesh 18 19
 Name Mark
joel 4
adil 6
sam 8
karthik 10

Average
15.75
15.75
19.75 Ram 20
16.25 10
15.5 12
14 15
15.25 14
17.75 17
16.5 8
17.25 ce
15.75 96
15.75
19.75
16.25
15.5
14
15.25
17.75
16.5
17.25
15.75
15.75
19.75
16.25
15.5
14
15.25
17.75
16.5
17.25
Average
17.75
17.75
17.75
53.25
16.5
16.5
16.5
49.5
15.75
15.75
15.75
47.25
15.25
15.25
15.25
45.75
59.25
42
51.75
48.75
47.25
46.5
491.25
राम 20 10 18 15 अशोक 21 12 12 18 मनोज 33 15 14 17 राजेश 15 14 16 20 रंजना 14 17 13 18 पूजा 16 8 17 15 महे

20
18
15
14
18
19
20
15
18
17
20
18
15
14

Total Average
71 17.75
 0 1 2 3 4 5
1 1 2 3 4 5
2 2 4 6 8 10
3 3 6 9 12 15
4 4 8 12 16 20
5 5 10 15 20 25

Mahesh 18 19 10 14 61
Mahesh 18 19 10 14 61
18 15 Mahesh Total 36 38 20 28
12 18 Manoj 33 15 14 17 79
14 17 Manoj 33 15 14 17 79
16 20 Manoj 33 15 14 17 79
13 18 Manoj Total 99 45 42 51
17 15 Pooja 16 8 17 15 56
10 14 Pooja 16 8 17 15 56
Pooja 16 8 17 15 56
Pooja Total 48 24 51 45
Prem 26 12 11 20 69
Prem 26 12 11 20 69
Prem 26 12 11 20 69
Prem Total 78 36 33 60
Rajesh 15 14 16 20 65
Rajesh 15 14 16 20 65
Rajesh 15 14 16 20 65
Rajesh Total 45 42 48 60
Ram 20 10 18 15 63
Ram 20 10 18 15 63
Ram 20 10 18 15 63
Ram Total 60 30 54 45
Ranjana 14 17 13 18 62
Ranjana 14 17 13 18 62
Ranjana 14 17 13 18 62
Ranjana Total 42 51 39 54
18 पूजा 16 8 17 15 महेश 18 19 10 14 अहुस्थोश 19 20 14 18 अनिल 22 13 12 19 प्रेम 26 12 11 20 राम 20 10 18
15.25
15.25
30.5
19.75
19.75
19.75
59.25
14
14
14
42
17.25
17.25
17.25
51.75
16.25
16.25
16.25
48.75
15.75
15.75
15.75
47.25
15.5
15.5
15.5
46.5
6 12 11 20 राम 20 10 18 15 अशोक 21 12 12 18 मनोज 33 15 14 17 राजेश 15 14 16 20 रंजना 14 17 13 18 पूजा 16
जना 14 17 13 18 पूजा 16 8 17 15 महेश 18 19 10 14 अहुस्थोश 19 20 14 18
Name Mark
joel 2
adil 3 Student N Hindi
sam 4 Ahusthosh 19
karthik 5 Ahusthosh 19
Ahusthosh 19
Ahusthosh Total 57
Anil 22
Anil 22
Anil 22
Anil Total 66
Ashok 21
Ashok 21
Ashok 21
Ashok Total 63
Mahesh 18
English Physics Chemistry Total Average
20 14 18 71 17.75
20 14 18 71 17.75
20 14 18 71 17.75
60 42 54 53.25
13 12 19 66 16.5
13 12 19 66 16.5
13 12 19 66 16.5
39 36 57 49.5
12 12 18 63 15.75
12 12 18 63 15.75
12 12 18 63 15.75
36 36 54 47.25
19 10 14 61 15.25
Order ID Product Category Amount Date
1 Carrots Vegetables $4,270 6/1/2016
2 Broccoli Vegetables $8,239 7/1/2016
3 Banana Fruit $617 8/1/2016
4 Banana Fruit $8,384 9/1/2016
5 Beans Vegetables $2,626 10/1/2016
6 Orange Fruit $3,610 11/1/2016
7 Broccoli Vegetables $9,062 12/1/2016
8 Banana Fruit $6,906 1/1/2017
9 Apple Fruit $2,417 2/1/2017
10 Apple Fruit $7,431 3/1/2017 0
11 Banana Fruit $8,250 4/1/2017
12 Broccoli Vegetables $7,012 5/1/2017
78 $68,824
146 $137,648
287
568
1129
 54
54
0

clear

SUM

SUM0
SUM
 Ram 20 10
Ashok 21 12
Manoj 33 15
Rajesh 15 14
Ranjana 14 17
Pooja 16 8 1
Mahesh 18 19 2
Ahusthosh 19 20 7
Anil 22 13 3
Prem 26 12 4
140 14
165 21
317 39
622 74
1104 134
2466 247
4192
7762
14420
26374
48556
7.4508E+36
ADD

PRODUCT