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
   234   235   236   237   238   239   240   241   242   243   244