Administration and Executive AssistantTier 1010 minbeginner

Underline for a Subtotal Break

Underline the last figure before a total, the standard signal that a calculation starts there.

What you will learn

• Apply underline formatting to a specific cell
• Explain the accounting convention of underlining the last value summed, not the total itself
• Recognise where a calculation break needs marking in a real report

Excel skills

Underline · Cell Formatting

The task

A sales column ends with a Total row. Underline the last month's figure - the row directly above the total - to signal where the calculation starts, the way a printed ledger would. Leave the total itself as it is.

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