Page 56 - TP_Plus_v4_Class4
P. 56

Take Off                                                           Century   #Critical Thinking
                                                                                                   21 st
                                                                                                  Skills
                    Look the given images a & b. Circle the number of oranges in 2015, apples in 2017 and total
                    fruits in 2016.

                    a.                                       b.




















                    In which image was it easier to find the numbers? Image 'a' is messy as data is not entered

                    properly whereas in image 'b' data is in a proper format and easier to search. This is called a
                    table and in Excel 2019 you can enter data like this easily.





              Let us now learn about the Excel 2019 and it's various features.


                   EXCEL 2019

              Microsoft Excel is the most versatile and widely used of all the Office applications.

              Excel is also known as an electronic spreadsheet. A spreadsheet can be defined as text and
              numbers that have been organized in rows and columns.

              Features of Excel 2019

              Excel has several features some of them are given below.

                  Excel has built-in formulas and functions to do calculations. You can also add formulas to
              your table and get quicker solutions.

                   The data can be formatted in many ways to change the look of the spreadsheet.
                   When we make a change at one place in a worksheet, the entire spreadsheet is automatically
                 recalculated as per the formulas entered.

                  It is very easy to search and replace figures in a spreadsheet with just one command.

                   Autofill feature is used to fill down series of numbers, dates and other data, create and use
                 custom lists.

                  You can easily format the data in charts and graphs with the click of a mouse.


                  54  PLUS (Ver. 4.0)-V
   51   52   53   54   55   56   57   58   59   60   61