Administration and Executive AssistantTier 145 minbeginner

Rounding and Number Formats

Display numbers honestly and understand the difference between display and actual value.

What you will learn

• Use ROUND, ROUNDUP, ROUNDDOWN with proper significant figures
• Apply number formats without changing the underlying value
• Understand ZAR formatting with 2 decimals
• Create custom formats for specific display needs

Excel skills

ROUND(), ROUNDUP(), ROUNDDOWN(), number formats, custom formats · Number Display

The task

Eighteen petty cash slips, each with an amount to the nearest thousandth of a rand because of how the card machine prints them. I need every line rounded to the nearest cent as it is captured, and a total that reconciles to the cent.

You work in a real spreadsheet in your browser, and your answer is checked against hidden traps the moment you submit.

Try this lesson free