Which is the first electronic Spreadsheet?

(a)

Excel

(b)

Lotus 1-2-3

(c)

Visicalc

(d)

OpenOffice Calc

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

(a)

Visicalc

(b)

LibreCalc

(c)

Lotus 123

(d)

StarOffice Calc

Grid of cells with a programmable calculator :

(a)

Spreadsheet

(b)

Database

(c)

Word processor

(d)

Linux

A column heading in Calc is represented using________.

(a)

Number

(b)

Symbol

(c)

Date

(d)

Alphabet

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

A formula in calc may begin with________.

(a)

=

(b)

+

(c)

-

(d)

All the above

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

(a)

7

(b)

25

(c)

10

(d)

52

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

(a)

True

(b)

False

(c)

24

(d)

1212

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

(a)

+

(b)

%

(c)

&

(d)

$

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

Ms-Excel introduced in the year_______.

(a)

1982

(b)

1985

(c)

1979

(d)

1987

Lotus 1-2-3 introduced in the year_______.

(a)

1985

(b)

1985

(c)

1979

(d)

1987

The first Electronic worksheet developed by_______.

(a)

Daniel Bricklin

(b)

Bob Frankston

(c)

William oughtred

(d)

(a) and (b)

Who referred as ' The Father of the Spreadsheet'?

(a)

Daniel Bricklin

(b)

Bob Frankston

(c)

William oughtred

(d)

Dennis Ritchie

Expansion of Visicalc is_______.

(a)

Vision calc

(b)

Vision calculator 

(c)

Visicalc calculator

(d)

Visible calc

Differentiate spreadsheet and worksheet.

What is cell address? Give example.

Define cell printer

How many navigation buttons in Calc sheet tab? Name them.

Differentiate Active cell and Home cell.

Write the classification of data types in Openoffice calc.

Write the three types of reference Operators?

Name the file type for the extension (i) .odt (ii) .ods (iii) . odp

Write the steps to Copy a formula from one cell to multiple cells.

Write the steps to insert a new column in a worksheet.

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

Explain how will you insert a function wizard.