Feb 15

Exercise 24. Page 236-238

stock

Vocabulary
Absolute Reference          Portfolio
Market Value

Exercise 25. Page 239

Capture

Vocabulary
IF Statement           Logical Functions

Exercise 26. Page 240-241

INVOICEA

Exercise 29. Page 245

State – Alphabetical
STATE

State 1 – Sales <
STAT12

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?

Advertisements
This entry was posted in Uncategorized. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s