Page 217 - CA 165 ver 1.0 Class 9
P. 217
Solved Exercise
PART A
A. Very short answer type questions.
1. Name the error displayed when we write =SIM in place of =SUM while applying the sum function.
2. Which feature helps arrange data in ascending or descending order?
3. Name the chart that uses lines to show information and change over a period of time.
4. Name the chart that represents data in horizontal columns.
5. What is a set of values which the user wants to plot in a chart called?
Ans. 1. #NAME 2. Sorting 3. Line Chart 4. Bar Chart 5. Data Series
B. Fill in the blanks.
1. ..................................... function produces the largest value from the given range of cells.
2. ..................................... is a symbol that performs certain mathematical or logical operations.
3. ..................................... is a quick and easy way to get required information from the subset of data in a range
of cells.
4. ..................................... helps to identify the plotted data series.
5. Cell referencing which is combination of absolute and relative referencing is called
..................................... referencing.
Ans. 1. MAX( ) 2. Operator 3. Filtering 4. Legend 5. Mixed
C. Case Based MCQs
You have to plan your birthday party. You decide to create a spreadsheet to keep track of party
expenses. Consider the following worksheet and answer the questions that follow:
1. In cells F4, what is the formula needed to calculate the cost of dinner plates.
i. =ROUND(D4;E4) ii. =MOD(D4;E4)
iii. =PRODUCT(D4;E4) iv. =POWER(D4;E5)
2. In cell F11, what is the formula that computes the total amount?
i. =SUM(F4;F10) ii. =SUM(F4:F10)
iii. =COUNT(F4:F10) iv. =SUM(D4:D10)
3. What is the formula to find out the item that costs the minimum out of all the items mentioned?
i. =MIN(D4;D10) ii. =MIN(E4:E10)
iii. =MIN(D4:D10) iv. =MIN(F4:F10)
Data Analysis 215

