Basic HTML Version

|  | Table of Contents |  | View Full Version

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

    When you press the Enter key, the current date appears          Date Function
                     in the cell.

                     We can also give the reference of a cell containing the
                     date to the MONTH() function. Similarly, we can use
                     the YEAR() and DAY() functions to get the year and

                     day from a date respectively.
                                                                                              Using TODAY function

                                              a.  Which chart type is circular in shape?

                                                  ____________________________________________________
                             uiz   Bee        b.  Which chart type is also known as XY scatter plot chart?

                                                  ____________________________________________________

                                                               Self Reflection            21 st  Century   #Initiative
                                                                                              Skills
                                                                                                  #Leadership & Responsibility
                        Your neighbour has been preparing a list of grocery items with their prices. She has been
                                                               Self Reflection
                        manually calculating the total amount. Do you think you should help people whenever you
                        see an opportunity?

                            Hashtag

                          #Chart: Displays data in a pictorial form
                          #Text: Defines the information on the spreadsheet

                          REVISIT

                       ▶  A cell reference is a cell address that can be used in a formula to denote a specific cell.
                       ▶   In relative reference, you actually refer to cell that is above or below and left or right to a
                         number of rows or columns.

                       ▶   If you wish to maintain the original references as they were, then you should make use of
                         the absolute references.
                       ▶   A mixed reference is a reference that refers to a specific row or column.
                       ▶   Functions are predefined formulas in Excel to perform both simple and complex
                         calculations.

                                                                                     Charts, Formulas & Functions in Excel  59

| 56 57 58 59 60 61 62 63 64 65 66 |