Function Wizard Exercise

Function Wizard Exercise

As a simple example of the function wizard perform the following:

In your Function Wizard download, on the Exercise tab

Watch the video clip and/or read the text to understand what to do for this exercise


 


Text Instructions

In the yellow cell find a formula that will find the 2nd largest value in the list.

TIP:

Look in the Statistical Category at the items listed below. It is one of the ones on the screen (between HYPGEOM.DIST and LOGNORM.DIST). Look at the description for each one and choose the one that seems most appropriate.

Function-wizard-exercise-1

Solution

Watch the video clip explaining the solution

Back to: Excel Fundamentals-2 hrs > Function Wizard