How to Use the Weighted Average Formula in Excel

If someone asks me to find the average of five values — 1, 4, 7, 8, and 10 — the equation is easy. I add up all five values and divide this by the total number of values.