Page 288 - TP_IT_V1.0_C10_flipbpookl
P. 288
B. Long answer type questions.
1. List down the issues that you may face at the time of saving a shared document.
2. Give the steps for recording and running macro.
3. Give the steps to link to an external data source.
4. How do you access the code window of a macro?
5. How do you create a simple macro function?
6. Write the steps to format comments in LibreOffice Calc.
7. What do you mean by data analysis? Why is it important? Write the names of the tools used in data analysis.
21 st #Communication
C. Competency-based/Application-based questions. Century
Skills #Critical Thinking
1. Amit wants to combine and find the average of marks obtained by his five friends in the previous three periodic tests. The
data is stored in various sheets of a workbook. Which tool is best suited for him? Write the steps also to simplify his work.
2. Rohit scored 25 out of 30 in English and 22 out of 30 in math. He wants to calculate the score in IT to achieve 80 percent in
aggregate. Suggest to him the appropriate what-if analysis tool to get the desired result. Provide the steps for implementing
it in a spreadsheet to achieve the aforementioned percentage.
3. Krish and Kritika have done a survey of age-wise literacy rates of their locality as a school project, which they have created
in a Spreadsheet. They both want to work simultaneously to complete it on time. Which option they should use to access
the same Spreadsheet to speed up their work. Also give the steps to make a shared document.
4. Rohan wants to buy a birthday gift for his friend only using his pocket money. He gets Rs. 500 per month. He plans to
spend 200 and save 300 so that he can buy a book for his friend. When he went to the market he found that the book is for
Rs. 275. Name the what-if analysis tool that he will use to find the money which now he can afford to spend.
5. Raj has created a worksheet where he has added all the information of his employees. He wants every employee to go
through the worksheet and update their address and phone number, if required.
a. Which feature of the spreadsheet should they use to see the changes made by his employees?
b. Give the steps to use the above feature in spreadsheet.
c. If he needs to add comments for the changes made then give the steps to do so.
d. What are the steps if he wishes to make the changes permanent?
6. Sneha wants to use LibreOffice Calc for calculation and data analysis of her targets given to her by her boss in the company.
She is actually new to the software and needs some help in using some of its features. Help her out by giving the steps for
the following tasks:
a. How can she add more sheets to the same worksheets?
b. She wants to rename the existing worksheets.
c. Delete the unwanted sheets.
d. Adding a hyperlink to connect to the company's web address.
Assertion and Reasoning Questions:
Direction: Questions 7-8, consist of two statements – Assertion (A) and Reasoning (R). Answer these questions by selecting
the appropriate option given below:
a. Both A and R are true and R is the correct explanation of A.
b. Both A and R are true but R is not the correct explanation of A.
c. A is true but R is false.
d. A is false but R is true.
7. Assertion (A): If a function or formula is copied or moved, the cell address in the formula is automatically updated with
respect to the new location.
Reasoning (R): In LibreOffice Calc, you can use cell references to refer to data on sheets of other spreadsheets.
286 Trackpad Information Technology (Ver. 1.0)-X

