# Spreadsheets Level 5: Capstone: build a working report (free quiz and certificate) | Get Certified for Free

Source: https://getcertifiedforfree.com/courses/spreadsheets/level-5/

Spreadsheets · Level 5 of 5 · Capstone

# Capstone: build a working report

Turn raw data into a clean, checked, shareable report.

## Study notes

1. Separate sheets for raw data, calculations, and the summary make reports easier to check.
1. Use data validation (drop-down lists, number limits) to stop bad entries at the source.
1. Conditional formatting highlights values that need attention, such as overdue dates or negative balances.
1. Charts should match the question: lines for trends over time, bars for comparing categories.
1. Check your work: totals that tie out, spot-checked rows, and no hard-coded numbers hidden inside formulas.

## Quiz: 6 questions

Choose one answer for each question, then check your answers. Score 5 of 6 to pass. Then enter your name and email to download a PDF certificate and have a copy emailed to you. Answers are graded in your browser.

About this certificate: Certificates are issued by Get Certified for Free for passing a free online knowledge quiz. They are not accredited, licensed, government, academic, or professional credentials and do not confer a license. [Read the full terms](https://getcertifiedforfree.com/about-our-certificates/).

[← Level 4: Lookups and pivot tables](https://getcertifiedforfree.com/courses/spreadsheets/level-4/) [Track certificate →](https://getcertifiedforfree.com/courses/spreadsheets/)