MS Excel Functions and formulas

MS Excel Functions and formulas

Auto Sum and Logic Number in MS Excel

Automatically sum with alt and = keys

This short cut key instantly summarize an entire column or row “alt” &  “=”  (equals key)

Logic for number formatting keyboard shortcuts

This key format a number with any symbol like $, %,@crtl & shift & symbol u want to add ($, %,@)

Functions And Formulas in MS Excel

A formula performs calculations or other actions on the data in your worksheet. A function is a preset formula in Excel. It is important to understand the following information about functions and formulas. Basic Information A formula and a function always begins with an equal sign (=). The data Excel will use to calculate a function is enclosed in parentheses (). Formulas do not include parentheses.

When there is a comma (,) between cell references in a function, Excel uses each cell to perform the calculation. For example, the function =SUM (A1, A2, A3) is the same as the formula =A1+A2+A3.

When there is a colon (:) between cell references in a function, Excel uses the specified cells and all cells between them to perform the calculation. For example, the function =SUM (A1:A3) is the same as the formula =A1+A2+A3

The following instructions explain how to enter a formula: 1. Click on the cell where you want to enter a formula. This is where the answer will appear. In Figure 3, cell G5 has been selected.

  1. Type an equal sign (=) to begin the formula (See Figure 4). 3. Then type the formula (=C5+D5), (See Figure 4).
  2. Press Enter. The results of the calculation will appear in the selected cell (See Figure 5). 5. To view the formula, click the cell containing the formula and it will appear in the formula bar (See Figure 5)

Basic Functions

Function  =SUM(Cell From:Cell to)

Function  =AVERAGE(Cell From:Cell to)

Function – =MAX(Cell From:Cell to) to find the largest value in range

Function – =MIN(Cell From:Cell to) to find the smallest value in range

 

  

Leave a Reply

Your email address will not be published. Required fields are marked *