Question

how form is used to enter data

Answer 1

 a form is a dialogue box that provides an easy way to enter or display a complete row of information or record.it has text boxes to enter data in fields and command buttons to manipulate the data.

before adding a record in the form , the worksheet must have field name at the top of each column.Microsoft Excel uses this field names to enter the records in a form.form has the following features:

→it displays one record at a time.it can be used to add new records and change the existing records .

→any record can be deleted. it also helps to view the record, which matches with the specified criteria.

→In MS Excel 2007 forms are hidden .to find forms click on office button→ Excel options. click on the customize tab from the Excel options dialogue box. click on the drop-down list of choose commands from and click commands not in the Ribbon select form from the displayed list and click on ads click on OK and you will find the form button on the quick access toolbar.