How do you present data from Excel to a non-technical audience?

The skill being tested is editing — deciding what to leave out.

• Lead with the conclusion. The first thing on the page should be what the data means and what you recommend, not the data itself. Detail supports the message; it does not replace it.
• One idea per chart. If a chart needs a paragraph to explain, split it. Title the chart with the finding — "North region drove 60% of Q3 growth" — rather than "Revenue by Region".
• Choose the right chart. Line for change over time, bar for comparison across categories, and avoid pie charts beyond a few slices. Skip 3D and heavy styling entirely.
• Format for reading. Round to a sensible precision — nobody needs four decimal places — use consistent units, and label directly rather than forcing a trip to a legend.
• Keep the detail available but separate. An appendix or a linked workbook for anyone who asks, so the main view stays clean.

Note: Mentioning that you state assumptions and data caveats up front is a strong point. A number presented without its assumptions gets challenged later, and by then trust in the whole analysis is damaged.