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

