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
   230   231   232   233   234   235   236   237   238   239   240