Simple functions in MS Excel allow you to perform mathematical calculations on thousands of numbers instantly, a task that is much faster than using a calculator or working manually. These functions are essential for managing data in professional settings, such as calculating team salaries, tracking project tasks over many weeks, or displaying data through visual charts.
Locating Functions
To use simple functions like addition or finding an average, you must first locate the Auto-sum tool. This can be found in two places:
- The 'Formulas' tab in the menu bar at the top of the MS Excel screen.
- The $\Sigma$ (Sigma) sign located at the top right of the application.
Common Simple Functions
The sources highlight two primary functions for everyday calculations:
- SUM: This function adds the values of a specific range of cells. For example, the formula
=SUM(B1:B6)will add all the numbers contained in the cells from B1 to B6. This can be done for data arranged in a column (top to bottom) or a row (left to right). - AVERAGE: This function calculates the average value of the numbers in a chosen range. For instance,
=AVERAGE(B1:B6)will find the average price or value of the items listed in those specific cells.
Steps to Use Functions
According to the workbook, you should follow these steps to make a calculation:
- Enter your data into the worksheet cells.
- Select an empty cell directly below or to the side of your data where you want the answer to appear.
- Navigate to the ‘Formulas’ tab and click on ‘Auto-sum’.
- Choose the desired function (Sum or Average) from the dropdown menu.
- Excel will automatically sense the cells to be calculated; you can check the cell names (e.g., B1:B6) in the formula bar to ensure they are correct.
- Press the 'Enter' key on your keyboard to see the final answer.
Understanding Cell Names in Formulas
Every cell in Excel has a unique name based on its column letter and row number (for example, cell B5 is in column B and row 5). Knowing these names is critical because it helps you accurately define the range of data the function should use for its calculations.
Once your calculations are complete, remember to save your work using the keyboard shortcut Ctrl + S or print your results using Ctrl + P.