#### Introduction to Spreadsheet Model Question Paper

11th Standard

Reg.No. :
•
•
•
•
•
•

Computer Technology

Time : 01:30:00 Hrs
Total Marks : 40
9 x 1 = 9
1. Which is the first electronic spreadsheet?

(a)

Excel

(b)

Lotus 1-2-3

(c)

Visicalc

(d)

Open Office Calc

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

(a)

Visicalc

(b)

LibreCalc

(c)

Lotus 123

(d)

Star Office Calc

3. Grid of cells with a programmable calculator:

(a)

(b)

Database

(c)

Word processor

(d)

Linux

4. A column heading in Calc is 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 of the following expression (Assume H1 = 12, H2 = 12)? = H1 <> H2

(a)

True

(b)

False

(c)

24

(d)

1212

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

(a)

+

(b)

%

(c)

&

(d)

$9. 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 10. 6 x 2 = 12 11. What is a Cell pointer? 12. What are the keyboard shortcuts to cut, copy and paste? 13. What are the options available in “Insert Cells” dialog box? 14. Match the following A B (a) Cut, Copy and Paste (1) Absolute Cell (b) Cell pointer (2) Status bar (c) Selection Mode (3) Standard Toolbar (d)$A\$5   (4) Active cell
15. Define the following (i) Text Operator (ii) Rows and Columns of spreadsheet.

16. Differentiate between Copy -Paste and Cut-Paste.

17. 3 x 3 = 9
18. Write a short note on OpenOffice Calc.

19. Differentiate Deleting data using Backspace and Delete.

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

21. 2 x 5 = 10
22. Explain about changing the column width in Calc.

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