Functions and Chart Model Question Paper

11th Standard

    Reg.No. :
  •  
  •  
  •  
  •  
  •  
  •  

Computer Technology

Time : 01:00:00 Hrs
Total Marks : 50
    5 x 1 = 5
  1. To select multiple continuous sheet which key is used?

    (a)

    Ctrl

    (b)

    Shift

    (c)

    Alt

    (d)

    tab

  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. If cell A5 contains value 18, then if (A26<5; “True”, “False”) will return

    (a)

    True

    (b)

    False

    (c)

    Blasse

    (d)

    Error

  5. 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

  6. 5 x 2 = 10
  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 are the types of Cell addressing?

  11. What is Chart?

  12. 5 x 3 = 15
  13. Differentiate relative Cell addressing from absolute cell addressing

  14. What are functions in OpenOffice Calc?

  15. How to hide/show rows and columns in sheet?

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

  17. What is range? Give example.

  18. 4 x 5 = 20
  19. Create a Worksheet to contain student database with following fields.
    Rollno., Name, English, Tamil, Maths, Science, Social, Total, average.

  20. Explain how to format worksheet.

  21. Discuss in detail about steps to create chart in OpenOffice calc.

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

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

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

Write your Comment