Administration and Executive AssistantTier 920 minintermediate

EXPAND's pad_with Argument

Pad a partial year of figures out to a full 12-month template, with a real placeholder for what is missing.

What you will learn

• Use EXPAND to pad a range out to a fixed size
• Explain what EXPAND's pad_with argument controls
• Recognise that leaving it out returns #N/A for every padded slot, not a blank

Excel skills

EXPAND · Array Formulas

The task

Only 5 months of revenue have been reported so far this year. Build a template for all 12 months, marking every month not yet reported as "Pending" in Summary!B3.

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