To create your own workbook in Excel, you’ll have to enter data into cells. Worksheet cells can contain constant values and formulas.
In a worksheet, text is used to organize and identify the numerical information. By default, text is left-aligned in the cell.
Let’s select a cell by clicking on it. Notice that the mouse pointer becomes a cross when it’s over a cell.
Click on cell A2, type Months.
The word appears both in the formula bar and in the cell, but it has not yet been entered.
Observe the Cancel, Enter, and Edit Formula buttons located on the formula bar. They are used for data entry with the mouse. Press the Enter key.
The text is entered in cell A2, and cell A3 is now the active or selected, cell. The mode indicator returns to Ready. You can either click on cell or use the right-and up-arrow keys on your keyboard to select a cell.
Click on cell B2Type Sales and press the Enter key.
The text is entered in cell B2, and cell B3 is now active.
Enter the following information in the cells listed:
In cell C2: Expenses
in cell D2: Totals
on method you can use to correct an item after it’s been entered into a cell is to retype the entry and enter it again. The new entry replaces the old entry.
Select cell D2.Type profits and press the Enter key.
The word “profits” replaces the word “Totals”.
It is also possible to change an entry before you enter it into a cell.
In cell A4, type January. Click on the Advance button, and we’ll press the Escape key for you.
The text in the cell is erased by pressing the Escape key.
Pressing the Backspace key is another method for changing entries as you type.
In cell A3, type January. Press the Backspace key four times to erase “uary”. Press the Enter key. The text is entered into cell A3, and the active cell is now A4.
Enter the followings:
In cell A4: Feb, In cell A5: Mar,In cell A7: Totals
When you enter numbers into a cell, they are displayed as right-aligned by default.
In cell B3, type 120 press the Enter key.
The number is right-aligned in the cell. Now enter the following information in the cells listed:
Cell B4: 195, B5:230, C3:115, C4:100 and cell C5:125
Click here to go to Excel Basic
USING FORMULAS
Here in this lesson you will also learn how to use formulas in ms excel. First let's know what formulas are.
Formulas are instructions that you enter to perform calculations. You can create formulas by using numbers; however, it is preferable to construct formulas that refer to worksheet cells, because they will update automatically if you change numbers in the worksheet. In Excel, you create formulas by preceding the expression with an equal sign (=)
Let’s create a formula to add the numbers in cells B3, B4, and B5. If your computer has a numeric keypad, you can use the plus (+) key to speed up your typing.
Select cell B7,type=b3+b4+b5 and press the Enter key
Observe the current value in cell B7
Now we’ll change a value to see the effect on the formula results.
Select cell B3type 320 and press the Enter key
The result of the formula in cell b7 reflects the change.
Next, let’s enter a formula to calculate January’s profits by subtracting Expenses (C3) from Sales (B3).
In cell D3, enter the formula =b3-c4.
Now let’s enter the following formulas in the cells listed:
In cell D4:=b4-c4, In cell D5:=b5-c5,In cell C7:=c3+c4+c5,In cell D7:=d3+d4+d5
Keep in mind that Excel follows a specific sequence when it performs calculations. This is known as the order of operations:
Parentheses
Exponents
Multiplication and division
Addition and subtraction.
Next, we’ll add a formula for the April projection, which will calculate the Sales average for January and March.
Enter the following text into the worksheet:
In cell A9:Apr projIn cell B9:=(b3+b5)/2 now let’s complete the worksheet by entering the following formulas into the cells listed:
In cell C9:=(c3+c5)/2In cell D9:=(d3+d5)/2
To view the true contents of cell, select the cell and observe the formula bar. To display formulas rather than their results, choose Tools, Options, click on the view tab, and check Formulas in the Window Options box.
Select cell A1 This is an empty cell. By looking at the figures in the worksheet, you cannot tell the difference between raw numbers and calculation results. Select cell B2.
The formula bar contains a raw number, or a constant value. The number 320 is displayed in the formula bar and in the worksheet.Select cell B7
The formula bar contains a formula (=b3+b4+b5), and the worksheet displays the result (745).
Now, let’s learn how to clear the contents of a cell and use the Undo button.
Select cell A2. This cell contains the text “Months.” We don’t need this text in the worksheet. Press the Delete key. If you delete the contents of a cell, you can replace the contents by clicking on the Undo button. This will reverse your last action. Click on the Undo button. (You will now know how to create formulas by using cell references).
Social Plugin