Your first task will be to fill in the missing cancellation data in yellow cells in the "Renewal Variance - Illinois" sheet. You'll have to figure out how to write formulas to do this! 0 Before you begin working on this, you'll notice cells with red text in Row 21 of "Revenue Variance - Illinois". This is a row that "checks" whether or not the pieces of your variance analysis (including the cancellation piece you are building) total up to the correct revenue amount for Illinois (which is calculated in Row 19). If you fill in the yellow cells correctly, the values in Row 21 should become zeros, and the cells should turn green. (You'll learn how to do this sort of formatting of cells shortly.) When the cells go green, it means you've done this part correctly! o The data that is missing pertains to the number of cancelling customers in a given year (cells C13 and D13) and the average cancellation refund per cancelling customer (cells C14 and D14). Once these cells are populated with the correct numbers, the Total Cancellation Refund populates automatically in Row 15. o The best way to fill in this missing data will be formulas using SUMIF statements