Linden Cycle Works needs a five-week report covering repairs and accessory revenue. The fictional table has different weekly targets, so overall performance needs a ratio of totals. Keep every headline tied to the same five weeks, and keep the source table visible for someone checking the numbers.
This practice set uses only tools from the reporting and earlier units. It mixes formulas, range names, protection, and charts. Decide what each chart should answer before choosing a type. A scorecard displays one headline; a combo chart compares weekly revenue with the weekly target.
Each task starts from a fresh copy. For menu tasks, check the selected range and series rather than relying on the chart editor's automatic guess. Protection should match the requested editing rule, since a warning can still allow an accidental overwrite.