←Module 4
Lesson

Working with Functions

Learn how to use Excel functions including SUM, AVERAGE, COUNT, MAX, MIN, COUNTA, and NETWORKDAYS. Understand syntax, arguments, and how to insert functions using AutoSum and the Function Library.

Video

Watch the lesson video, then complete the reading and challenge.

Lesson Notes

Read through the key concepts before you try the challenge.

What Is a Function?

A function is a predefined formula that performs calculations using specific values in a particular order.

Excel includes many common functions that can quickly calculate totals, averages, counts, maximum values, and minimum values.

Basic SUM function example showing equals sign, function name, and argument

Understanding Function Syntax

Functions must follow proper syntax: an equals sign (=), the function name, and one or more arguments inside parentheses.

Example: =SUM(A1:A20)

Arguments can refer to individual cells or cell ranges. Multiple arguments are separated by commas.

AVERAGE function example with cell range argument

Using the AutoSum Command

The AutoSum command automatically inserts common functions such as SUM, AVERAGE, COUNT, MAX, and MIN.

AutoSum command dropdown on Ribbon

Select the cell that will contain the function, choose AutoSum, and Excel will automatically suggest a range.

SUM function inserted and calculated

You can also press Alt + = as a shortcut to quickly insert AutoSum.

Entering a Function Manually

If you know the function name, you can type it directly.

Click a cell, type =AVERAGE, and enter the range inside parentheses.

Typing AVERAGE function manually
Selecting range C3:C9 inside AVERAGE
AVERAGE result displayed

The Function Library

The Function Library on the Formulas tab organizes functions into categories such as Financial, Logical, Text, Date & Time, Lookup & Reference, and Math & Trig.

Formulas tab showing Function Library group
Function Library categories dropdown

Using COUNTA

COUNTA counts the number of non-empty cells in a range. Unlike COUNT, it counts text as well as numbers.

Selecting COUNTA from Function Library
Function Arguments dialog for COUNTA
COUNTA formula result

Using Insert Function & NETWORKDAYS

The Insert Function command allows you to search for functions using keywords.

Insert Function button
Insert Function search dialog

In this example, we use NETWORKDAYS to calculate business days between two dates.

NETWORKDAYS function arguments completed

Knowledge Check

Which function adds all values in the range A1:A10?

Practice File

Download this file and follow along with the lesson.

Functions Practice Workbook

Challenge

Apply what you've learned in this lesson.

Complete the following tasks using the practice workbook:

  1. Download the Functions practice workbook.
  2. Click the Challenge worksheet tab.
  3. In cell F3, insert a function to calculate the average of the four scores in cells B3:E3.
  4. Use the fill handle to copy the function from F3 to cells F4:F17.
  5. In cell B18, use AutoSum to calculate the lowest score in B3:B17.
  6. In cell B19, use the Function Library (More Functions > Statistical) to calculate the median of B3:B17.
  7. In cell B20, create a function to calculate the highest score in B3:B17.
  8. Copy the functions in B18:B20 across to C18:F20 using the fill handle.
Final practice result shown in worksheet
← Relative & Absolute Cell ReferencesModule 5: Working with Data →