Page 289 - Computer - 9(A&B)

8. What is the keyboard shortcut to move to next worksheet from current one?
9. What is the use of AutoFill?
10. What is the default style of alignment of numbers and text in Calc?
11. Name the three types of cell references.
12. What are data series?
13. Which chart component helps to recognise different data series?
14. What is a legend?

D. Short answer type questions.
1. How do you edit an existing entry of cell?
2. What are the steps to open an existing workbook in Calc?
3. What is the use of Wrap Text formatting on cells?

4. How do you set a cell’s content in the center of selected cell?
5. How do you insert a currency symbol in a worksheet?
6. What is the use of a formula in Calc?
7. What do you mean by formula? Give an example.
8. What do you mean by a function?
9. What is the difference between relative and absolute reference?
10. Explain the types of cell references in brief.
11. What is the difference between Bar and Column chart?

E. Long answer type questions.
1. Explain the components of Calc which help you to perform the basic functions of an electronic
spreadsheet.
2. How do you change font size and colour of a cell’s content in Calc?

3. What is the difference between:
a. Text data and Numbers data b. Chart Area and Plot Area
4. What do you understand by charts? Explain the benefi ts of using charts.
5. What is a spreadsheet? Briefl y discuss any four major features of a spreadsheet program.

6. Why do we use absolute and mixed referencing when relative referencing works well and is so useful?

Experiential Learning
DIY in the LabIY in the Lab
D Experiential Learning
v Take a phone bill issued by a mobile company which shows the amount charged under the various call
rates as applicable and the total bill amount after adding various taxes, as applicable. Design the same in
Calc using formulas and functions such that the bill amount is calculated automatically once you enter the
usage under the various heads.
v Open Calc and enter the following data in it:

Students English Hindi Maths Total Marks Percentage
Piya 98 97 98
Riya 67 76 56
Kavita 69 78 98
Neha 79 78 45

151
151