Daily Archives: June 19, 2019

Knowing Basic Excel formulas and functions with examples

The basics of Excel formulas

Before providing the basic Excel formulas list, let’s define the key terms just to make sure we are on the same page. So, what do we call an Excel formula and Excel function?

  • Formula is an expression that calculates the value of a cell.For example, =A2+A2+A3+A4 is a formula that adds up the values in cells A2 to A4.
  • Function is a predefined formula already available in Excel. Functions perform specific calculations in a particular order based on the specified values, called arguments, or parameters.

Best Excel Formulas & Functions: You Need to Know

What is a formula?

It is the simplest form, a formula is an expression made up of cell addresses and arithmetic operators. Formulas can also be made up of discrete values i.e. =6*3. Excel evaluates the formula to a value. An example of a formula looks as follows.

=A2 * D2 / 2

Excel shortcuts Keys for Windows

Shortcut                     Description
Tab                                  Move to the next cell, to the right of the currently selected cell.
Ctrl+A                            Select all contents of a worksheet.
Ctrl+B                            Bold all cells in the highlighted section.
Ctrl+C                            Copy all cells in the highlighted section.
Ctrl+D                            Fill down. Fills the cell beneath with the contents of the selected cell. To fill more than one cell, select the source cell and press Ctrl+Shift+Down to select multiple cells. Then press Ctrl+D to fill them with the contents of the original cell.