Page 36 - 2502_Pakistan-kifayat_C-8
P. 36

#Microsoft Excel




               Chapter 3




                #Chapter Profile
                    Introduction to Spreadsheet Software                  Microsoft Excel
                    Starting Excel                                        Exploring the Excel Interface
                    Basic Skills in Excel                                 Formatting and Adjusting Data
                    Using Built-in Functions                              Creating and Using Formulas
                    Order of Operation                                    Charts for Data Presentation





                             Take Off                                                           Century   #Critical Thinking
                                                                                                  21 st
                                                                                                  Skills
                    Look at the given images a and 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.






              In our daily lives and at work, we often need to do different types of calculations. We use various
              methods based on the kind of calculations we need to perform. Mathematical or statistical analysis,
              long calculations, comparisons between different data sets, graphical representation of data, etc., are
              the tasks that produce useful information and provide proper data to help decision-making. Such tasks,
              if done manually, prove to be tedious and time-consuming.
   31   32   33   34   35   36   37   38   39   40   41