Page 332 - TP_IT_V1.0_C9_flipbpookl
P. 332
iv. Pie Chart: It displays a circular chart cut by radii into segments, with each slice of pie showing the size is series, which
has no zero or less than zero value.
21 st #Productivity & Accountability
C. Competency-based/Application-based questions. Century
Skills #Technology Literacy
1. Kartik’s father has recently been selected as the president of the society and was told to make a list of the neighbours with
details like name, number of members, phone number, address, date of shifting to their locality, and other details so that
he can share them with all the residents.
a. Help him by suggesting the most suitable application software needed for this task.
b. Which feature of the software will help him generate the serial number?
c. Give the steps to change the font size and style.
d. Give the steps to save the file.
Ans. a. LibreOffice Calc
b. AutoFill feature helps you fill the predictable series automatically in a range of cells using the fill handle (plus sign (+)).
This fill handle appears when the mouse pointer moves over the bottom right corner of an active cell. Drag this handle
down to the point till the series needs to be generated.
c. Select Font and Style icons present on the Formatting toolbar.
d. Click on the File → Save.
2. Kabir has maintained his marks of five subjects in all 3 unit tests in three sheets. Help him do the given tasks:
a. Write the steps to rename the sheets as Unit1, Unit2, Unit3.
b. Feature to copy formula to rest of the cells.
Ans. a. The steps to rename a Sheet are:
i. Double-click the sheet in the Sheet tab. A Rename Sheet dialog box opens.
ii. Type the name in the Name text box.
iii. Click on the OK button.
b. AutoFill feature or Copy and Paste options.
3. Naina wants to store data of her monthly expenditures for a period of one year and also wants to perform some calculations
and analysis. Which LibreOffice application will you suggest Naina to use for this purpose?
Ans. LibreOffice Calc
Assertion and Reasoning Based Questions:
Direction: Questions 3-4, 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.
4. Assertion (A): Charts in LibreOffice Calc are used to visually represent data.
Reason (R): Charts help in understanding data trends and comparisons more easily than raw numbers.
5. Assertion (A): Bar charts in LibreOffice Calc are suitable for comparing data across different categories.
Reason (R): Bar charts can only display one dataset at a time and cannot be combined with other chart types.
Statement Based Questions:
Two statements are given. Statement 1 and Statement 2. Examine the statements and answer the question according to
the instructions given below:
a. Statement 1 is True, Statement 2 is True
b. Statement 1 is False, Statement 2 is False
c. Statement 1 is False, Statement 2 is False
d. Statement 1 is False, Statement 2 is True
330 Trackpad Information Technology (Ver. 1.0)-IX

