Page 45 - ThinkGPT_V2.1_C7_Flipbook
P. 45

Excel 2016 is a powerful tool for storing and managing data. It allows you to use an Excel workbook
                 as a spreadsheet. A spreadsheet is a digital tool that organises data in a grid of rows and columns.
                 Each  box  in  the  grid  is called  a  cell  where  you  can  input  information. Common programmes for
                 spreadsheets include Microsoft Excel and Google Sheets.









                            Field







                          Record









                 You can use spreadsheets to perform calculations with formulae, create charts, and manage data
                 effectively.  They  are  useful  for  tasks  like  tracking  budgets,  organising  projects,  and  visualising
                 information.

                 Form in Excel

                 One of the most important features of Excel 2016 is form. A form is a window used to display or
                 enter a record in an Excel worksheet. It provides various controls like text box and buttons to enter
                 and update data. Before using an Excel file as database, you must ensure that every column has a
                 heading, as form uses these headings to enter or retrieve a record.
                 By  default,  Form  command  is  not  visible  on  the  ribbon.  To  view  the  Form  command,  follow  the
                 given steps:








                           1  Click on the File tab.






                                                                 2  Select the
                                                                Options option.








                                                                             Advanced Features of Excel 2016  43
   40   41   42   43   44   45   46   47   48   49   50