Identify each child's group using the divisions as given on the Workbook Data page (NOTE: you must use formulas/functions to accomplish this task. Apply a data bar conditional format Calculate each child's camp fees using the weekly rates provided on the data page and the number of weeks they will attend. Calculate the required Deposit amount using a Nested If formula and the amounts given on the Data page. Infant spaces require 25%, otherwise, if less than 4 weeks, 10%; and four or more pay 20% of the Total amount) Calculate the amount remaining to be paid (Total - Deposit)