New ! Computer Applications MCQ Practise Tests



Spreadsheet-Basics Model Question Paper

11th Standard

    Reg.No. :
  •  
  •  
  •  
  •  
  •  
  •  

Computer Applications

Time : 01:00:00 Hrs
Total Marks : 50
    5 x 1 = 5
  1. Expansion of Visicalc is_______.

    (a)

    Vision calc

    (b)

    Vision calculator 

    (c)

    Visicalc calculator

    (d)

    Visible calc

  2. The main area of the Openoffice calc window is called_______.

    (a)

    Work area

    (b)

    Worksheet

    (c)

    Work space

    (d)

    All of these

  3. Which of the following shows the current cell address?

    (a)

    Name box

    (b)

    Input box

    (c)

    Cell box

    (d)

    Function button

  4. Spreadsheet window has ---------- sets of scroll bars

    (a)

    3

    (b)

    4

    (c)

    2

    (d)

    none

  5. Active sheet tab will appear in ------------  clear.

    (a)

    Green

    (b)

    Red

    (c)

    Purple

    (d)

    White

  6. 5 x 2 = 10
  7. What is cell address? Give example.

  8. Define cell printer

  9. How will you select multiple sheets in a worksheet?

  10. How calc calculates the results in a worksheet?

  11. Name the two types of cell references.

  12. 5 x 3 = 15
  13. Write the steps to construct a formula in a worksheet?

  14. Write the steps to save a worksheet.

  15. Write the steps to insert a new row in a in a worksheet?

  16. How will you insert cells, row and columns using "Insert cells" Toolbar.

  17. How the functions are categorized in Openoffice Calc?

  18. 4 x 5 = 20
  19. Explain the three types of default toolbars in OpenOffice Calc.

  20. Explain how will you cut, copy and Paste data in a worksheet.

  21. Explain how will you generate whole number series.

  22. Explain how will you insert a function using Direct Insert method.

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

Reviews & Comments about 11th Computer Applications - Spreadsheet-Basics Model Question Paper

Write your Comment