Page 239 - IT_Play_V1.0 Class9
P. 239
iii. A is true but R is false.
iv. A is false but R is true.
Assertion (A): Numeric data in a spreadsheet can include decimal points and percentage symbols.
Reason (R): By default, numeric data in spreadsheets is aligned to the left side of the cell.
Section B (Subjective Type Questions)
A. Answer the following questions:
1. Write a short note on the list of errors that commonly occur in ‘Calc’ along with the reason of their occurrence.
2. Explain the following statistical functions:
i. MAX()
ii. AVERAGE()
iii. COUNT()
3. Discuss the differences between the OR and AND logical functions.
4. What is the difference between formula and function?
5. What do you mean by a formula? Give an example.
21 st
B. Application-based questions. Century #Critical Thinking
Skills
1. A user wants to calculate the percentage of total sales from a particular region using the formula. If the total sales
is in cell D10 and the region's sales is in cell D2, what formula should they use?
2. Sita is managing her monthly household expenses in a spreadsheet. The data is organised as follows:
i. Calculate her total expenses by summing up the amounts for Rent, Groceries, Utilities, Entertainment, and
Miscellaneous.
ii. Calculate the remaining budget after deducting the total expenses from her total budget.
Applying Formula and Functions in Spreadsheet 237

