Page 288 - Computer - 9(A&B)

12. An absolute reference has a ______________ sign along with the column letter
and row number in the cell.
* $ ? ^
13. Arjun has entered values in cell B1 down to cell B15. He gives cell range B3: B10 in a formula. How
many values are left out of the range?
7 5 15 22
14. Neha mentions a cell range as A1: C5. How many cells are in the range?
5 3 15 25
15. Which of the following are often mentioned only as text type in a spreadsheet?
Data Labels Functions Formula
16. When values are changed in the cells, the result of calculations update according to the changes– This
is an advantage related to which of the following?
Functions Formula Charts None of these
17. Namita has prepared a list of 2000 employees. Now she needs to give therm serial number from 1 to
2000. Which is the quickest way to do this?
Formula Fill handle Copy-paste =Count()
18. Arjun is calculating the percentage of 100 students out of fi ve subject with maximum marks 500. The
value 500 is in a cell B2. Which of the following is the best suited referencing to access the value 500
in the formula for all the students?
Relative Absolute Mixed Any of these
19. Jawahar has stored the formula = B5 + B6 in cell A1. He copied the formula in cell B1. The changed
formula will look like:
=B6 + B7 =C5 + C6 =C6 + C7 =B5 + B6
20. In absolute cell referencing, which of the following remains fi xed?
Row Column Both of these None of these
B. Fill in the blanks.

1. A spreadsheet is a collection of _________________ and _________________.
2. A rectangular block formed by the intersection of a row and a column is called _______________.
3. Clac is a _________________ software package.
4. _________________, _________________ or _________________ can be the type of function arguments.
5. A formula can be copied using _________________.
6. _________________ function is used to fi nd the square root of a cell value.
7. A formula consisting _________________ performs automatic recalculations.
8. _________________ charts display data in the form of a vertical bars.
9. _________________ helps to identify colors, patterns, symbols assigned to data series.

C. Very short answer type questions.
1. What is the use of LibreOffi ce Calc?

2. What is active cell?
3. How do you select the complete row?
4. What are the different types of values used in Calc worksheet?
5. How can you insert a new worksheet in a workbook?
6. How do you enter the data into an active cell using the formula bar?
7. What is AutoSum?

150
150