Excel 2016 Introduction

Lesson – Creating Simple Formulas

Excel 2016

Steps

Practice Data

6. When you have finished creating the formula, press [Enter] . The result of the formula appears in the cell, and the colored borders of the referenced cells no longer appear.

Press [Enter]

Select cell B18 . Notice that the formula appears in the formula bar and the result of the formula appears in the cell. The result of the formula is 57578 . Now change the Total Sales for District 1 to 74500 . Notice that the formula recalculates the Net Profit in cell B18 to 67074 .

Practice the Concept: District 2 is projecting that expenses will be 8% of sales. To calculate the Expenses for District 2, select cell C17 and type an = (equal sign) to start the formula. Type C16*.08 to multiply the Total Sales for District 2 by 8%, and press [Enter] to complete the formula. The result should be 1472 . ( Note: You could have also typed =C16*8% .)

Now use the mouse to create a formula that calculates the Net Profit for District 2. Start by typing an equal sign ( = ) into cell C18 . Then, click cell C16 , type a minus sign (-) and click cell C17 . Finally, press [Enter] to complete the formula. The result should be 16928 .

U SING F UNCTIONS  D ISCUSSION

Excel has built-in functions that are shortcuts for formulas. Functions are special pre-written formulas that perform an operation on values or ranges of values and return the result to a cell in the worksheet. You can use functions to simplify and shorten formulas in your worksheets, especially those that perform lengthy or complex calculations. Examples of functions include:

=SUM(B5:B8) =AVERAGE(B5:B8) =PMT(.08,C8,85000) =ROUND(B5,2)

A function always starts with an equal sign ( = ) followed by the function's name and, enclosed in parentheses, its arguments. The function uses the arguments in its calculations. Arguments may be cell addresses, values, labels, or a combination of these; you can even use other functions or formulas as arguments.

Page 102

OFFICEPRO, Inc.