Assignment Advanced - SpreadSheet For Practice
Assignment Advanced - SpreadSheet For Practice
Assignment Advanced - SpreadSheet For Practice
2019
2020
2021
Q1 Q2 Q3 Q4
2019
2020
2021
Q2. Use check box to depict the data
Before paying employee bonuses and 2 different taxes (TAX1 and TAX2), a company earns profits of ₹60,000.
The company pays employees a bonus equal to 5 percent of after-tax profits. Tax 1 is 5 percent of profits
(after bonuses are paid). Tax 2 is 40 percent of profits (after bonuses and Tax1 are paid). Determine the
amount paid in bonuses, Tax1 and Tax2.
PROFITS ₹ 60,000.00
BONUS 0
TAX1
TAX2
AFTER TAX PROFIT
s profits of ₹60,000.
ercent of profits
Determine the
For a given price, how many Units of Product "A" needed to be sold per year to break even?
DEMAND=?
FACTORY
REQUIREMENTS
D
12 2000
16 4000
13 7000
4000
FACTORY
REQUIREMENTS
D
2000
4000
7000
0
4000
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
Below given is the sales on an FMCG Company in last quarter of Financial
year 2016-17. Highlight with
1. Databars.
2. Databars relative to lowest and highest values.
3. Ddatabars using 3 colours.
4. Databars using three colour icons.
RELATIVE RELATIVE
SALES in
GRADIEN TO FILL
S. No. DATE MILLION ICON
T FILL LOWEST/ (3
₹
HIGHEST Colours)
1 1-Jan-17 ₹ 26.90 ₹ 26.90 ₹ 26.90 ₹ 26.90 ₹ 26.90
2 2-Jan-17 ₹ 24.74 ₹ 24.74 ₹ 24.74 ₹ 24.74 ₹ 24.74
3 3-Jan-17 ₹ 25.82 ₹ 25.82 ₹ 25.82 ₹ 25.82 ₹ 25.82
4 4-Jan-17 ₹ 24.65 ₹ 24.65 ₹ 24.65 ₹ 24.65 ₹ 24.65
5 5-Jan-17 ₹ 24.67 ₹ 24.67 ₹ 24.67 ₹ 24.67 ₹ 24.67
6 6-Jan-17 ₹ 24.72 ₹ 24.72 ₹ 24.72 ₹ 24.72 ₹ 24.72
7 7-Jan-17 ₹ 26.90 ₹ 26.90 ₹ 26.90 ₹ 26.90 ₹ 26.90
8 8-Jan-17 ₹ 26.69 ₹ 26.69 ₹ 26.69 ₹ 26.69 ₹ 26.69
9 9-Jan-17 ₹ 26.90 ₹ 26.90 ₹ 26.90 ₹ 26.90 ₹ 26.90
10 10-Jan-17 ₹ 24.65 ₹ 24.65 ₹ 24.65 ₹ 24.65 ₹ 24.65
11 11-Jan-17 ₹ 26.69 ₹ 26.69 ₹ 26.69 ₹ 26.69 ₹ 26.69
12 12-Jan-17 ₹ 24.65 ₹ 24.65 ₹ 24.65 ₹ 24.65 ₹ 24.65
13 13-Jan-17 ₹ 26.57 ₹ 26.57 ₹ 26.57 ₹ 26.57 ₹ 26.57
14 14-Jan-17 ₹ 25.82 ₹ 25.82 ₹ 25.82 ₹ 25.82 ₹ 25.82
15 15-Jan-17 ₹ 25.82 ₹ 25.82 ₹ 25.82 ₹ 25.82 ₹ 25.82
16 16-Jan-17 ₹ 26.88 ₹ 26.88 ₹ 26.88 ₹ 26.88 ₹ 26.88
17 17-Jan-17 ₹ 24.65 ₹ 24.65 ₹ 24.65 ₹ 24.65 ₹ 24.65
18 18-Jan-17 ₹ 26.71 ₹ 26.71 ₹ 26.71 ₹ 26.71 ₹ 26.71
19 19-Jan-17 ₹ 26.93 ₹ 26.93 ₹ 26.93 ₹ 26.93 ₹ 26.93
20 20-Jan-17 ₹ 27.06 ₹ 27.06 ₹ 27.06 ₹ 27.06 ₹ 27.06
21 21-Jan-17 ₹ 25.82 ₹ 25.82 ₹ 25.82 ₹ 25.82 ₹ 25.82
22 22-Jan-17 ₹ 26.74 ₹ 26.74 ₹ 26.74 ₹ 26.74 ₹ 26.74
23 23-Jan-17 ₹ 26.63 ₹ 26.63 ₹ 26.63 ₹ 26.63 ₹ 26.63
24 24-Jan-17 ₹ 24.65 ₹ 24.65 ₹ 24.65 ₹ 24.65 ₹ 24.65
25 25-Jan-17 ₹ 26.73 ₹ 26.73 ₹ 26.73 ₹ 26.73 ₹ 26.73
26 26-Jan-17 ₹ 26.86 ₹ 26.86 ₹ 26.86 ₹ 26.86 ₹ 26.86
27 27-Jan-17 ₹ 25.66 ₹ 25.66 ₹ 25.66 ₹ 25.66 ₹ 25.66
28 28-Jan-17 ₹ 25.78 ₹ 25.78 ₹ 25.78 ₹ 25.78 ₹ 25.78
29 29-Jan-17 ₹ 25.75 ₹ 25.75 ₹ 25.75 ₹ 25.75 ₹ 25.75
30 30-Jan-17 ₹ 25.78 ₹ 25.78 ₹ 25.78 ₹ 25.78 ₹ 25.78
31 31-Jan-17 ₹ 25.77 ₹ 25.77 ₹ 25.77 ₹ 25.77 ₹ 25.77
32 1-Feb-17 ₹ 25.82 ₹ 25.82 ₹ 25.82 ₹ 25.82 ₹ 25.82
33 2-Feb-17 ₹ 25.86 ₹ 25.86 ₹ 25.86 ₹ 25.86 ₹ 25.86
34 3-Feb-17 ₹ 26.15 ₹ 26.15 ₹ 26.15 ₹ 26.15 ₹ 26.15
35 4-Feb-17 ₹ 26.24 ₹ 26.24 ₹ 26.24 ₹ 26.24 ₹ 26.24
36 5-Feb-17 ₹ 25.86 ₹ 25.86 ₹ 25.86 ₹ 25.86 ₹ 25.86
37 6-Feb-17 ₹ 25.70 ₹ 25.70 ₹ 25.70 ₹ 25.70 ₹ 25.70
38 7-Feb-17 ₹ 25.80 ₹ 25.80 ₹ 25.80 ₹ 25.80 ₹ 25.80
39 8-Feb-17 ₹ 26.93 ₹ 26.93 ₹ 26.93 ₹ 26.93 ₹ 26.93
40 9-Feb-17 ₹ 26.03 ₹ 26.03 ₹ 26.03 ₹ 26.03 ₹ 26.03
41 10-Feb-17 ₹ 26.14 ₹ 26.14 ₹ 26.14 ₹ 26.14 ₹ 26.14
42 11-Feb-17 ₹ 25.95 ₹ 25.95 ₹ 25.95 ₹ 25.95 ₹ 25.95
43 12-Feb-17 ₹ 26.01 ₹ 26.01 ₹ 26.01 ₹ 26.01 ₹ 26.01
44 13-Feb-17 ₹ 26.00 ₹ 26.00 ₹ 26.00 ₹ 26.00 ₹ 26.00
45 14-Feb-17 ₹ 26.10 ₹ 26.10 ₹ 26.10 ₹ 26.10 ₹ 26.10
46 15-Feb-17 ₹ 26.39 ₹ 26.39 ₹ 26.39 ₹ 26.39 ₹ 26.39
47 16-Feb-17 ₹ 26.14 ₹ 26.14 ₹ 26.14 ₹ 26.14 ₹ 26.14
48 17-Feb-17 ₹ 26.17 ₹ 26.17 ₹ 26.17 ₹ 26.17 ₹ 26.17
49 18-Feb-17 ₹ 25.92 ₹ 25.92 ₹ 25.92 ₹ 25.92 ₹ 25.92
50 19-Feb-17 ₹ 26.27 ₹ 26.27 ₹ 26.27 ₹ 26.27 ₹ 26.27
51 20-Feb-17 ₹ 26.37 ₹ 26.37 ₹ 26.37 ₹ 26.37 ₹ 26.37
52 21-Feb-17 ₹ 24.32 ₹ 24.32 ₹ 24.32 ₹ 24.32 ₹ 24.32
53 22-Feb-17 ₹ 25.32 ₹ 25.32 ₹ 25.32 ₹ 25.32 ₹ 25.32
54 23-Feb-17 ₹ 25.54 ₹ 25.54 ₹ 25.54 ₹ 25.54 ₹ 25.54
55 24-Feb-17 ₹ 25.45 ₹ 25.45 ₹ 25.45 ₹ 25.45 ₹ 25.45
56 25-Feb-17 ₹ 25.59 ₹ 25.59 ₹ 25.59 ₹ 25.59 ₹ 25.59
57 26-Feb-17 ₹ 25.79 ₹ 25.79 ₹ 25.79 ₹ 25.79 ₹ 25.79
58 27-Feb-17 ₹ 25.86 ₹ 25.86 ₹ 25.86 ₹ 25.86 ₹ 25.86
59 28-Feb-17 ₹ 25.69 ₹ 25.69 ₹ 25.69 ₹ 25.69 ₹ 25.69
60 1-Mar-17 ₹ 25.74 ₹ 25.74 ₹ 25.74 ₹ 25.74 ₹ 25.74
61 2-Mar-17 ₹ 25.84 ₹ 25.84 ₹ 25.84 ₹ 25.84 ₹ 25.84
62 3-Mar-17 ₹ 25.71 ₹ 25.71 ₹ 25.71 ₹ 25.71 ₹ 25.71
63 4-Mar-17 ₹ 25.84 ₹ 25.84 ₹ 25.84 ₹ 25.84 ₹ 25.84
64 5-Mar-17 ₹ 26.02 ₹ 26.02 ₹ 26.02 ₹ 26.02 ₹ 26.02
65 6-Mar-17 ₹ 25.78 ₹ 25.78 ₹ 25.78 ₹ 25.78 ₹ 25.78
66 7-Mar-17 ₹ 25.57 ₹ 25.57 ₹ 25.57 ₹ 25.57 ₹ 25.57
67 8-Mar-17 ₹ 25.66 ₹ 25.66 ₹ 25.66 ₹ 25.66 ₹ 25.66
68 9-Mar-17 ₹ 27.99 ₹ 27.99 ₹ 27.99 ₹ 27.99 ₹ 27.99
69 ### ₹ 24.33 ₹ 24.33 ₹ 24.33 ₹ 24.33 ₹ 24.33
70 ### ₹ 24.17 ₹ 24.17 ₹ 24.17 ₹ 24.17 ₹ 24.17
71 ### ₹ 24.37 ₹ 24.37 ₹ 24.37 ₹ 24.37 ₹ 24.37
72 ### ₹ 24.49 ₹ 24.49 ₹ 24.49 ₹ 24.49 ₹ 24.49
73 ### ₹ 24.62 ₹ 24.62 ₹ 24.62 ₹ 24.62 ₹ 24.62
74 ### ₹ 24.26 ₹ 24.26 ₹ 24.26 ₹ 24.26 ₹ 24.26
75 ### ₹ 24.26 ₹ 24.26 ₹ 24.26 ₹ 24.26 ₹ 24.26
76 ### ₹ 24.12 ₹ 24.12 ₹ 24.12 ₹ 24.12 ₹ 24.12
77 ### ₹ 24.59 ₹ 24.59 ₹ 24.59 ₹ 24.59 ₹ 24.59
78 ### ₹ 24.59 ₹ 24.59 ₹ 24.59 ₹ 24.59 ₹ 24.59
79 ### ₹ 25.28 ₹ 25.28 ₹ 25.28 ₹ 25.28 ₹ 25.28
80 ### ₹ 25.17 ₹ 25.17 ₹ 25.17 ₹ 25.17 ₹ 25.17
81 ### ₹ 25.31 ₹ 25.31 ₹ 25.31 ₹ 25.31 ₹ 25.31
82 ### ₹ 26.70 ₹ 26.70 ₹ 26.70 ₹ 26.70 ₹ 26.70
83 ### ₹ 26.79 ₹ 26.79 ₹ 26.79 ₹ 26.79 ₹ 26.79
84 ### ₹ 24.80 ₹ 24.80 ₹ 24.80 ₹ 24.80 ₹ 24.80
85 ### ₹ 24.97 ₹ 24.97 ₹ 24.97 ₹ 24.97 ₹ 24.97
86 ### ₹ 25.12 ₹ 25.12 ₹ 25.12 ₹ 25.12 ₹ 25.12
87 ### ₹ 25.17 ₹ 25.17 ₹ 25.17 ₹ 25.17 ₹ 25.17
88 ### ₹ 27.00 ₹ 27.00 ₹ 27.00 ₹ 27.00 ₹ 27.00
89 ### ₹ 25.32 ₹ 25.32 ₹ 25.32 ₹ 25.32 ₹ 25.32
90 ### ₹ 25.22 ₹ 25.22 ₹ 25.22 ₹ 25.22 ₹ 25.22
Region Product Sales
East Projector 230 Q1. Make dynamic chart
West Computer 80
East Printer 144 Region West
East Digital Ca 120
West Projector 250 Product Sales
North Digital Ca 400 #NAME? #NAME?
West Tablet 270 #NAME? #NAME?
West Printer 90 #NAME? #NAME?
West Microphon 320 #NAME? #NAME?
South Digital Ca 210 #NAME? #NAME?
North Projector 140
South Printer 75
North Computer 120
North Printer 50
I intend to build a new house. The amount of money I need to borrow (10 lac with a 15-year repayment period) depends on
price for which I sell my current house(new house costs me 15Lac and old house may give return of 4 to 7 Lac. I’m also unsu
about the annual interest rate I’ll receive when I close. Can I determine how my monthly payments will depend on the amo
borrowed and the annual interest rate?
E
11.25% 11.50% 11.75%
Internal
Name FM HR Marketing
N1 90 98 80
N2 67 87 45
N3 87 97 56
N4 67 90 67
N5 75 67 65
MID-LAP
Name FM HR Marketing
N1 98 78 87 Exam Typeè Internal
FIND MARKS ê
N2 87 87 56 Subject Areaè Marketing
N3 76 92 33 Student Nameè N1 80
N4 65 97 46
N5 78 87 7
END-LAP
Name FM HR Marketing
N1 56 56 4
N2 56 67 5
N3 67 89 56
N4 89 56 78
N5 76 67 98
Population Income Illiteracy Life Exp Murder HS Grad Frost Area
Alabama 3615 3624 2.1 69.05 15.1 41.3 20 50708
Alaska 365 6315 1.5 69.31 11.3 66.7 152 566432
Arizona 2212 4530 1.8 70.55 7.8 58.1 15 113417
Arkansas 2110 3378 1.9 70.66 10.1 39.9 65 51945
California 21198 5114 1.1 71.71 10.3 62.6 20 156361
Colorado 2541 4884 0.7 72.06 6.8 63.9 166 103766
Connecticu 3100 5348 1.1 72.48 3.1 56 139 4862
Delaware 579 4809 0.9 70.06 6.2 54.6 103 1982
Florida 8277 4815 1.3 70.66 10.7 52.6 11 54090
Georgia 4931 4091 2 68.54 13.9 40.6 60 58073
Hawaii 868 4963 1.9 73.6 6.2 61.9 0 6425
Idaho 813 4119 0.6 71.87 5.3 59.5 126 82677
Illinois 11197 5107 0.9 70.14 10.3 52.6 127 55748
Indiana 5313 4458 0.7 70.88 7.1 52.9 122 36097
Iowa 2861 4628 0.5 72.56 2.3 59 140 55941
Kansas 2280 4669 0.6 72.58 4.5 59.9 114 81787
Kentucky 3387 3712 1.6 70.1 10.6 38.5 95 39650
Louisiana 3806 3545 2.8 68.76 13.2 42.2 12 44930
Maine 1058 3694 0.7 70.39 2.7 54.7 161 30920
Maryland 4122 5299 0.9 70.22 8.5 52.3 101 9891
Massachuse 5814 4755 1.1 71.83 3.3 58.5 103 7826
Michigan 9111 4751 0.9 70.63 11.1 52.8 125 56817
Minnesota 3921 4675 0.6 72.96 2.3 57.6 160 79289
Mississippi 2341 3098 2.4 68.09 12.5 41 50 47296
Missouri 4767 4254 0.8 70.69 9.3 48.8 108 68995
Montana 746 4347 0.6 70.56 5 59.2 155 145587
Nebraska 1544 4508 0.6 72.6 2.9 59.3 139 76483
Nevada 590 5149 0.5 69.03 11.5 65.2 188 109889
New Hamps 812 4281 0.7 71.23 3.3 57.6 174 9027
New Jersey 7333 5237 1.1 70.93 5.2 52.5 115 7521
New Mexic 1144 3601 2.2 70.32 9.7 55.2 120 121412
New York 18076 4903 1.4 70.55 10.9 52.7 82 47831
North Carol 5441 3875 1.8 69.21 11.1 38.5 80 48798
North Dako 637 5087 0.8 72.78 1.4 50.3 186 69273
Ohio 10735 4561 0.8 70.82 7.4 53.2 124 40975
Oklahoma 2715 3983 1.1 71.42 6.4 51.6 82 68782
Oregon 2284 4660 0.6 72.13 4.2 60 44 96184
Pennsylvan 11860 4449 1 70.43 6.1 50.2 126 44966
Rhode Isla 931 4558 1.3 71.9 2.4 46.4 127 1049
South Carol 2816 3635 2.3 67.96 11.6 37.8 65 30225
South Dako 681 4167 0.5 72.08 1.7 53.3 172 75955
Tennessee 4173 3821 1.7 70.11 11 41.8 70 41328
Texas 12237 4188 2.2 70.9 12.2 47.4 35 262134
Utah 1203 4022 0.6 72.9 4.5 67.3 137 82096
Vermont 472 3907 0.6 71.64 5.5 57.1 168 9267
Virginia 4981 4701 1.4 70.08 9.5 47.8 85 39780
Washingto 3559 4864 0.6 71.72 4.3 63.5 32 66570
West Virgin 1799 3617 1.4 69.48 6.7 41.6 100 24070
Wisconsin 4589 4468 0.7 72.48 3 54.5 149 54464
Wyoming 376 4566 0.6 70.29 6.9 62.9 173 97203