Page 273 - open office
P. 273
Section B
(Subjective Type Questions)
A . Answer the following questions.
1. Write the steps to hide a worksheet of workbook.
2. How will you add a new sheet in your workbook
3. What is cell address Explain with the help of an example.
4. Explain any two operations performed on data in a spreadsheet.
5. How do formulae work in a spreadsheet
6. ive the syntax and example of any three logical functions in spreadsheet.
. Write a short note on the list of errors that commonly occur in Calc along with the reason of their occurrence.
. Explain the following statistical functions:
i. MAX()
ii. AVERAGE()
iii. COU T()
. What do you mean by cell range Explain the different types of cell ranges.
B. Application based questions: L if e Sk il l s & V a l ues
1. A production company decides to keep its records in a computer so that the data can be handled easily. The
company is in search of software that will help to store large amount of data, perform
cal culations on that data and analyze the data to use the result for taking decisions. Which software would
preferably be used
2. Deepak wants to enter a value in the cell address formed by the intersection of the fifth column and ninth row.
Name the cell address.
Working with Spreadsheet 2 3

