Page 273 - open office
P. 273

Section B
                                                        (Subjective Type Questions)
                 A .  Answer the following questions.

                     1.  Write the steps to hide a worksheet of workbook.
                     2.  How will you add a new sheet in your workbook
                     3.  What is cell address  Explain with the help of an example.
                     4.  Explain any two operations performed on data in a spreadsheet.

                     5.  How do formulae work in a spreadsheet
                     6.   ive the syntax and example of any three logical functions in spreadsheet.
                      .  Write a short note on the list of errors that commonly occur in  Calc  along with the reason of their occurrence.
                      .  Explain the following statistical functions:
                       i.  MAX()

                       ii.  AVERAGE()
                       iii.  COU T()
                      .  What do you mean by cell range  Explain the different types of cell ranges.

                 B.  Application based questions:                                                         L if e Sk il l s  &  V a l ues
                     1.  A production company decides to keep its records in a computer so that the data can be handled easily. The
                       company is in search of software that will help to store large amount of data, perform
                       cal culations on that data and analyze the data to use the result for taking decisions. Which software would
                       preferably be used
                     2.  Deepak wants to enter a value in the cell address formed by the intersection of the fifth column and ninth row.
                       Name the cell address.










































                                                                                     Working with Spreadsheet       2 3
   268   269   270   271   272   273   274   275   276   277   278