Reference no: EM133022554

Dance Studio - Excel Assignment

Purpose of the spreadsheet: You are owner of a dance studio and you want to calculate the fees for families attending. As of now, you've set the registration fee to $50 and the monthly tuition to $60, but, you want to be able to change those amounts and the amounts in the spreadsheet should adjust accordingly.

? The title in row 1 is using font Britannic bold, 20 point, with border set and it is in a merged cell

? Row 16 is a merged cell and filled with a color.

? Registration fee for a family is calculated as the number of students the family has enrolled multiplied by the registration fee (in cell C3)

? August Tuition is calculated as the number of students the family has enrolled multiplied by the monthly tuition (in cell C4

? August Total Due is the family's registration fee plus the August tuition.

? You must create the formulas in D8 and E8 and then copy them down to the cells below.

? You must use formulas for the values in rows 17 through 20. Row 17 shows totals of the columns. Row 18 displays the largest values, row 19 displays the average, and row 20 displays the total count of families (hint: use the COUNT function to count the the number of values in cells C8 through C15).

? Format the spreadsheet as shown. The values in the Registration, August Tuition and August Total Due columns are Accounting Number Format with 2 decimal places. Also, notice the cell borders and the wrapping and centering of the heading in row 7.