MS Excel Tutorial and Function

What is the active cell?

Active cell is the bold outline and highlighted cell on our worksheet.

Function:

COUNT: In excel count function will count the cells which have got numeric values only and it will not count the empty cells and alphanumeric characters.

COUNTA: In excel COUNTA function will count all the cells except the empty cells.

Count Blank: In excel COUNTBLAK function    will count only the blank cells.

What are IF function?

Excel has a number of functions which allow us to evaluate values and makes decisions based on the result of the evaluation. The IF () FUNCTION is one of these.

Numbers & Date Formatting:

Number Formatting:

Open a worksheet called Number Function. Click on the down arrow next to the Number format control. You will see a drop down menu from which you can select the format. In this case select Number.

This tells Excel that the data contained within this cell should always now be treated as number, rather than say text or a date.

Decimal Point display:

Click on the C4. Click on the Decrease Decimal icon so that no decimal places are displayed. The cell contents should now look like this. Format this number to display no decimal places…. 194593    

Set the contents of cell C5 to display 1 decimal point

Set the contents of cell C6 to display. Click on the Increase Decimal icon.