this is the question of Microsoft Excel in Management Information Systems (MIS)

Question

this is the question of Microsoft Excel in Management Information Systems (MIS) you gotta find just show in question. Thanks

Student Budget START 125% Insert Table Chart Text Shape Media Comment Sheet2 Sheet3 Sheett Your Name Budget Income Help from parents Part-time job 600 600 60 600600 600600 600 600 400 400 400800 400 400 400 400 600 3500 1500 3500 1500 Loans Total income 300 5000 400 350 40 100 100 0 Books Tuition 300 5000 400 400 400 350 350 350 100 40 200 350 400 400 40 Food 350 40 100 Rent Cable Utilities Phone Gas Total Expenses 40 100 40 100 30 30302020 2020 350 350350 40 100 40 100 40' 40, 40 100 20 40 40 40 75 40 40 40 75 Deficit or Surplus Maximum monthly expense Minimum monthly expense

Explanation / Answer

In the given scenario, rows are expressed in Alphabets and Columns are represented as Numeric

Total Expenses:

B18=SUM(B10:B17)

Extend the same formula to adjacent cells in order to calculate the total expenses of other months

Maximum monthly expenses:

B22=MAX(B18:J18)

Minimum monthly expenses:

B23=MIN(B18:J18)

Maximum expense month:

Let a new row is added with the name Maximum expense month

B24=LOOKUP(B22,B18:J18,B2:J2)

Minimum expense month:

Let a new row is added with the name Minimum expense month

B25=LOOKUP(B23,B18:J18,B2:J2)

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.