Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 63 - 2611_SmartGPT Pro V(5.0) C-5
P. 63

    3.  Write 'T' for true and 'F' for false.
                        a.  The X-axis is the horizontal axis of the chart, which is also called the category axis.

                        b.  In an Excel worksheet, text is aligned on the right side of a cell.

                        c.  Excel calculates expressions within parentheses (... , ...) first.

                        d.  The @ sign is used to form an absolute cell reference.

                        e.  =MINUTE(NOW()) will return minutes from a current time.

                     4.  Think and answer.
                        a.  What are gridlines in a chart?

                        b.  What do you mean by operators in Excel?

                        c.  What will be the final result of the following formula:

                            =((10+6)/SQRT(8))
                           ________________________________________________________________________________

                        d.  Explain any two rules for using functions in Excel.
                           ________________________________________________________________________________

                           ________________________________________________________________________________
                        e.   If cells A2 and A3 contain 10 and 20 values, respectively, then what will be the output of the
                            following function:
                            =IF(A2 > A3, "A2 is greater than A3", "A2 is not greater than A3")
                           ________________________________________________________________________________

                           ________________________________________________________________________________

                                                                                                    21 st
                     5.  Competency-based/Application-based questions.                            Century   #Critical Thinking
                        a.   Avi has created the following worksheet:                               Skills

                                                 Product        Sales Quantity      Price per Unit
                                                    A                100                 10
                                                    B                150                 20
                                                    C                 80                 30
                                                    D                200                 40
                              Now, he wants to calculate the total amount for each product. Which function of Excel will
                            help him to do so?

                                                                                     Charts, Formulas & Functions in Excel  61

| 58 59 60 61 62 63 64 65 66 67 68 |