The Job Tests

WORKPLACE SKILLS · PRACTICAL GUIDE

Excel MIN and MAX: Find the Ends of a Small Range

Enter 18, 7, 24 and 11 in A2:A5. You want the smallest and largest numeric entries without rearranging the rows.

The idea behind the exercise

MIN and MAX return numeric endpoints; they do not identify the label or record associated with the endpoint.

Practise Excel MIN and MAX in a scratch workbook

Enter =MIN(A2:A5) in C2 and =MAX(A2:A5) in C3.

Use a separate practice sheet rather than changing an important workbook. Keep the stated inputs visible and label the result cell. Predict the result before checking Excel so that the exercise tests your understanding instead of your ability to copy instructions.

A mistake to check

If you also need a person's name or product code, finding the numeric endpoint alone does not retrieve that linked information.

Change one condition and test again

Add a duplicate maximum. The result stays the same, so decide separately how you would handle tied records.

Write one sentence explaining why the result changed or stayed the same. If it differs from your prediction, inspect the entered values, the formula or selected range and the rule you intended to use. Change one thing at a time so the cause of the difference remains visible.

Version and locale notes

Examples use English function names and commas between arguments. Your regional settings may use semicolons, different decimal or date formats, or localised function names. Menu wording and feature availability can differ by Excel version; consult the provider documentation for your installation.

For provider documentation and related feature details, visit Microsoft Excel Support. The dataset and practice steps in this article are original examples from The Job Tests.

Continue with Create a Skills Inventory with Evidence, Not Just Adjectives for an earlier guide in this series.

Original educational content by The Job Tests, operated by Sasflynet Kft. No diagnosis, certification or hiring outcome is promised.

Put this guide into practice

Excel intermediate practice · Choose a free seven-day path