Page 307 - Trackpad IT-402_Class-IX
P. 307
6. Name the type of cell reference in each of the following.
a. A$1
b. B10
c. $G$12
d. $H5
e. H22
Ans. a. Mixed reference (Row number is absolute)
b. Relative Reference
c. Absolute Reference
d. Mixed reference (Column name is absolute)
e. Relative Reference
7. Give steps to insert a column in worksheet.
Ans. Step 1: Click on the left/right side of the existing column to which a new column has to be inserted in respective sides.
Step 2: Select the option ‘Columns’ from the ‘Insert’ menu.
8. What is an active cell? How to delete the contents of an active cell? [NCERT]
Ans. The selected or activated cell is referred to as active cell which is always highlighted, with a thick border. The address of
the active cell is displayed in the name box. To delete the content of an active cell, select the cell and right click and choose
delete cell.
9. Define Text orientation.
Ans. Text orientation option helps to rotate the direction of contents in a Cell. The user can either type the degree of angle of
rotation or drag the angle indicator and display the content in the required position.
B. Long answer type questions:
1. Identify the outputs in the following calculations in an OpenOffice Spreadsheet.
a. If C2=200, C3=300, C4=150, and C5=150, what will be the result of =average(C2:C5)?
b. If A2=35, what will be the result of =A2*2?
c. If C4=200 and D4=2, then what will be the output of =C4/D4+22?
Ans. a. 200
b. 70
c. 122
2. Considering the given worksheet and answer the following questions:
a. Delete the contents of cell E3 and write a formula to calculate the number of students absent in all the sections.
b. Calculate the total number of students in cell C9, the total number of students present in cell D9 and the total number
of students absent in cell E9.
c. Calculate the Present percentage in cell D10 and the Absent percentage in cell E10.
Ans. a. E3= C3-D3
Use the Auto Fill feature to copy this formula in the cells E4 to E8.
Electronic Spreadsheet 307

