Page 291 - open office
P. 291

6.  If we move a cell containing a formula having reference to another cell in the worksheet, what will happen to
                       the cell numbers used in the formula?
                       i.  The cell row and column are changed at destination.
                       ii.  The cell row changes at destination.
                       iii.  The cell columns are changed at destination.

                       iv.  No change will occur.

                 B.  Fill in the blanks.
                     1.  Data present in the cell can be customized or formatted using ................................. option.

                     2.  Alignments can also be applied by using shortcut buttons from the ................................. bar.
                     3.  ................................. a cell includes changing the contents of a cell with respect to appearance.

                     4.  Arithmetic and  eometric progression can be created and inserted automatically using .................................
                       feature.
                     5.  ................................. is a visual graphical representation of data from a worksheet that is very useful for instant
                       analysis of data and decision-making.
                     6.  ................................. helps to rotate the direction of contents in a cell.

                                                                Section B
                                                        (Subjective Type Questions)

                 A .  Answer the following questions:

                     1.  Write the steps to insert a chart in Calc.                                       [CBSE Handbook]
                     2.  Explain any two operations performed on data in a spreadsheet.

                     3.  How do formulae work in a spreadsheet?
                     4.  List various horizontal alignment options.

                     5.  What are the steps to format a cell to hold time?
                     6.  What are the steps to format font of cell content in a worksheet?

                     7.  What feature will you use to create a Numeric data series? Explain this feature?
                     8.  Explain Data Series.

                     9.  Write down the steps to create a Custom List.
                    10.  Explain the horizontal alignment option: Filled.

                    11.  Explain  Shrink to fit cell size .

                 B.  Application based questions:                                                         L if e Sk il l s  &  V a l ues
                     1.  Sahil has made a spreadsheet for the marks obtained by the students of his class in different subjects. Which
                       feature should he use to keep the marksheet updated if he has to change marks in one of the subjects for any
                       student?
                     2.  ABC is a grocery shop. If the owner of the shop wants to compare profit per commodity sold and  et profit,
                       which chart type would you suggest?







                                                                                Formatting Cells in Spreadsheet     291
   286   287   288   289   290   291   292   293   294   295   296