Excel 2016 Introduction

Lesson – Creating Simple Formulas

Excel 2016

Function

Example

Description

Totals all the numbers in a range Returns the average of a range of numbers; if a cell in the range is empty, it is not used in calculating the average; if a cell in the range contains the number zero, it is used in calculating the average Returns the highest value in a range of numbers Returns the lowest value in a range of numbers Returns the number of cells in the range that contain numbers

SUM

=SUM(A1:A20)

AVERAGE

=AVERAGE(A1:A20)

MAX

=MAX(A1:A20)

MIN

=MIN(A1:A20)

COUNT NUMBERS

=COUNT(A1:A20)

After you type an = (equal sign) and the beginning letters of a formula, the Formula AutoComplete feature displays valid functions, names and text strings that match the letters in a dynamic drop-down list. You can refine the range of options by continuing to type trigger letters or scroll through the list using keys on the keyboard. As you navigate through the Formula AutoComplete drop-down list you will see detailed ScreenTips to help you make the best choice.

Using Formula AutoComplete

Page 108

OFFICEPRO, Inc.