Page 235 - CA_165_V2.0_C9_Flipbook
P. 235
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)
4. What is the formula to find out the most costly item in the list?
i. =MAX(D4:D10) ii. =MAX(D4;D10)
iii. =MAX(F4:F10) iv. =MAX(F4;F10)
5. What is the data type for the field Item purchased?
i. Numeric ii. Alpha–Numeric
iii. Date/Time iv. Formula
Ans. 1. iii 2. ii 3. iii 4. i 5. i
Unsolved Exercise
SECTION A
(Objective Type Questions)
A. Multiple choice questions.
1. What is the correct syntax for absolute cell referencing in a formula?
i. A$1 ii. $A1
iii. $A$1 iv. A1
2. Which of the following formulas is used to represent 2 raised to the power of 3 (2³) in OpenOffice Calc?
i. =2*3 ii. =2/3
iii. =2^3 iv. =2+3
3. To sum up values from A1 to A5, which formula should be used?
i. =SUM(A1+A5) ii. =SUM(A1:A5)
iii. =TOTAL(A1:A5) iv. =ADD(A1:A5)
4. What does a #VALUE! error typically indicate in a cell formula?
i. Division by zero ii. Invalid cell reference
iii. Function does not exist iv. Wrong type of argument or operand is used.
5. Which of the following types of charts is used to show trends over time in OpenOffice Calc?
i. Pie Chart ii. Line Chart
iii. Bar Chart iv. Column Chart
6. Which feature in OpenOffice Calc temporarily hides rows of data that don’t meet specific criteria?
i. Sorting ii. Filtering
iii. Grouping iv. Pivot Table
Data Analysis 233

