Functions and Chart Model Question Paper

11th Standard

    Reg.No. :
  •  
  •  
  •  
  •  
  •  
  •  

Computer Technology

Time : 01:30:00 Hrs
Total Marks : 40
    5 x 1 = 5
  1. The active sheet colour will be of which colour?

    (a)

    Grey

    (b)

    Green

    (c)

    White

    (d)

    Yellow

  2. Which command is used to show the hidden row in OpenOffice Calc?

    (a)

    Format → Row → Show

    (b)

    Format → Show → Row

    (c)

    Format→Display→Row

    (d)

    Format → Row → Display

  3. To make which cell address absolute we use sign?

    (a)

    Absolute

    (b)

    Relative

    (c)

    Comparative

    (d)

    Reference

  4. Which can be powerful way to convey information to the reader through a pictorial representation?

    (a)

    Charts and images

    (b)

    graphs and images

    (c)

    Charts and graphs

    (d)

    Images and Pictures

  5. What will be value returned by = DECIMAL (“16;”1101)

    (a)

    12

    (b)

    13

    (c)

    D

    (d)

    E

  6. 4 x 2 = 8
  7. How to select continuous and non-continuous sheets in OpenOffice Calc?

  8. Write the method to rename sheet.

  9. What is the use of freezing a sheet?

  10. What is Chart?

  11. 4 x 3 = 12
  12. Differentiate relative Cell addressing from absolute cell addressing

  13. What are functions in OpenOffice Calc?

  14. Write briefly about ASIN function in Open Office Calc.

  15. What is range? Give example.

  16. 3 x 5 = 15
  17. Create a Worksheet to contain student database with following fields.
    Rollno., Name, English, Tamil, Maths, Science, Social, Total, average.

  18. Explain how to format a worksheet

  19. How to use function in Open Office Calc? Explain with suitable example.

*****************************************

Reviews & Comments about 11th Standard Computer Technology - Functions and Chart Model Question Paper

Write your Comment