Sheet1
Calc Questions – By Ritul Gupta X-D J.S.S.S.
Question 1 - Month 1 Month 2
Deposit Withdrawal Deposit Withdrawal
1000 500 1000 1500
5000 700 5000 700
8000 1900 8000 1900
3000 800 3000 800
7000 6000 7000 6000
Deposit Withdrawal
3000 2500
17000 4100
34000 7100
25000 6200
27000 19600
Question 2 - Question 3 -
Area Distribution A B
A 7000 1 Name Basic
A 70090 2 Surinder 50000
A 78995 3 Kanika 56000
A 78959 4 Ashish 35000
A Sum 235044 5 Harjit 45000
B 8000 6 Abhijit 60000
B 30000 7 Jyoti 75000
B 45789 8 Amita 25000
B 64567 9 Maximum
B Sum 148356 10 No. Of Emp.
C 6800
C 79008 (1) To calculate the value of DA we need to write the formula =(G2
C 57853 then press enter and copy paste this formula to all the ce
C 5677 is relative cell referencing it would be copied
C Sum 149338
Grand Sum 532738 (2) Write the formula =G23+H23+I23-J23 in the cell for Surin
Then again copy paste the in the cells direcly below.
(3) No, because I have used the value is put by formula , not an abs
(4) The formula is =MAX(K23,K24,K25,K25,K26,K27,K28,K
1. Open a (5) The formula is =COUNT(E23,E24,E25,E26,E27,E28,E28
worksheet
Question
having the4 -
result of a 5. Open the worksheet in which you want to run a macro
6. Select the range on you want to play the formatting (which you recorded in macros).
7. Click Command Tools Macros Run Мастo.
8. Click on icon to expand My Macros and Standard groups and select Module.
As soon as you click on t, it will become a icon. After you select Module, the list of macros in it will be dis
Page 1
Sheet1
Choose the macro to be run and click on Run button.
Question 5 -
Ans – To create a scenario -
(1)Select the cell that contain the values .Hold Ctrl key as you [Link] must select at least 2 ranges.
(2) Click Tools - > Scenarios.
(3) It will open create scenario dialog.
(a) Enter the name for the new scenario.
(b) Uncheck copy box.
(4) Click OK when done.
(5) Now change the value and see its impact.
(6)Click tools → Scenario and write another scenario name.
(7) Now both the scenarios are saved.
Amount House loan
Rate 1000000
Time(in years) 5
Simple intrest 2
100000
Page 2
Sheet1
pta X-D J.S.S.S.
Month 3
Deposit Withdrawal
1000 500
7000 2700
18000 3300
19000 4600
13000 7600
Consolidated data
C D E F
HRA DA PF Net Salary
20000 17500 600 86900
200000 64000 600 319400
15000 12500 600 61900
15000 15000 600 74400
25000 21250 700 105550
30000 26250 700 130550
10000 8750 300 43450
319400
8
A we need to write the formula =(G23+H23)*0.25
y paste this formula to all the cells. As this
g it would be copied
H23+I23-J23 in the cell for Surinder as done before.
the cells direcly below.
he value is put by formula , not an absolute number .
3,K24,K25,K25,K26,K27,K28,K29) .
(E23,E24,E25,E26,E27,E28,E28:E29) .
u recorded in macros).
select Module.
Module, the list of macros in it will be displayed.
Page 3
Sheet1
must select at least 2 ranges.
Page 4