Daffodils Foundation for Learning
Sanjaynagar, Bengaluru-560094
Practical File
Topic: Electronic Spreadsheet (Advanced) using LibreOffice Calc
Dear students,
Following is the list of the practical work to be completed in the chapter “Electronic
Spreadsheet (Advanced) using LibreOffice Calc” as part of your practical file. Kindly
submit the practical file with the cover page, index page and all the practical work
filed in it including Calc practical on 12.11.2024. Sequence of filing in the stick file-
cover page, index page, writer practical work followed by database practical work and
finally Calc practical work. Following is the work to be completed for Calc.
1. Mr Gurdeep has to take a loan of Rs. 10 lakhs to buy a house. After assessing
his situation, he has realized that he can pay the loan in 15 years by paying out
an EMI of 20,000.
(a) Use Goal seek to find out the interest rate at which he can borrow the loan.
Formula to be used Rate of interest = (100*EMI)/Principal amount*Period
(b) Use What If Scenario to depict payment of loan in 25 years by paying out an
EMI of 10,000.
(c) Use Scenario manager to find the best case.
2. Power Motors has 3 branches all over Bhopal. Each branch maintains monthly
sales of different models of electric scooter and at the end of month mails it to the
State Head. Prepare a consolidated sheet that shows total and average sales made
for each model of the electric scooter with respect to the spreadsheet sent by the
branches to the head office. You are required to identify the column headings for
the various branches, enter data in three different spreadsheets indicating different
branches and consolidate data to find total sales and average sales for each model.
Note: Make entries of 5 different models of electric scooter. Column headings can
be Model name, Sale price. On road price, No. of vehicles sold, Total amount
(Sales).
