Administration and Executive AssistantTier 040 minbeginner

Entering Data So Excel Understands It

Format your input so Excel recognizes numbers, dates, and formulas correctly.

What you will learn

• Distinguish between text, numbers, and formulas by leading character
• Format negative numbers visibly
• Use leading apostrophes when needed
• Understand why "01/02/2026" is ambiguous in South Africa

Excel skills

Cell formatting, data types, entry prefixes · Data Entry

The task

Someone typed up twenty orders by hand and the totals column will not work. I need Column E filled in, and I need the two summary figures on the Summary tab: total quantity and grand total value.

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