New ! Computer Applications MCQ Practise Tests



11th Standard Computer Applications Spreadsheet Basics (OpenOffice Calc) English Medium Free Online Test 1 Mark Questions 2020 - 2021

11th Standard

    Reg.No. :
  •  
  •  
  •  
  •  
  •  
  •  

Computer Applications

Time : 00:10:00 Hrs
Total Marks : 10

    Answer all the questions

    20 x 1 = 20
  1. Which is the first electronic Spreadsheet?

    (a)

    Excel

    (b)

    Lotus 1-2-3

    (c)

    Visicalc

    (d)

    OpenOffice Calc

  2. Grid of cells with a programmable calculator :

    (a)

    Spreadsheet

    (b)

    Database

    (c)

    Word processor

    (d)

    Linux

  3. What will be the result from the following formula (Assume A1=5, B2=2)? +A1^B2

    (a)

    7

    (b)

    25

    (c)

    10

    (d)

    52

  4. Which of the following symbol is used to make a cell address as an absolute reference?

    (a)

    +

    (b)

    %

    (c)

    &

    (d)

    $

  5. Which of the following is very useful automation tool for accounting purpose?

    (a)

    Word processor

    (b)

    Spreadsheet

    (c)

    Database

    (d)

    Presentation

  6. Ms-Excel introduced in the year_______.

    (a)

    1982

    (b)

    1985

    (c)

    1979

    (d)

    1987

  7. The first Electronic worksheet developed by_______.

    (a)

    Daniel Bricklin

    (b)

    Bob Frankston

    (c)

    William oughtred

    (d)

    (a) and (b)

  8. Expansion of Visicalc is_______.

    (a)

    Vision calc

    (b)

    Vision calculator 

    (c)

    Visicalc calculator

    (d)

    Visible calc

  9. How many worksheets are opened by default?

    (a)

    2

    (b)

    3

    (c)

    4

    (d)

    many

  10. In Open office calc, how many toolbars available by default?

    (a)

    2

    (b)

    3

    (c)

    4

    (d)

    only one

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

    (a)

    Name box

    (b)

    Input box

    (c)

    Cell box

    (d)

    Function button

  12. How many columns are there in Openoffice calc version 4.1.4?

    (a)

    256

    (b)

    16387

    (c)

    512

    (d)

    1024

  13. How many columns are there in MS-ExceI 2016?

    (a)

    1024

    (b)

    16384

    (c)

    1048576

    (d)

    none of these

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

    (a)

    Green

    (b)

    Red

    (c)

    Purple

    (d)

    White

  15. How many navigation buttons are there on the left sheet tab in the worksheet window?

    (a)

    3

    (b)

    2

    (c)

    4

    (d)

    6

  16. Which of the following selection mode(s) are available to select the cells of a worksheet?

    (a)

    S + D

    (b)

    E \(\times\) T

    (c)

    ADD

    (d)

    all of these

  17. The default zoon scale in_______.

    (a)

    25 %

    (b)

    75 %

    (c)

    50 %

    (d)

    100 %

  18. Which key is used to move the cell painter towards down?

    (a)

    Tab

    (b)

    Shift + Tab

    (c)

    Enter

    (d)

    Ctrl + Tab

  19. How many data types are Classified in a worksheet?

    (a)

    4

    (b)

    6

    (c)

    5

    (d)

    3

  20. By default in which side the characters are aligned in worksheet?

    (a)

    left

    (b)

    Right

    (c)

    Center

    (d)

    Justify

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

Reviews & Comments about 11th Standard Computer Applications Spreadsheet Basics (OpenOffice Calc) English Medium Free Online Test 1 Mark Questions 2020 - 2021

Write your Comment