Transcript

Instructions

  1. In your category sheet (genre, actors, or directors), create a column for average ROI.
  2. Use an array formula to calculate the average ROI for the first item in your category.
  3. Copy the Average If array formula.
  4. Change the number format to percent.
namespaces/google.engedu.apski/contents/Activity-267779883308138484424289400431381096789en