Microsoft Excel training notes - SchoolNet

Excel Solution. Type a 7-day average formula in E6 ( =average(C3:c9)) In F6, type the formula =C6/E6. Copy the formulas in E6 and F6 onto cells E7 to E27. Compute the average ratio for Day 1 (see formula in E12) Copy and paste the formula in E12 onto E13 to E18 to complete the indexes for Days 2 to 7 ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download