Exercise 24. Page 236-238

Vocabulary

Absolute Reference Portfolio

Market Value

Exercise 25. Page 239

Vocabulary

IF Statement Logical Functions

Exercise 26. Page 240-241

Exercise 29. Page 245

Vocabulary

Primary Sort Secondary Sort

Questions

a) Explain each of the following functions including an example:

i) Average

After adding the data that you are to find the average for, create a formula that states the range of cells you would like to find the average for and write AVERAGE before it. e.g. =AVERAGE(d3 : d12)

ii) Maximum

Add the data you wish to compare into the desired cells and create the formula – =max(b3, b4, b5, b6) and the program will find the cell with the highest value(maximum).

iii) Minimum

Same as finding the maximum, create a formula that states =min( a1, a2, a3, a4, a5) and the program will calculate the lowest value of the selected cells.

b) How is an IF function set-up – what are the components? How does it work?

An IF function is created the same way as other functions but has different key components in calculating the proper function. e.g. =IF(A5>5, B5*16, 6). This IF function states that if the value in cell A5 is greater than 5, the value in cell B5 will be multiplied by 16 to equal the value in the cell that the IF function is entered. The last number before the bracket is the value if the original comparison is not true(If A5 is NOT greater than 5). This means that if A5=3 then instead of being multiplied by 16 it will be multiplied by 6. The syntax of this formula can be represented as(where logical test is the comparison of numbers.)

IF(logical_test, value_if_true, [value_if_false]) -office.microsoft.com

c) How do you copy a formula to a range of cells?

Highlight the cells by clicking one and holding shift and using the arrow keys to select the desired cells and copying the function into the box.

d) How is a sort performed?

Right click on a selected range of cells and under the sort menu will show a list of the possible ways to sort the data in the column(numerically, alphabetically, < – >, etc.).

****

## Feb 15

**1) Try: ** Exercise 24 page 236-238, Exercise 25 page 239, and Exercise 26 page 240-241, Exercise 29 page 245 **DO NOT PRINT ANY SPREADSHEETS even though the book asks you to print.**

These exercises demonstrate the use of functions beyond the SUM function. Answer the following questions in your notebook:

a) Explain each of the following functions including an example:

i) Average

ii) Maximum

iii) Minimum

iv) Count

b) How is an IF function setup – what are the components? How does it work?

c) How do you copy a formula to a range of cells?

d) How is a sort performed?