Which is the first electronic spreadsheet?

(a)

Excel

(b)

Lotus 1-2-3

(c)

Visicalc

(d)

Open Office Calc

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

(a)

Visicalc

(b)

LibreCalc

(c)

Lotus 123

(d)

Star Office Calc

Grid of cells with a programmable calculator:

(a)

Spreadsheet

(b)

Database

(c)

Word processor

(d)

Linux

A column heading in Calc is a

(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 of the following formula (Assume A1 = 5, B2 = 2)? + A1 ^ B2

(a)

7

(b)

25

(c)

10

(d)

52

What will be the result of 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 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

What are the types of toolbars available in OpenOffice calc?

What is a Cell pointer?

Write the general syntax of constructing a formula in Calc.

What are the keyboard shortcuts to cut, copy and paste?

Can you edit the contents of a cell? If yes, explain any one of the method of editing the cell content.

Write a short note on OpenOffice Calc.

Write about inserting columns and rows in Calc.

Differentiate Deleting data using Backspace and Delete.

Write any three formatting options.

In cell A1 = 34, A2 = 65, A3 = 89 write the formula to find the average.

Explain about changing the column width in Calc.

Write the steps to generate the following series. 5, 10, 20 ….. 2560.

Read the following table

	A	B	C	D	E
1	Year	Chennai	Madurai	Tiruchi	Coimbatore
2	2012	1500	1250	1000	500
3	2013	1600	1000	950	350
4	2014	1900	1320	750	300
5	2015	1850	1415	820	200
6	2016	1950	1240	920	250

Above table shows the sales figures for “Air Cooler” sold in four major cities of Tamilnadu from the year 2012 to 2016. Based on this data, write the formula to calculate the following.
(1) Total sales in the year 2015.
(2) Total sales in Coimbatore from 2012 to 2016.
(3) Total sales in Madurai and Tiruchi during 2015 and 2016.
(4) Average sales in Chennai from 2012 to 2016
(5) In 2016, how many “Air Coolers” are sold in Chennai compared to Coimbatore?