11th Standard EM - Computer Applications - Spreadsheet-Basics (OpenOffice Calc)

Buy 11th Computer Applications MCQ Online Test Practice test pack

Question - 1

Which is the first electronic spreadsheet?

  • A Excel
  • B Lotus 1-2-3
  • C Visicalc
  • D OpenOffice Calc

Question - 2

Which of the following applications was the parent to Open Office Calc?

  • A Visicalc
  • B LibreCalc
  • C Lotus 123
  • D StarOffice Calc

Question - 3

Grid of cells with a programmable calculator:

  • A Spreadsheet
  • B Database
  • C Word processor
  • D Linux

Question - 4

A column heading in Calc as a

  • A Number
  • B Symbol
  • C Date
  • D Alphabet

Question - 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

Question - 6

A formula in calc may begin with

  • A =
  • B +
  • C -
  • D All the above

Question - 7

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

  • A 7
  • B 25
  • C 10
  • D 52

Question - 8

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

  • A True
  • B False
  • C 24
  • D 1212

Question - 9

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

  • A +
  • B %
  • C &
  • D $

Question - 10

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