#### Spreadsheet-Basics Basics (OpenOffice Calc) - Important Question Paper

11th Standard

Reg.No. :
•
•
•
•
•
•

Computer Applications

Time : 01:00:00 Hrs
Total Marks : 50

Part A

15 x 1 = 15
1. Which is the first electronic spreadsheet?

(a)

Excel

(b)

Lotus 1-2-3

(c)

Visicalc

(d)

OpenOffice Calc

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

(a)

Visicalc

(b)

LibreCalc

(c)

Lotus 123

(d)

StarOffice Calc

3. Grid of cells with a programmable calculator:

(a)

(b)

Database

(c)

Word processor

(d)

Linux

4. A column heading in Calc as 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 from the following formula (Assume A1=5, B2=2)? +A1^B2

(a)

7

(b)

25

(c)

10

(d)

52

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

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

(a)

+

(b)

%

(c)

&

(d)

\$

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

11. Ms-Excel introduced in the year

(a)

1982

(b)

1985

(c)

1979

(d)

1987

12. Lotus 1-2-3 introduced in the year

(a)

1985

(b)

1985

(c)

1979

(d)

1987

13. The first Electronic worksheet developed by

(a)

Daniel Bricklin

(b)

Bob Frankston

(c)

William oughtred

(d)

(a) and (b)

14. Who referred as ' The Father of the Spreadsheet'?

(a)

Daniel Bricklin

(b)

Bob Frankston

(c)

William oughtred

(d)

Dennis Ritchie

15. Expansion of Visicalc is

(a)

Vision calc

(b)

Vision calculator

(c)

Visicalc calculator

(d)

Visible calc

16. Part B

Answer all the Two Mark Questions

5 x 2 = 10

18. What is cell address? Give example.

19. Define cell printer

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

21. Differentiate Active cell and Home cell.

22. Part C

Answer all the Three Mark Questions

5 x 3 = 15
23. Write the classification of data types in Openoffice calc.

24. Write the three types of reference Operators?

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

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

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

28. Part D

Answer all the Five  Mark Questions

2 x 5 = 10
29. Explain how will you insert a function using Direct Insert method.

30. Explain how will you insert a function wizard.