Loading
Nota de Estudos
Study Reminders
Support
Text Version

New Excel Functions - Learning Outcomes

Set your study reminders

We will email you at these times to remind you to study.
  • Monday

    -

    7am

    +

    Tuesday

    -

    7am

    +

    Wednesday

    -

    7am

    +

    Thursday

    -

    7am

    +

    Friday

    -

    7am

    +

    Saturday

    -

    7am

    +

    Sunday

    -

    7am

    +

Having completed this module, you will be able to:

Distinguish between the SORT and SORTBY functions.
Explain the purpose of RAND, RANDARRAY and RANDBETWEEN functions.
Define dynamic arrays.
List multiple functions used in the creation of management reports.
Describe the use of FILTER and SORT function to filter and sort data.
Outline the different lookup functions.