$20$:$16$

$\mathrm{.}1$ LTE $,$

Week$7\_-\_$Applied$\_$Activit...

Initial Instruction

Qtr $1$

$\backslash$table$[[$Quarter $1$ Total,,,$],[$Employee$\_$ID$,$Rate of Pay,Hours Worked,Gross Pay$],[$B$97$D$,53\mathrm{.}4,635\mathrm{.}56,33938\mathrm{.}904],[$F$78$P$,38\mathrm{.}8,556\mathrm{.}9,],[$S$26$J$,54\mathrm{.}2,523\mathrm{.}2,],[$N$88$C$,35\mathrm{.}7,611\mathrm{.}35,],[$C$90$H$,43\mathrm{.}9,586\mathrm{.}3,],[$M$78$W$,37\mathrm{.}6,647\mathrm{.}2,],[$C$959$R$,60,543\mathrm{.}9,],[$J$63$K$,45\mathrm{.}8,638\mathrm{.}2,],[$L$40$P$,47\mathrm{.}2,534\mathrm{.}2,],[$O$31$Q$,35\mathrm{.}8,572\mathrm{.}2,],[$Total$,,,],[$Maximum$,,,],[$Minimum$,,,],[$Average$,,,]]$

TASK TO PERFORM

$\backslash$table$[[1,|$Use GALLERY THEME on the workbook $(2)],[2,\backslash$table$[[$Merge Cells A$1$ through D$1$ and apply following formatting: $(8)],[$a$.$ Change the background colour of the cells to BLUE, ACCENT $5,$ Lighter $40\%$