Entering data into the fields:
When entering in number values or character values into a cell, select the cell to enter in the value and then start typing in the numbers, characters or text string in it.
Notice the numbers are defaulted to the right hand side when entered, the characters are left justified and so are the text strings. If you want to change the alignment of the cells, then select the cell(s) that needs to be aligned, go to the home tab and click on one of the buttons in the align section to align the text to be left, centered or right justified.
Entering in formulas:
There are many ways to enter in formulas to cells. When entering in a formula into a cell, start by typing in an equal sign (=) and then enter in the first cell reference value. From there, an operand can be inserted and then enter in the second cellreference value and so on. For example, if we wanted to add two numbers together, the formula would be written out as the following:
=B8+B9
The answer would be 107 because we are adding 62 to 45.
You can use various sets of operands from +, -, *, and /. This comes in handy when manually calculating results. Also, it is good to use this way when just calculating a couple of numbers. If you have a giant list of numbers, then it is good idea to use a pre-defined formula. This can be done by clicking on the formulas tab. Select the highlighted cells you want to calculate with this formula. Then, click on the Insert Function icon which contains an fx picture. Select the type of formula that is needed and click on the o.k. button.
Select the function you want to use and click the o.k. button.
Insert your range of cells you want to add all up. This can be done by just selecting the range of cells in the spreadsheet.
Click on the o.k. button and the result is placed in the cell that contains this formula. If you notice in the Function Arguments window, in the Number1 field, there is a range of numbers. If you browse over to the right, it shows the list of all those values in between curly brackets. If you scroll down, on the left hand side, it state formula result. That is the total of all the values added together. Before clicking on the o.k. button, you can verify this is the correct amount.