Page 306 - Trackpad IT-402_Class-IX
P. 306
13. How can one calculate the total of values entered in a worksheet column of? [NCERT]
a. By manual entry b. By auto-sum
c. By formula d. By sum function
Ans. 1. a. 2. b 3. d 4. a 5. a. 6. d 7. b 8. a 9. d 10. b 11. c 12. d 13. d.
B. Fill in the blanks.
1. A group of continuous cells selected with a mouse or keyboard is known as a .
2. consists of the tools used for formatting of the spreadsheet such as change of text colour, size, style, etc.
3. A represents the data in a pictorial form which is easy to read and understand.
4. / and ^ are examples of operators.
5. is the default chart in a spreadsheet.
Ans. 1. cell range 2. Formatting toolbar 3. chart 4. mathematical 5. Column Chart
C. State whether the following statements are true or false:
1. A cell is a combination of row and column. [NCERT]
2. All the formulae or functions in a spreadsheet should begin with an “=” sign.
3. =B4+B5 is an example of a function in a spreadsheet.
4. SUM() returns the count of the number of cells that contain numeric values.
5. A new row or column can be inserted from the Insert menu.
6. Semicolon (;) is used to separate the arguments in a function.
7. In a spreadsheet, we can change the column width and row height. [NCERT]
Ans. 1. False 2. True 3. False 4. False 5. True 6. True 7. True
SECTION B (Subjective Type Questions)
A. Short answer type questions:
1. What is cell referencing?
Ans. A cell address is a combination of a column name and a row number like A5, B12, H23, etc. Using a cell address in a formula
or a function is known as cell referencing.
2. How can a chart be inserted into a spreadsheet? Write the steps to be followed.
Ans. We can insert charts in two different ways – the Chart option in the Insert menu or the Chart icon on the Standard toolbar.
The steps to insert a chart are as follows:
i. Select the cell range for which a chart is required to be inserted.
ii. Select Insert menu → Charts. It will open a Chart Wizard dialog box.
iii. Select the Chart Type as Column .
vi. Click on Finish. It will close the dialog box and a column chart will be inserted.
3. Naina Sharma wants to store data of her monthly expenditure for a period of one year and also perform some calculation
and analysis. Which Office application will you suggest Naina for this purpose?
Ans. OpenOffice Calc
4. In spreadsheet software like OpenOffice Calc, the formula =A1+ $A$2 is entered in cell A3 and then copied to cell B3. What
formula will be copied to B3?
Ans. =B1+ $A$2
5. Name the cells that are included in the cell range A1:B2.
Ans. A1, A2, B1 and B2.
306 Trackpad Information Technology-IX

