To select multiple continuous sheet which key is used?

(a)

Ctrl

(b)

Shift

(c)

Alt

(d)

tab

Which command is used to show the hidden row in OpenOffice Calc?

(a)

Format → Row → Show

(b)

Format → Show → Row

(c)

Format→ Display → Row

(d)

Format → Row → Display

To make which cell address absolute we use sign?

(a)

Absolute

(b)

Relative

(c)

Comparative

(d)

Reference

If cell A5 contains value 18, then if (A26 < 5; “True”, “False”) will return

(a)

True

(b)

False

(c)

Blasse

(d)

Error

Which can be powerful way to convey information to the reader through a pictorial representation?

(a)

Charts and images

(b)

graphs and images

(c)

Charts and graphs

(d)

Images and Pictures

How to select continuous and non-continuous sheets in OpenOffice Calc?

Write the method to rename sheet.

What is the use of freezing a sheet?

What are the types of Cell addressing?

What is Chart?

Differentiate relative Cell addressing from absolute cell addressing

What are functions in OpenOffice Calc?

How to hide/show rows and columns in sheet?

Write briefly about ASIN function in Open Office Calc.

What is range? Give example.

Create a Worksheet to contain student database with following fields.
Rollno., Name, English, Tamil, Maths, Science, Social, Total, average.

Explain how to format a worksheet

Discuss in detail the steps to create chart in OpenOffice calc.

How to use function in Open Office Calc? Explain with suitable example.