Page 206 - IT 402 v2.0 class 10
P. 206

5.   utosum automatically selects the value around the cells either ............................. or ............................. .
         Ans.  r o w w is e ,   c o l u m n w is e

            .  It contains same types of data :
                a    able                                   b    olumn
                c    ow                                     d   None of these
          ns.   b
            .   xplain any five types of charts available in spreadsheet.
         Ans.  Types of Charts:

              1 .   Line Ch art: I t   is   u s e d   t o   s h o w   t r e n d s   o ve r   a   p e r io d   o f   t im e .   I t   is   s im il a r   t o   p l o t t in g   a   g r a p h   o n   a   g r a p h   p a p e r
                 w it h   it s   va l u e s   o n   X   a n d   Y   a xis .   I t   u s e s   c o n n e c t in g   d o t s   t o   d is p l a y   t r e n d s   o ve r   a   p e r io d   o f   t im e .


















              2 .   Column Ch art: I t   is   u s u a l l y   u s e d   t o   d is p l a y   t h e   d a t a   in   t h e   f o r m   o f   ve r t ic a l   b a r s .   I t   is   u s e d   t o   s h o w   t h e   c h a n g e s
                 in   d a t a   o ve r   a   p e r io d   o f   t im e   o r   c o m p a r is o n   a m o n g   t h e   d if f e r e n t   d a t a   it e m s .   T h e   c a t e g o r ie s   a r e   r e p r e s e n t e d
                 o n   t h e   h o r iz o n t a l   a xis   a n d   t h e   va l u e s   a r e   r e p r e s e n t e d   o n   t h e   ve r t ic a l   a xis .


















              3 .   Pie Ch art: I t   is   a   c ir c u l a r   c h a r t   d ivid e d   in t o   s e c t o r s   w h e r e   e a c h   s e c t o r   s h o w s   t h e   r e l a t ive   s iz e   o f   e a c h   va l u e .   I t

                 a l w a y s   s h o w s   o n l y   o n e   d a t a   s e r ie s .   I t   is   u s e f u l   w h e n   y o u   w a n t   t o   e m p h a s is   o n   a   s ig n if ic a n t   e l e m e n t .

























         204       Touchpad Information Technology-X
   201   202   203   204   205   206   207   208   209   210   211