Excel Fundamentals-2 hrs

Function Wizard Exercise

This is a preview lesson

Purchase this course, or sign in if you’re already enrolled, to take this lesson.

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


YouTube



Ad Free Version


Available in the paid for courses.

Our recommended course for you is:

Online Intermediate Excel Course


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

YouTube



Ad Free Version


Available in the paid for courses.

Our recommended course for you is:

Online Intermediate Excel Course

0 of 10 lessons complete (0%)
0
    0
    Your Cart
    Your cart is emptyReturn to Shop