Question

How to create a database in Microsoft excel.

Answer 1

Answer:

How to create a customer database in Excel:

Enter the name of the database field (column headings).

Enter data into the database. We are keeping order in the format of the cells. ...

To use the database turn to tools «DATA».

Assign the name of the database. Select the range of data - from the first to the last cell.

Explanation:

follow me and Mark my answer as brainliest

Answer 2

Explanation:

1.Enter the name of the database field (column headings).

2.Enter the name.

3. Enter data into the database. We are keeping order in the format of the cells. If it is a numerical format so it should be the same numerical format in the entire column. Data are entered in the same way as in a simple table. If the data in a certain cell is the sum on the values of other cells, then create formula.

4.Enter data.

5.To use the database turn to tools «DATA».

DATA.

6.Assign the name of the database. Select the range of data - from the first to the last cell. Right mouse button - the name of the band. We give any name. Example - DB. Check that the range was correct.

Hope it helps

Pls mark me a brainliest