FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -A cell entry that consists of a number and numeric formatting only. The work area for entering and calculating data made up of columns and rows separated by grid lines (light gray lines). Also called a spreadsheet.

Detailed explanation-2: -You can use number formats to change the appearance of numbers, including dates and times, without changing the actual number. The number format does not affect the cell value that Excel uses to perform calculations. The actual value is displayed in the formula bar. Excel provides several built-in number formats.

Detailed explanation-3: -Auto Number Formatting By default, all worksheet cells are formatted with the General number format. With the General format, anything you type into the cell is usually left as-is. For example, if you type 36526 into a cell and then press ENTER, the cell contents are displayed as 36526.

Detailed explanation-4: -Microsoft Excel might show ##### in cells when a column isn’t wide enough to show all of the cell contents. Formulas that return dates and times as negative values can also show as #####.

Detailed explanation-5: -Use the COUNT function to get the number of entries in a number field that is in a range or array of numbers. For example, you can enter the following formula to count the numbers in the range A1:A20: =COUNT(A1:A20). In this example, if five of the cells in the range contain numbers, the result is 5.