INFORMATION TECHNOLOGY PRACTICAL FILE WORK (Calc)
Name:-____________________ Class & Sec:- ___________
Q1) In Sheet1 ,type the given data and in the same sheet use the consolidate option to display the sum
of both the branches.
Item January February Item January February
Chocolates 12000 25000 Chocolates 52000 52000
Cookies 35000 52000 Cookies 62000 50000
Pastries 55000 25000 Pastries 58000 85000
Cake 65000 25000 Cake 82000 78000
Juice 84000 52000 Juice 68000 70000
Data for ABC_Branch Data for XYZ_Branch
a) After consolidation, the data should be named as “Consolidated Data (Sum) for ABC_XYZ
Branch”.
b) Rename the sheet as “Consolidate”.
c) Save the file as <FirstName>_<LastName>_<ClassSection> (For ex : Anjali_Hossain_XA)
d) Under the heading “Output” attach a snapshot of fullscreen where all the options of
Consolidate dialog box is displayed.
e) Under the heading “Steps”, steps should be handwritten.
Output :
Steps :
Q2) Type the given data in Sheet2 and perform Subtotal.
Serial No Item Company Quantity
1 Keyboard ABC Infotech 25
2 Mouse XYZ Infotech 47
3 Mouse ABC Infotech 82
4 Keyboard XYZ Infotech 45
5 Pen Drive PQR Infotech 86
6 Pen Drive ABC Infotech 56
7 Mouse PQR Infotech 37
8 Keyboard PQR Infotech 74
9 Pen Drive XYZ Infotech 53
a) Rename the sheet as “Subtotal”
b) In the 1st Group, Group by “Item”,Calculate Subtotals for “Quantity” and use the function
“Sum”.
c) In the 2nd Group, Group by “Company”,Calculate Subtotals for “Quantity” and use the
function “Sum”.
d) Under the heading “Output” attach a snapshot of fullscreen where the final output after
performing Subtotal feature is displayed.
e) Under the heading “Steps”, steps should be handwritten.
Output :
Steps :
Q3) In Sheet3 perform Goal Seek to find out, how Much Principal should be invested to get Simple
Interest of 1500 for 3 years at the rate of 4% ?
a) Rename the sheet as “Goal Seek”.
b) Under the heading “Output” attach a snapshot where the Goal Seek dialog box with values
entered are displayed.
c) Under the heading “Output” attach another snapshot of fullscreen where the final output after
performing Goal Seek feature is displayed.
d) Under the heading “Steps”, steps should be handwritten.
Output :
Steps :
• Take printouts of the work done and submit in the previously submitted channel file.
