ROUNDDOWN, AVERAGE & I

Name Roll No Module 1 Module 2 Project Online Total

Sakshi 1 70 75 70 75 290
Akanksha 2 50 50 60 65 225
Deepti 3 63 65 73 80 281
Akash 4 55 60 45 60 220
Munish 5 40 50 50 60 200
Megha 6 65 55 55 55 230
Ramesh 7 45 50 65 60 220
Sanjeev 8 75 65 90 70 300
Rajeev 9 49 55 45 65 214
Anshu 10 50 50 55 50 205
UNDDOWN, AVERAGE & IF FUNCTION

Average Pass/Fail Grade Rank

72 PASS A 2 AVERAGE MARKS GRADE
56 PASS C 5 >=70 A
70 PASS A 3 >=60 B
55 PASS C 6 >=50 C
50 PASS C 10 <50 D
57 PASS C 4
55 PASS C 6
75 PASS A 1
53 PASS C 8
51 PASS C 9

3
 IF FUNCTION

NAMES AGE APPLY IF VOTING ELIGIBILITY

A 20 ELIGIBLE ABOVE 18
B 25 ELIGIBLE BELOW 18
C 17 NOT ELIGIBLE
D 15 NOT ELIGIBLE
E 12 NOT ELIGIBLE
F 5 NOT ELIGIBLE
G 60 ELIGIBLE
VOTING ELIGIBILITY
ELIGIBLE
NOT ELIGIBLE
 PIVOT TABLE
Order Id Product Category Amount Date Country
1 Carrots Vegetables 4270 6/1/2012 United States
2 Brocoli Vegetables 8239 7/1/2012 United Kingdom
3 Banana Fruits 617 8/1/2012 United States
4 Banana Fruits 8394 10/1/2012 Canada
5 Beans Vegetables 2626 10/1/2012 Germany
6 Orange Fruits 3610 11/1/2012 United States
7 Brocoli Vegetables 9062 11/1/2012 Australia
8 Banana Fruits 6906 16/1/2012 New Zealand
9 Apple Fruits 2417 16/1/2012 France
10 Apple Fruits 7431 16/1/2012 Canada
11 Banana Fruits 8250 16/1/2012 Germany
12 Brocoli Vegetables 7012 18/1/2012 United States
13 Carrots Vegetables 1903 20/1/2012 Germany
14 Brocoli Vegetables 2824 22/1/2012 Canada
15 Apple Fruits 6946 24/1/2012 France
16 Banana Fruits 2320 27/1/2012 United Kingdom
17 Banana Fruits 2116 28/1/2012 United States
18 Banana Fruits 1135 30/1/2012 United Kingdom
19 Brocoli Vegetables 3595 30/1/2012 United Kingdom
20 Apple Fruits 1161 2/2/2012 United States
21 Orange Fruits 2256 4/2/2012 France
22 Banana Fruits 1004 11/2/2012 New Zealand
23 Banana Fruits 3642 14/2/2012 Canada
24 Banana Fruits 4582 17/2/2012 United States
25 Beans Vegetables 3559 17/2/2012 United Kingdom
 PIVOT CHART

Sum of Amount Country

Category Product Australia Canada France Germany
Fruits 19467 11619 8250
Apple 7431 9363
Banana 12036 8250
Orange 2256
Vegetables 9062 2824 4529
Beans 2626
Brocoli 9062 2824
Carrots 1903
Total Result 9062 22291 11619 12779
ART

New Zealand United KingdomUnited States Total Result

7910 3455 12086 62787
1161 17955
7910 3455 7315 38966
3610 5866
15393 11282 43090
3559 6185
11834 7012 30732
4270 6173
7910 18848 23368 105877
 PIVOT TABLE

Sales Person Region Account Order Amount Month

Manvita East 29386 925 January
Manvita East 74830 875 February
Manvita East 90099 500 February
Manvita East 74830 350 March
Ramya West 82853 400 January
Ramya West 72949 850 January
Ramya West 90044 1500 January
Ramya West 82853 550 February
Ramya West 72949 400 March
Lavanya South 55223 235 February
Lavanya South 10354 850 January
Lavanya South 50192 600 March
Lavanya South 27589 250 January
Lavanya West 67275 400 January
Lavanya West 41828 965 February
Lavanya West 87543 125 March
Inchara South 97446 1500 March
Inchara South 41400 305 January
Inchara South 30974 1350 January
 PIVOT CHART

Account - all -

Sum of Order Amount Region

Sales Person Month East South West Total Result
Inchara 3155 3155
January 1655 1655
March 1500 1500
Lavanya 1935 1490 3425
January 1100 400 1500
February 235 965 1200
March 600 125 725
Manvita 2650 2650
January 925 925
February 1375 1375
March 350 350
Ramya 3700 3700
January 2750 2750
February 550 550
March 400 400
Total Result 2650 5090 5190 12930
 DATA VALIDATION

Name Place Transportation Charges

Lavanya Banashankari 400
Deepa Bangalore 500
Pragati Basavanagudi 600
Ramya Chitradurga 500
Nikil Davanagere 700
Bindu Hiriyur 620
Lahari Jalahalli 820
Rahul Koppala 300
Spurti Kr Puram 542
Sneha Malleshwaram 845
Manikya Mysore 100
Sahana Rajajinagar 945
Jyothi Sira 720
Rakshita Tumkur 200
Sindu Yashavantapura 520
 Charity Donations Forecast
Taxes January February March
Income from Libel
150 175 200
Cases
Income from
750 250 216
Appearances

Charity Donations 225 106.25 104

Tax Rebate 13.5 6.375 6.24

 CHARITY DONATIONS
FORCAST
Tax Rebate

Charity Donations
March February January

Income from Appearances

Income from Libel Cases

0 200 400 600 800

 2021 2022 2023
Tea
Coffee
19
22
23
24
25
22 PRODUC
Sugar 45 40 45

2023

2022

+
2021

0 5 10 15 20
PRODUCTION DETAILS

Sugar

Coffee

Tea

0 5 10 15 20 25 30 35 40 45
 TRANSPORTATION

AB Pvt. Ltd
Training Expenses 2016
Month Cost
Jan 200
Feb 45
Mar 300
Apr 65
May 80
Jun 90
Jul 45
Aug 65
Sep 70
Oct 120
Nov 40
Dec 110
BOOKS & STATIONARY

AB Pvt. Ltd
Training Expenses 2016
Month Cost
Jan 300
Feb 55
Mar 200
Apr 90
May 70
Jun 80
Jul 65
Aug 40
Sep 90
Oct 110
Nov 80
Dec 50
 EATERIES

AB Pvt. Ltd
Training Expenses 2016
Month Cost
Jan 100
Feb 65
Mar 90
Apr 70
May 60
Jun 150
Jul 30
Aug 65
Sep 70
Oct 150
Nov 40
Dec 90
 CONSOLIDATED

AB Pvt. Ltd
Training Expenses 2016
Month Cost
Jan 600
Feb 165
Mar 590
Apr 225
May 210
Jun 320
Jul 140
Aug 170
Sep 230
Oct 380
Nov 160
Dec 250
 PMT, PPMT & IPMT FUNCTION

LIMIT 15000
TOTAL INSTALLMENTS 10
RATE 10%
EMI ₹ 1,569.61

NO. OF INSTALLMENTS EMI PRINCIPAL INTEREST

1 ₹ 1,569.61 ₹ 1,444.61 ₹ 125.00
2 ₹ 1,569.61 ₹ 1,456.64 ₹ 112.96
3 ₹ 1,569.61 ₹ 1,468.78 ₹ 100.82
4 ₹ 1,569.61 ₹ 1,481.02 ₹ 88.58
5 ₹ 1,569.61 ₹ 1,493.36 ₹ 76.24
6 ₹ 1,569.61 ₹ 1,505.81 ₹ 63.80
7 ₹ 1,569.61 ₹ 1,518.36 ₹ 51.25
8 ₹ 1,569.61 ₹ 1,531.01 ₹ 38.60
9 ₹ 1,569.61 ₹ 1,543.77 ₹ 25.84
10 ₹ 1,569.61 ₹ 1,556.63 ₹ 12.97