For this part of the assignment browse through all worksheets before attempting the question.

Using the Microsoft excel workbook assgt$\_$mgmt$1000\_$open$\_$s$3\_24.$xls complete the questions

below to provide solutions for the directors and board members of Gaya Group of Companies,

regarding their financial reporting requirements:

a$.$ Using the $"2022$ Quarterly Revenue" worksheet provide the relevant formulas to

complete the worksheet.

b$.$ In the same worksheet in part $($a$)$ dynamically apply the following formats for Qtr$1$

through Qtr$4$ for all revenue types:

i$.$ Values over $$75,000$ should be blue and bolded

ii$.$ Values under or equals to $$25,000$ should be red and italicized