Page 329 - TP_IT_V1.0_C9_flipbpookl
P. 329
5. If cell D5 contains the formula =$B5 + C$5 and this formula is copied to cell E6, what will be the copied formula in cell E6?
Ans. 1. 50 2. –35 3. =$B$5+D5 4. $B5+D5 5. =$B6 + D$5
SECTION B (Subjective Type Questions)
A. Short answer type questions.
1. What is cell referencing?
Ans. Using a cell address in a formula or a function is known as a cell reference.
2. How can a chart be inserted in a spreadsheet? Give steps.
Ans. We can insert charts in two different ways, which are as follows:
Select Insert → Chart option from the menu bar.
OR
Click the Insert Chart icon on the Standard toolbar.
The steps to create a chart are as follows:
i. Select the cell range for which a chart is to be inserted.
ii. Select Insert → Chart from the menu bar. It will open a Chart Wizard.
iii. Select the desired chart type. It will insert a chart and then you have a choice whether you want to finish the steps or
format it by following the next three tabs- Data Range, Data Series, Chart Elements.
iv. Click on the Finish button to close the Chart Wizard. A chart will be inserted.
3. In a spreadsheet software, the formula =A1+ $A$2 was entered in cell A3 and then copied into cell B3. What is the formula
copied into B3?
Ans. =B1+ $A$2
4. Name the cells included in the range reference A1:B2?
Ans. A1, A2, B1, B2
5. Identify the type of cell reference of the following cell address:
a. A$1
b. B10
c. $G$12
d. $H5
Ans. a. Mixed reference (Row number is absolute)
b. Relative reference
c. Absolute reference
d. Mixed reference (column name is absolute)
6. Can you include more than one mathematical operator in a single formula?
Ans. Yes, we can use many operators as we want in a single expression. For example =A1+B2-(10/C2)
7. How do formulas work in a spreadsheet?
Ans. Formulas in a spreadsheet use cell references, operators, and functions to perform calculations. For example: =A1+B1
8. What is an active cell? How do you delete the content of an active cell?
Ans. The currently selected cell in a spreadsheet is known as an active cell.
To delete the content, press the Delete key.
9. How can you edit the content of an active cell?
Ans. The steps to edit the content of the active cell are as follows:
i. Double-click on the active cell or press the F2 key.
ii. Change the content.
B. Long answer type questions.
1. Consider the given sheet and answer the following questions:
a. Write the formula to calculate the number of absentees in all the sections.
Electronic Spreadsheet 327

