4.3. Providing FormulasUsing basic

functions/formalism of a cell

Sum

Average

Percentage

BASIC FUNCTIONS

Parts of a function

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

Parts of a Function

–Equal Sign–Function Name–Argument

Equal sign–basic syntax to create a formula with a function

Argument–contain the information you

want the formula to calculate, such as a range of cell references

– must be enclosed in parentheses. Individual values or cell references inside the parentheses are separated by either colons or commas.

>Colons create a reference to a range of cells. >Commas separate individual values, cell references,

and cell ranges in parentheses. If there is more than one argument, you must separate each argument by a comma.

Argument (cont.)

Parts of a Function

Setting up a FormulaSum, Average and

Percentage

Getting the SumThere are two ways to get the sum:

1. Use Auto Sum2. Use a formulaa. All datab. Selected data

1. Use of Auto Sum

2.a. Use of Formula (All Data)

2.a. Use of Formula (Selected Data)

Getting the AverageThere are two ways to get the average:1. Use Average feature of the spreadsheet2. Use Formulaa. Shortcutb. Manual

1. Use of Average feature

2.a. Use of formula (shortcut)

2.a. Use of formula (manual)

Example:

Answer:

PercentageTo show a number as a percent in Excel:1. Apply the percentage number format.2. Select the cells that need formatting3. Click the Percent Style button in

the Number group on the ribbon’s Home tab.  

                              

Calculating Percentage

The basic formula for calculating a percentage is:

part/total = percentage

In Discounts: (for example) reduce a particular amount by 25% (Think of the 1 in the formula as a stand-in for 100%.)

Calculating Percentage (cont.)

To increase the amount by 25%, replace the minus sign in the formula with a plus sign.

Calculating Percentage (cont.)

Example:Say the earnings for your department are $2,342 in November and $2,500 in December. What is the percentage change in earnings between these two months?

Answer:Divide the difference between December and November earnings ($158) by the value of the November earning ($2,342).

Activity:Days Quantity (KG) Items bought

MONDAY 116

238

MangoRambutanLanzonesDalandan

TUESDAY 21341

DalandanMango

LanzonesRambutan

WEDNESDAY 636

MangoDalandanLanzones

THURSDAY 113

RambutanMango

FRIDAY 1692

LanzonesRambutanDalandan

Fruit Price per Kilo

Dalandan 40

Rambutan 50

Mango 95

Lanzones 150

Joe owns a mini fruit stand which sells seasonal fruits. Given the list of all his sales each day in his first week and the price list of each of the fruit he sells, find:1. His total sales at the end of the week2. Change in percentage of his sales each

day3. Average sales for each day of the week

THANK YOU!

cjmfjarito (MAEd-Math)EM201