First of all you need to know what is a Record. Record is the single information of a complete data. You may call it as Cell Value in Excel. On the other hand Data is a complete information. And few data together makes a Data Table.
From this picture you will know about database, data and datum. A single information or value of a data is called datum. The complete information of a person or item is called data. And some data together makes a database.
How to enter Data?
To do this you need to create some records. To create a record just Click or Select a Cell and start typing from your key board as like as MS-Word. Not like MS-Access where you need to create field first, then specify the cell format. In MS-Excel you can work like MS-Word. Just click and type. Then if necessary you can format a cell as your choice.
On the other hand, you can copy a data table from another source and direct paste in Excel to create your data table in few moment.
You need not to create any field as like as you do in MS-Access. I have created Player and Score fields by Clicking on that cell and typing. After it you can play with this values like Fill Color, Bold, Cell Border etc as like as MS-Word.
How to edit a cell?
If you need to delete the values of a cell or you need to edit a cell, just Click on it and press Delete. If you need to edit few characters, then you need to Double Click on that specific Cell then a cursor will display into the cell or press F2 key. Then by pressing Delete or Backspace key you can delete the values of that cell. After entering the new value finally press Enter key to complete editing.
If you wish you can use a shortcut key from your keyboard instead of Double Click. And the shortcut button key is F2. It is very much helpful when there is a formula in a cell and you need to edit that cell. Then you need to press F2 instead of double clicking. Because Double Click will become complex at that time when there is a formula in your cell.
Image 1: Record, Data and Data Table
From this picture you will know about database, data and datum. A single information or value of a data is called datum. The complete information of a person or item is called data. And some data together makes a database.
How to enter Data?
To do this you need to create some records. To create a record just Click or Select a Cell and start typing from your key board as like as MS-Word. Not like MS-Access where you need to create field first, then specify the cell format. In MS-Excel you can work like MS-Word. Just click and type. Then if necessary you can format a cell as your choice.
On the other hand, you can copy a data table from another source and direct paste in Excel to create your data table in few moment.
You need not to create any field as like as you do in MS-Access. I have created Player and Score fields by Clicking on that cell and typing. After it you can play with this values like Fill Color, Bold, Cell Border etc as like as MS-Word.
How to edit a cell?
If you need to delete the values of a cell or you need to edit a cell, just Click on it and press Delete. If you need to edit few characters, then you need to Double Click on that specific Cell then a cursor will display into the cell or press F2 key. Then by pressing Delete or Backspace key you can delete the values of that cell. After entering the new value finally press Enter key to complete editing.
If you wish you can use a shortcut key from your keyboard instead of Double Click. And the shortcut button key is F2. It is very much helpful when there is a formula in a cell and you need to edit that cell. Then you need to press F2 instead of double clicking. Because Double Click will become complex at that time when there is a formula in your cell.
|||| Please SUBSCRIBE our YouTube Channel ||||
https://www.youtube.com/channel/UCIWaA5KCwZzBGwtmGIOFjQw
https://www.youtube.com/channel/UCIWaA5KCwZzBGwtmGIOFjQw