Feb 15

1)  Try:  Exercise 24 page 236-238, Exercise 25 page 239, and Exercise 26 page 240-241, Exercise 29 page 245 

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

The Average function is used to find the average of a range of cells. To calculate the average of a range of cells, type “=” into the cell followed by “AVERAGE,” than select the data that you would like to find the average of by either clicking on the cells or typing in the cell location. ie: =AVERAGE(D6:D9)

ii)  Maximum

The Maximum function is used to find the maximum number in a fange of cells. To calculate the maximum number in a range of cells, type “=” followed by “MAXIMUM,” than select the data that you would like to find the maximum number of by either clicking on the cells or typing in the cell location. ie: =MAX(B7:B9)

iii)  Minimum

The Minimum function is used to find the minimum number in a range of cells. To calculate the minimum number in a range of cells, type “=” followed by “MINIMUM,” than select the data that you would like to find the minimum number of by either clicking on the cells or typing in the cell location. ie: =MIN(A1:A3)

iv)  Count

The Count function counts the number of cells in a range of cells and omits cells that are blank or that have text. To calculate the number of cells with data in a range of data, type “=” followed by “COUNT,” than select the data that you would like to find the number of cells with data.

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

The IF function tests to see whether a certain condition is true or false and than applies specific functions based on whether the information in the cell is true or false of the condition. The components of the If function include the logical test, value if true and value if false. The logical test is a value or expression that the user inputs so that it can be evaluated by the program to true or false. The value if true is the value that is returned if the logical test if true and if so applies the necessary function. The value if false is the value that is returned if the logical test is false and if so applies the necessary function. To use the IF function, type “=” followed by “If” function than type in a logical test, value if true and value if false. As well it is easy to access the IF function by going to the home tab, formula, logical and than the if function. There is a wizard that helps the user to create an effective If function. ie: Logical Test; C3>6, Value if True; B3*0.08, Value if False; B3*0.05. Hint: * is used for multiplication in spreadsheets.

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

To copy a formula to a range of cells, enter the formula and than drag the black box down to all of the cells that you would like the formula applied to. As well to copy a function to cells in other columns, click on the cell that you would like to copy the formula of, select the formula in the top bar and copy it, paste this formula in the desired cell.

d)  How is a sort performed?

To perform a sort, click on the home tab, and in the top right corner you will find the icon Sort & Filter. Click the data that you would like to sort and than the icon. Users can chose to sort their data from largest to smallest, smallest to largest, A to Z and Z to A. Custom sorts can also be completed by selecting custom sort in the Sort & Filter icon.

Advertisements

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