Page 231 - CA_165_V2.0_C9_Flipbook
P. 231
Solved Exercise
SECTION A
(Objective Type Questions)
A. Multiple choice questions.
1. To create an absolute cell referencing, a sign that is put before the row number and column name in the
cell address is:
i. $ ii. +
iii. = iv. None of these
2. A chart that represents the data or value of each item in proportion or percentage to the sum value of all
items:
i. Column Chart ii. Bar Chart
iii. Pie Chart iv. Line Chart
3. The set of values that the user wants to plot in the chart is:
i. Data Series ii. Data range
iii. Chart Elements iv. None of these
4. This option filters data according to specific value or string:
i. Autofilter ii. Standard Filter
iii. Advanced Filter iv. None of these
5. Which of the following errors occurs when an invalid numeric value is used in a formula or function?
i. #VALUE! ii. #REF!
iii. #DIV/0! iv. #NUM!
6. Which of the following is a built-in function to calculate the average of values in OpenOffice Calc?
i. Median() ii. AVG()
iii. AVERAGE() iv. AVER()
Ans. 1. i. 2. iii. 3. i. 4. ii. 5. iv. 6. iii.
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
Data Analysis 229

