Excel 2016 Introduction

Lesson – Creating Simple Formulas

Excel 2016

Steps

Practice Data

8. Release the mouse button.

Release the mouse button

The range is selected and appears in the Formula Bar , the cell, and the collapsed dialog box. 9. Click the Expand Dialog button. The Function Arguments dialog box expands, and the result of the formula appears in the lower half of the dialog box.

Click

10. Select OK .

Click

The Function Arguments dialog box closes, the formula appears in the Formula Bar , and the result of the formula appears in the cell.

The result in cell H5 should be 1842.333 . Notice the number of decimal places; Excel will display as many decimal places as the formula calculates and the column width allows, unless the cell is formatted to display a specific number of decimal places.

Practice the Concept: Select cell C11 and type an equal sign ( = ). Click the list arrow to the right of the AutoSum button on the Home ribbon and select the MAX function. Select cells C5:C8 , and hit Enter . The result should be 2195 .

E DITING F UNCTIONS  D ISCUSSION

The Function Arguments dialog box simplifies creating functions by clearly listing each necessary argument. You can also open the Function Arguments dialog box to edit the arguments of an existing function.

Page 114

OFFICEPRO, Inc.