Excel Practice

Formatting practice

Communicate amounts, shares and dates clearly without changing their stored values.

Lesson 84 of 92 · 4 exercises

Practise Formatting

What you will practise

Currency adds a dollar sign and two decimal places while preserving numeric values.

Format → range → number format or conditional rule

Open Format values above the worksheet. Read the task, select the requested range and apply the operation to see its actual effect.

First exercise example

Range D2:D8; USD currency 2 decimals; Apply format.

This example uses the original practice data. Fresh data changes the records; follow the current task.

4 exercises in this lesson

  1. Exercise 1

    Format D2:D8 as US dollars with exactly two decimal places.

  2. Exercise 2

    Format E2:E8 as percentages with one decimal place.

  3. Exercise 3

    Format F2:F8 using the YYYY-MM-DD date format.

  4. Exercise 4

    Add a conditional highlight to D2:D8 for values strictly greater than 100.

Before you check your answer

  • Select the precise range. Use the labelled range field for the requested cells, without including headings or unrelated values.
  • Change presentation. USD currency uses two decimals, Percent uses one decimal, and Date displays YYYY-MM-DD. The stored values stay intact.
  • Read the rule boundary. Conditional highlight compares each numeric value with the threshold. Greater than excludes a value equal to that threshold.

How the answer is checked

Apply changes the worksheet; it does not mark an exercise complete. Choose Check worksheet to check the actual operations against the requested configuration and resulting rows, formats, selection, summary or chart. Valid equivalent workflows can pass. Invented source values or a claimed final result cannot replace the operation. Account progress is saved only after the server verifies the same task and access rules.

Use progressive hints when you need help, then try the task again with fresh data. Correctly solving a step opens the next exercise.