Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 37 - 2615_KEC
P. 37

    EXCEL 2021—AN                                                                            CHAPTER

                     INTRODUCTION                                                                            A4

                        Learning outcomes

                        The student will be able to:
                           understand the basics of Excel 2021 and its key components.
                           learn how to create, open, save and close a workbook.
                           enter, format and organize data efficiently in a worksheet.
                           work with multiple worksheets by adding, renaming and deleting them.
                           use Excel 2021 for calculations, sorting and analysing data.

                     A spreadsheet is a computer application program for organising, calculating and
                     sorting data in a tabular form. It comprises a set of rows and columns that form a grid.
                     In other words, it is a table of data arranged in horizontal rows and vertical columns.

                               EXCEL 2021

                     Excel  2021 is  very popular  electronic  spreadsheet  application  that  is  used  to  perform
                     calculations and manage data. An Excel file, which can contain many worksheets, is called
                     a workbook.

                               USES OF EXCEL 2021

                     Let us discuss the uses of Excel 2021.
                       Used for Computing  Numbers: Excel 2021  is a powerful application  for  computing
                       numeric data. You can use Excel to perform mathematical calculations like calculating
                       the sum, averages of your total marks, etc.

                       Organising and Sorting Data: Excel 2021 is good at organising data in a row-and-column
                       format. Once the data is entered, you can perform various sorting operations to control
                       how the data is listed.
                       Storing and Analysing data: You can store data into numerous individual worksheets
                       and analyse it accordingly.

                        Sharing Data: Excel 2021 allows users to share data with other users. You can import
                       data from other resources like Microsoft Word and export data into other file formats.

                                                                                             Excel 2021—An Introduction  35

| 32 33 34 35 36 37 38 39 40 41 42 |