Excel Absolute Referencing Absolute referencing helps multiply multiple values with a particular value. See the image shown below. The list 1 values are multiplied by 4, value of cell C3. In this case, we will use symbol $ in the formula. So we have to modify the formula for that after entering the formula press…
Read more
Excel Relative Referencing Relative referencing tells that you don’t need to type the formula separately for each calculation in a column or a row. See the image: Type the formula in the first cell D3 and press Enter key to get the result, then use the fill handle. The formula will change automatically in the…
Read more
Excel Fill Handle in Formulas In the image given below, we want to multiply the numbers in column B with 5, so we can type the formula such as =B3*5 for cell B3 and other cells of the column B, but this is not possible with long lists. In such cases, we use Fill handle…
Read more
Excel Creating Formulas In cell C5 enter the number 20, now in cell E5 type the formula: =C5+5 then press the Enter key. You will get the result. The formula says 5 is added to the value entered in the cell C5 as the value is 20 the result is 25. See the image: In…
Read more
Excel Fill Handle with Dates Fill handle can be used to fill dates in multiple cells. If you need to enter a complete month in worksheet, you don’t need to type each date separately. Just choose a cell, type the date and using fill handle carry it over other cells, Excel will enter the subsequent…
Read more
Excel Fill Handle with Text and Numbers Fill handle also works with cells containing both text and number. In this case, the text does not change but the number increases by one for every cell you select. See the images:
Excel Fill Handle with Text Fill handle works in a similar way with texts. It helps repeat the text to desired range of cells. See the images shown below: The text is selected and then copied to other cells using fill handle.
Excel Fill Handle The fill handle is a convenient Excel tool that is used to fill data with a specific pattern. You can extend a series of numbers, dates and text combinations to desired number of cells. To use fill handle bring the mouse cursor at right bottom corner of the cell it will change…
Read more
Using Sigma Button to calculate average in Excel Select the cell to display the result. In the Home tab click on the small arrow next to the Sigma button and left click on the Average option. You will see the image shown below. Then press the Enter key to get the result.
How to calculate average in Excel Select the cell to display the result e.g. cell C9 in the image shown below. Now type “=” sign in the cell and type “average” then type opening parenthesis. Now select the data, cells from C4 to C7 then press the Enter key to get the result.