Page 45 - Dig_CodeAI_V2.1_Class_7
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

