WORKPLACE SKILLS · PRACTICAL GUIDE
Excel AVERAGE: Understand What a Blank Cell Changes
Enter 10 in A2 and 20 in A3, leaving A4 genuinely empty. You want the average of the available numeric entries.
The idea behind the exercise
AVERAGE ignores empty cells in a referenced range. An entered zero is a numeric observation and is included.
Practise Excel AVERAGE in a scratch workbook
Enter =AVERAGE(A2:A4), then put 0 in A4.
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
Do not substitute zero for unavailable data unless zero is its actual meaning. The choice changes both the data and the denominator.
Change one condition and test again
Replace the zero with 30. The average should now be 20; explain which three numbers were included.
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 Build a Job Description Skills Checklist Before Applying 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.