Introduction to Spreadsheet One Mark Questions

11th Standard

    Reg.No. :
  •  
  •  
  •  
  •  
  •  
  •  

Computer Technology

Time : 00:30:00 Hrs
Total Marks : 10
    10 x 1 = 10
  1. Which is the first electronic spreadsheet?

    (a)

    Excel

    (b)

    Lotus 1-2-3

    (c)

    Visicalc

    (d)

    Open Office Calc

  2. Which of the following applications is the parent to OpenOffice Calc?

    (a)

    Visicalc

    (b)

    LibreCalc

    (c)

    Lotus 123

    (d)

    Star Office Calc

  3. Grid of cells with a programmable calculator:

    (a)

    Spreadsheet

    (b)

    Database

    (c)

    Word processor

    (d)

    Linux

  4. A column heading in Calc is a

    (a)

    Number

    (b)

    Symbol

    (c)

    Date

    (d)

    Alphabet

  5. Which key is used to move the cell pointer in the forward direction within the worksheet?

    (a)

    Enter

    (b)

    Tab

    (c)

    Shift + Tab

    (d)

    Delete

  6. A formula in calc may begin with

    (a)

    =

    (b)

    +

    (c)

    -

    (d)

    All the above

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

    (a)

    7

    (b)

    25

    (c)

    10

    (d)

    52

  8. What will be the result of the following expression (Assume H1 = 12, H2 = 12)? = H1 <> H2

    (a)

    True

    (b)

    False

    (c)

    24

    (d)

    1212

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

    (a)

    +

    (b)

    %

    (c)

    &

    (d)

    $

  10. Which of the following key combination 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

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

Reviews & Comments about 11th Standard Computer Technology - Introduction to Spreadsheet One Mark Question with Answer Key

Write your Comment