Formatting and Presentation: practice exercises
Practice turning raw numbers into a readable report. The tasks ask you to apply currency, percent and date formats, change fonts and fills, add borders, align text and set up conditional formatting that highlights what matters. Every exercise works on a small table and is checked automatically, so you see right away whether the cell really holds the format you intended. Good for anyone who sends spreadsheets to colleagues or clients and wants them to look tidy.
32 exercises · level: Beginner
Start with the first task Study the course: Formatting and Presentation →
Showing 32 of 32
Format and Style
Format the prices in B2:B6 as currency ($).
Show the markup in C2:C6 as a percentage.
D2:D6 shows "strange" numbers. They are dates: switch on the Date format.
In G1, calculate the average markup and show it as a percentage with one decimal place.
Make the headers in A1:D1 bold with a blue fill.
Center the quantities in B2:B5.
Add borders to the whole table A1:D6.
Format the total row A6:D6 with bold text and a yellow fill, and format the sum in D6 as currency.
Format the prices in B2:B6 as currency ($).
Show the discounts in C2:C6 as percentages.
D2:D6 holds day numbers. Switch on the Date format to see when each sale ends.
In E2:E6, build a line like "Armchair - $249 until 6/9/2026".
The amounts from the supplier in G2:G5 are stored as text. In H2:H5, turn them into numbers and apply the "0.00" format.
Conditional Formatting
Highlight sales over $100,000 in B2:B9.
Highlight the three highest growth rates in C2:C9.
Highlight negative growth (less than 0) in red in C2:C9. This rule is added to the previous one.
Highlight the duplicate emails in A2:A9.
In B2:B9, highlight every cell that contains "Lake" (cities and regions alike).
Highlight the entire rows in A2:D9 where the status is "Overdue".
Color the sales in B2:B9 with a red – yellow – green color scale.
Add data bars to the plan completion in C2:C9.
Mark the number of deals in D2:D9 with the "3 Arrows" icon set.
Highlight the requests that cost more than $500 in D2:D11.
In C2:C11, highlight all plumbing work (the word "plumb" anywhere in the text).
In B2:B11, highlight the apartments that have submitted more than one request.
Highlight the three longest-running requests in E2:E11.
Highlight the entire rows in A2:F11 where the priority is "Urgent" and the request has been open for more than 5 days.
Tables and Printing
In F2:F4, calculate each region's sales with SUBTOTAL and function number 9 (South is C2:C4, North is C5:C6, Central is C7:C10).
In F5, calculate the grand total for the whole sales column, also with SUBTOTAL.
In G2:G4, find the best rep result in each region (function number 4 is the maximum).
In H2:H4, calculate the average sales of each region (function number 1).
In I2:I4, calculate each region's share of the grand total and apply the percent format.
No exercises match these filters.