" /> -->

#### Spreadsheet-Basics (OpenOffice Calc) Book Back Questions

11th Standard

Reg.No. :
•
•
•
•
•
•

Computer Applications

Time : 00:45:00 Hrs
Total Marks : 30
5 x 1 = 5
1. Which is the first electronic spreadsheet?

(a)

Excel

(b)

Lotus 1-2-3

(c)

Visicalc

(d)

OpenOffice Calc

2. Grid of cells with a programmable calculator:

(a)

(b)

Database

(c)

Word processor

(d)

Linux

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

(a)

7

(b)

25

(c)

10

(d)

52

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

(a)

+

(b)

%

(c)

&

(d)

\$

5. 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

6. 3 x 2 = 6
7. Write about the text operator in OpenOffice Calc.

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

9. Differentiate between Copy -Paste and Cut-Paste

10. 3 x 3 = 9
11. Write a short note on Open Office Calc.

12. Differentiate Deleting data using Backspace and Delete.

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

14. 2 x 5 = 10
15. Explain about changing the column width in Calc.

 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?