New ! Computer Applications MCQ Practise Tests



11th Standard Computer Applications Spreadsheet Basics (OpenOffice Calc) English Medium Free Online Test 1 Mark Questions with Answer Key 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 of the following applications was the parent to Open Office Calc?

    (a)

    Visicalc

    (b)

    LibreCalc

    (c)

    Lotus 123

    (d)

    StarOffice Calc

  2. A column heading in Calc is represented using________.

    (a)

    Number

    (b)

    Symbol

    (c)

    Date

    (d)

    Alphabet

  3. A formula in calc may begin with________.

    (a)

    =

    (b)

    +

    (c)

    -

    (d)

    All the above

  4. Which of the following key combinations is used to increase the width of the current column?

    (a)

    Alt + Right arrow

    (b)

    Ctrl + Right arrow

    (c)

    Alt + Left arrow

    (d)

    Ctrl + Left arrow

  5. Which spread sheet software implement GUI?

    (a)

    Lotus 1-2-3

    (b)

    Visicalc

    (c)

    Ms - Excel

    (d)

    All of these

  6. Lotus 1-2-3 introduced in the year_______.

    (a)

    1985

    (b)

    1985

    (c)

    1979

    (d)

    1987

  7. Who referred as ' The Father of the Spreadsheet'?

    (a)

    Daniel Bricklin

    (b)

    Bob Frankston

    (c)

    William oughtred

    (d)

    Dennis Ritchie

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

    (a)

    Work area

    (b)

    Worksheet

    (c)

    Work space

    (d)

    All of these

  9. The default name for the first unsaved worksheet is_______.

    (a)

    untitled 1

    (b)

    Sheet 1

    (c)

    Table 1

    (d)

    document 1

  10. In which toolbar the function wizard icon is available?

    (a)

    Standard

    (b)

    Formatting

    (c)

    Formula

    (d)

    Object

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

    (a)

    3

    (b)

    4

    (c)

    2

    (d)

    none

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

    (a)

    1048576

    (b)

    65535

    (c)

    6189

    (d)

    548526

  13. Intersection of row and column is called_______.

    (a)

    Address

    (b)

    cell

    (c)

    pointer

    (d)

    Insertion point

  14. Which of the following is a rectangular element which can be moved around the worksheet?

    (a)

    Cell

    (b)

    Cell pointer

    (c)

    Address

    (d)

    Cell name

  15. How many selection available to select the cells of a worksheet?

    (a)

    3

    (b)

    4

    (c)

    2

    (d)

    1

  16. Which symbol indicates the worksheets are not yet saved?

    (a)

    +

    (b)

    @

    (c)

    *

    (d)

    /

  17. Active cell is identified by the_______.

    (a)

    Cell address

    (b)

    Cell pointer

    (c)

    Cell location

    (d)

    Selection Mode

  18. How many direction keys are used to move the cell pointer in worksheet?

    (a)

    3

    (b)

    4

    (c)

    6

    (d)

    none

  19. By default in which side the numbers are aligned in worksheet?

    (a)

    left

    (b)

    Right

    (c)

    Center

    (d)

    Justify

  20. By using which character the number is converted to text?

    (a)

    Double Quotes

    (b)

    Semi - colon

    (c)

    Colon

    (d)

    Single quote

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

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

Write your Comment