Question: table [ [ , Emp 1 , Emp 2 , Emp 3 , Emp 4 , Emp 5 , Remarks ] , [ January
tableEmp Emp Emp Emp Emp RemarksJanuaryFebruaryMarchAprilMayJune
Calculate the following by using excel functions formulas
Total January Expense:
Highest Expense During March:
Using IF Function in Remarks:
Write "HIGH" if total monthly expense is greater than or equal to
Write "LOW" if total monthly expense is less than
Using Conditional Formatting:
Change color to "RED" if any expense is greater than
Change color to "GREEN" if any expense is less than
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
