FinanceTier 1010 minbeginner

Underline for a Subtotal Break

Underline the last figure before a total, the standard accounting 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 financial statement

Excel skills

Underline · Cell Formatting

The task

This revenue statement has six months of figures and a total. Underline the last figure before the total (B7), the standard accounting signal that everything above it was added together.

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