Question: table [ [ , Emp 1 , Emp 2 , Emp 3 , Emp 4 , Emp 5 , Remarks ] , [ January

\table[[,Emp 1,Emp 2,Emp 3,Emp 4,Emp 5,Remarks],[January,1343,1265,1187,1654,2044,],[February,1543,1654,1654,2044,1545,],[March,1723,2044,2044,1545,2044,],[April,1546,1545,1545,1343,1545,],[May,1250,1546,1820,1543,1343,],[June,1545,1230,1620,1723,1250,]]
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 6000
Write "LOW" if total monthly expense is less than 6000
Using Conditional Formatting:
Change color to "RED" if any expense is greater than 1500
Change color to "GREEN" if any expense is less than 1300
 \table[[,Emp 1,Emp 2,Emp 3,Emp 4,Emp 5,Remarks],[January,1343,1265,1187,1654,2044,],[February,1543,1654,1654,2044,1545,],[March,1723,2044,2044,1545,2044,],[April,1546,1545,1545,1343,1545,],[May,1250,1546,1820,1543,1343,],[June,1545,1230,1620,1723,1250,]] Calculate the following by using

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!