$($

Time left $00$:$28$:$20$

$\backslash$table$[[,$A$,$B$,$C$,$D$,$E$,$F$],[1,$Glenn Lakes Golf Course,,,,$],[2,$Year $2000$ Revenues,,,,$],[3,,,,,,],[4,,$Qtr $1,$Qtr $2,$Qtr $3,$Qtr $4,$Annual$],[5,$Greens Fees,$420000,385000,227000,362000,],[6,$Golf Lessons,$98000,54800,61900,78200,],[7,$Pro Shop Sales,$55000,48600,35200,123400,],[8,,,,,,],[9,$Total Revenue,,,,,$]]$

Calculate annual totals for the three types of revenue.

Calculate the total revenue for the four quarters and for the year.

Format the Greens Fees and Total Revenue figures as currency style with a floating dollar sign, two decimal places.

Format the remaining figures as currency with two decimal places and no symbol.

Add a bottom border below the Pro Shop Sales figures and a double line border below the Total Revenue figures $($include row headings$).$

Merge and centre the title and subtitle $($Row $1$ and Row $2)$ across the width of the spreadsheet and apply the following formats: Row $1,$ apply a Heading $1$ Style $-$ Comic Sans MS$,24,$ Bold, Yellow font, Green fill. Row $2,$ apply Heading $2-$ Comic Sans MS$,16,$ Bold, Yellow font, Green fill.

Format the column heading fonts as follows: Centre, Bold, Baskerville Old Face, $18,$ Thick Bottom Border.

Format the row heading fonts as follows: Bold, Green, Baskerville Old Face, $14.$ Resize column A to best fit. $10.$ In cells A$11,$ A$12,$ and A$13,$ add the labels "Average", "Maximum", and "Minimum" respectively. Apply the same formatting as the other row labels.

Determine the above statistics for the four quarters ONLY. All stats should be in currency format with floating dollar signs.

Change the font of all figures to Baskerville Old Face $14.$

Switch to landscape orientation and add a custom footer that displays your name in the left section and "Glenn Lakes" in the right section.

I

$Hi$

Question

$BI{?}_{?}$