Page 220 - CA 165 ver 1.0 Class 9
P. 220
3. Soumil is entering the formula 22/3 in the cell to find the quotient. But the result is not getting displayed.
What can be the problem?
4. Shyambhavi is applying absolute cell referencing using the formula = and A and 1 + 6. But she is not
getting the desired result, what could be wrong in this case?
5. What will Sameera do if she wants to join the content of two cells as shown below:
A1 contains the text ‘Be’
A3 contains the text ‘Happy’
She wants B4 to display ‘Be Happy’.
Ans. 1. =9/5*(B2+32), Relative Referencing
2. D2:E5
3. He needs to put ‘=’ sign before the formula.
4. She should use the $ sign instead of &.
5. She should write the formula =A1&A3 in B4.
Unsolved Exercise
PART A
A. Very short answer type questions.
1. Give formula to add content of cell A2 and A3.
2. What is the formula to divide the content of C4 by the product of content of cells A3 and A5.
3. How to find out minimum value out of the range B3: B7? Give formula.
4. What is the formula to find out the no. of employees whose salaries are given in the range D6:D30.
5. Write the formula to find out the value of 5 .
4
B. Case Based MCQs
Data can be easily displayed through charts in a spreadsheet package. Based on the same data, a user can easily
switch from one type of chart to another. The charts are always linked to the data they are depicting. If you
make any change in the data, it will be reflected in charts also.
1. .................................... charts help to compare how each value relates proportionally to the whole.
i. Bar ii. Pie
iii. Line iv. Area
2. Which among the following is a version of a line or column graph? It is useful to emphasize on volume of
changes of data.
i. X-Y Scatter ii. Bar
iii. Pie iv. None of these
3. Which among the following is not an advantage of chart?
i. It summarizes only small data set in visual form and estimates key value at a glance.
ii. Charts are visually appealing and it is easy for the users to compare the information.
iii. Charts help to forecast the trends on the basis of comparisons done.
iv. None of these
C. Fill in the blanks.
1. The addressing of a cell in a formula is called ..................................... .
2. ..................................... referencing is a way to apply formula in which the value of range of cells do not change
even if the formula is copied to a new cell.
218 Touchpad Computer Applications-IX

