Practical-8
Libre office Calc
Using Autofill feature in Calc
A B C D E F G H
1 Days of the Months Date EMP Code
Multiples
Serial Even odd week
of 3
2 1 2 1 3 Sunday Jan 01/01/25 A1001
3 2 4 3 6 Monday Feb 02/01/25 A1002
4 3 6 5 9 Tuesday Mar 03/01/25 A1003
5 4 8 7 12 Wednesday Apr 04/01/25 A1004
6 5 10 9 15 Thursday May 05/01/25 A1005
7 6 12 11 18 Friday Jun 06/01/25 A1006
8 7 14 13 21 Saturday Jul 07/01/25 A1007
9 8 16 15 24 Aug 08/01/25 A1008
10 9 18 17 27 Sep 09/01/25 A1009
11 10 20 19 30 Oct 10/01/25 A1010
12 Nov 11/01/25
13 Dec 12/01/25
Practical -9
Implement the example of the shopping bill. Give the formula applied.
A B C D E
1 Sno Item Price Quantity Total Price
2 1 Biscuits ₹30.00 2 ₹60.00
3 2 Chocolates ₹50.00 5 ₹250.00
4 3 Notebooks ₹60.00 6 ₹360.00
5 4 Pencils ₹8.00 5 ₹40.00
6 5 Eraser ₹5.00 2 ₹10.00
7 6 Cellotape ₹10.00 3 ₹30.00
8 7 Sugar ₹40.00 3 ₹120.00
9 8 Toor dal ₹180.00 2 ₹360.00
10 9 Chart paper ₹10.00 3 ₹30.00
11 10 Fevi stick ₹20.00 2 ₹40.00
12 Total Bill Amount ₹1,300.00
a) Apply currency to column C
Ans. Select the values in the price column(c ) -> Select format as currency
(CTRL+shift+4)-> Change the numbers to Indian ₹(by default)
b) Calculating total price
Ans. In E2 cell, we have to apply the formula E2= C2*D2, then use auto fill of the
formula in the remaining cells.
c) Merge and center A12,B12,C12 and D12 cells and type “Total bill amount”
d) Apply E12= sum(E2:E11)
Practical -10
Applying Arithmetic operations (addition, subtraction, multiplication ,division and
exponentiation).
A B C D E F G
1 Num1 Num2 Add Sub Div Mul Exp
2 23 2 25 21 11.50 46 529.00
3 45 3 48 42 15.00 135 91125.00
4 12 12 24 0 1.00 144 8916100448256.00
5 11 2 13 9 5.50 22 121.00
6 9 9 18 0 1.00 81 387420489.00
A) Enter the values under columns Num1 and Num2
B) Apply formula C2=A2+B2, apply auto fill in the remaining cells.
C) Apply formula D2=A2-B2, apply auto fill in the remaining cells.
D) Apply formula E2=A2/B2, apply auto fill in the remaining cells.
E) Apply formula F2=A2*B2, apply auto fill in the remaining cells.
F) Apply formula G2=A2^B2, apply auto fill in the remaining cells.
Practical -11
Applying complex formula.
i) To find area and perimeter of triangle
ii) To find total surface area of cuboid
A B C D E F
1 Triangle
2 Side1 Side2 side3 perimeter semi Area
3 5.678 7.89 9.56 23.13 11.56 22.39
4 22.39
5 Cuboid
6 Length Breadth Height total surface area
7 56.67 45.23 23.87 9991.0742
i)To find area and perimeter of triangle:
Ans: a) Apply D3=A3+B3+C3, change the format of cell to two decimal places by using
delete decimal in formatting tool bar.
b) Apply E3 =D3/2
c) Apply F3 =SQRT(E3*(E3-A3)*(E3-B3)*(E3-C3))
OR
Apply F4=(E3*(E3-A3)*(E3-B3)*(E3-C3))^(1/2)
ii)To find total surface area of cuboid
Ans: a) Apply D7 =2*((A7*B7)+(A7*C7)+(B7*C7))
Practical-12
Using Sum, Average, Max, Min , Count built-in functions.
A B C D E F G H I J
1 Regno Name English Social II Science Math IT Total Percentage
Lang
2 101 Amit 65 84 33 30 30 69 311 51.83%
3 102 Deepak 31 41 87 57 57 35 308 51.33%
4 103 Chetana 77 48 72 35 35 65 332 55.33%
5 104 Firoz 76 79 33 73 73 76 410 68.33%
6 105 Gagan 41 93 52 87 87 29 389 64.83%
7 106 Meena 90 84 92 43 43 54 406 67.67%
8 107 Nikhil 30 90 39 44 44 59 306 51.00%
9 108 Tejpal 93 74 42 84 84 48 425 70.83%
10 109 Vinay 62 81 74 93 93 86 489 81.50%
11 110 Yususf 27 27 28 61 61 48 252 42.00%
12 Minimum 30
13 Maximum 489
14 Count of students 10
who attended English
Exam
Create a table as above, perform the following functions:
i)Use Auto fill feature for Regno in Column A.
Ans: Type 101 and 102 in A2 and A3 cells respectively. Select both the cells and use fill
handle, drag till A11 to auto fill the numbers
ii)Calculate Total marks scored by each student.
Ans: In I2 cell give I2=SUM(C2:H2), or use Auto sum feature. Select I2 cell using the fill
handle apply the same formula in other cells using auto fill feature from I3 to I11.
iii)Calculate Percentage: J2 cell apply J2=AVERAGE(C2:H2). Then change the number
format to Percentage(%). Apply the same formula in the remaining cells using the auto fill
feature.
iv)Find minimum marks scored in the whole class in Mathematics.
Ans: In Cell G12 apply G12=MIN(G2:G11). Also use Merge and Center of A12 and B12
cells, and type MINIMUM.
v)To find the maximum Total scored by the topper of the class.
Ans: Apply in Cell I13, I13=MAX(I2:I11). This will give the maximum total scored by the
topper of the class.
vi) To find the number of students, who have appeared for English exam.
In cell C14, apply C14= Count(C2:C11). This will give the count.
Practical- 13
Prepare a worksheet . Calculate the allowance, deductions and salaries of 10 employees
according to the following rules:
HRA=12%of basic DA=10% of basic PF= 8% of basic Gross=
Basic+HRA+DA Net salary== Gross-PF+TA+Bonus
A B C D E F G
1 Name Basic pay HRA(12%) DA(10%) PF(8%) Gross Salary Net Salary
2 Ashish Kumar ₹28,000.00 ₹3,360.00 ₹2,800.00 ₹2,240.00 ₹36,400.00 ₹36,660.00
3 Arun Gaur ₹38,500.00 ₹4,620.00 ₹3,850.00 ₹3,080.00 ₹50,050.00 ₹49,470.00
4 Vasim ₹35,200.00 ₹4,224.00 ₹3,520.00 ₹2,816.00 ₹45,760.00 ₹45,444.00
5 Sakshi ₹20,000.00 ₹2,400.00 ₹2,000.00 ₹1,600.00 ₹26,000.00 ₹26,900.00
6 Bhavana ₹22,800.00 ₹2,736.00 ₹2,280.00 ₹1,824.00 ₹29,640.00 ₹30,316.00
7 Minal ₹25,000.00 ₹3,000.00 ₹2,500.00 ₹2,000.00 ₹32,500.00 ₹33,000.00
8 Jatinder ₹38,700.00 ₹4,644.00 ₹3,870.00 ₹3,096.00 ₹50,310.00 ₹49,714.00
9 Abhay ₹40,100.00 ₹4,812.00 ₹4,010.00 ₹3,208.00 ₹52,130.00 ₹51,422.00
10 Arpita ₹42,000.00 ₹5,040.00 ₹4,200.00 ₹3,360.00 ₹54,600.00 ₹53,740.00
11 Shilpa ₹43,800.00 ₹5,256.00 ₹4,380.00 ₹3,504.00 ₹56,940.00 ₹55,936.00
12
13 TA ₹1,500.00 Bonus 1000
Type TA=Rs1500 and Bonus as Rs1000 end of the employee table, in 13 th row.
Apply Relative, Absolute and mixed mode referencing.
Solution
i)HRA D2=C2*12/100 (Relative Referencing)
ii)DA E2=$C2*10/100(Mixed mode referencing)
iii)PF F2=$C2*8/100 (Mixed mode referencing)
iv)Gross Salary G2= $C2+$D2+$E2+$F2 (Mixed mode referencing)
v) Net Salary H2= =G2-F2+$C$13+$F$13(Absolute referencing)
Note: HRA= House Rent Allowance
TA= Travel Allowance DA= Dearness Allowance
PF= Provident Fund
Practical -14
Create a column chart for the data in Practical -12.
Apply the various components of the column Chart.
Column chart to show the performance of each student in Test-2 in all the subjects
Practical -15
Create a pie chart for the data in Practical 13.
Pie chart showing the distribution of the Net salaries to the employees, for the month of Dec-
2024