Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started