One Sample Z Test - Summary Statistics (workaround) using Data Analysis in Excel

How to perform a one-sample Z-test for mean hypothesis testing using Excel's Data Analysis, even when only summary data is available: Creating dummy data, generating the output, and interpreting the results.