Page 336 - TP_IT_V1.0_C9_flipbpookl
P. 336
c. Write the formula in F2 to find the average marks scored by Arshia.
d. Copy the formula entered in F2 for other students.
e. Write the formula in cell B7 to find the highest score in Hindi.
f. Write the formula to find the highest score in English and Maths in C7 and D7 respectively.
g. Write the formula in cell B8 to find the total number of students who appeared in Hindi.
h. Write the formula in cell B9 to find the lowest score in Hindi.
i. Write the formula to find the lowest score in English and Maths in C9 and D9 respectively.
3. Consider a mathematical function, such as Y=3*X+1. Calculate the value of Y for each value of X, as given in the table below.
Value of X 2 4 6 8 10
Value of Y ? ? ? ? ?
Perform the given tasks:
a. Enter these values in Calc spreadsheet.
b. Use formula to find out the values of Y for each value of X.
c. Plot a line chart of X and Y values together.
4. Collect the electricity bill of your home for each month from January to May. Create a spreadsheet with the data of Month
Name and Bill Amount as below.
MONTH BILL AMOUNT
JANUARY ?
FEBRUARY
MARCH
APRIL
MAY
Enter the data in a spreadsheet and plot any three charts. Also find out that which type of chart will be more appropriate
for such type of data.
Assertion and Reasoning Based Questions:
Direction: Questions 5-6, 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.
5. Assertion (A): Absolute cell references in LibreOffice Calc are useful when you want a formula to always refer to a specific
cell, regardless of where the formula is copied.
Reason (R): Absolute cell references are indicated by adding a dollar sign ($) before the column letter and row number
(e.g., $A$1).
6. Assertion (A): Line charts in LibreOffice Calc are used to show trends over time or for continuous data.
Reason (R): Line charts and pie charts serve different purposes; one is more effective than the other for displaying
proportions of a whole.
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 True, Statement 2 is False
d. Statement 1 is False, Statement 2 is True
7. Statement 1: Autofill in LibreOffice Calc allows you to quickly fill cells with data based on a pattern or series.
Statement 2: Autofill in LibreOffice Calc can be used to extend a series of dates or numbers automatically.
334 Trackpad Information Technology (Ver. 1.0)-IX

