Page 36 - iPro_trackGPT_V5_Class8
P. 36

A cell range refers to a group of cells selected together in a worksheet.
                        A cell reference is the address of a cell that you can use in a formula to show a specific
                        cell.

                        Functions are built-in formulas in Excel used for performing both simple and complex
                        calculations.
                        A chart is a graphical representation of data designed to make information easier to
                        understand and analyse.
                        Sorting means arranging data in a certain order, like ascending (from smallest to largest)
                        or descending (from largest to smallest) order.






                      Tech Trivia                                                               Section A (Objective)




                  A.  Tick ( ) the correct option.

                      1.  If the range includes cells from C4 to E10, then it is written as ...........................

                         a. C4;E10                                      b. C4:E10

                         c. C4,E10                                      d. C4 to E10

                      2.  Which function returns the remainder after a number is divided by the divisor?

                         a. ABS                                         b. SQRT

                         c. MOD                                         d. ROUND

                      3.  Which function returns the length of the text string?

                         a. LEN                                         b. LENGTH

                         c. WID                                         d. WIDTH

                      4.  What is the default name of a worksheet in Excel?

                         a. Sheet1                                      b. Worksheet1

                         c. Untitled1                                   d. Workbook1

                      5.  Which chart is divided into slices, with each slice showing how big a value is compared to
                         the whole chart?

                         a. Bar Chart                                   b. Column Chart

                         c. Line Chart                                  d. Pie Chart





                    34    TrackGPT iPRO (V5.0)-VIII
   31   32   33   34   35   36   37   38   39   40   41