Cells in Excel are referred to using relative or absolute references. A formula with relative references changes when the cell's position does. If, for example, a cell has a formula "=A1" and you ...

Common examples of Excel functions include SUM, AVERAGE, and MIN. More advanced common Excel functions include using VLOOKUP to find specific data, and using IF to make a conditional formula.

Mark Coppock/Digital Trends Using the Concatenate function to merge cells in Microsoft Excel Sometimes we want to take two columns and merge them into one, keeping the information from both columns.