Application Assignment Samantha Tester

Samantha Tester Expected Yearly Budget: Excel Appl January February March April Rent 450 450 450 450 Groceries 145 100 150 145 Social 50 150 50 100 Bills 100 150 100 150 Savings 150 100 100 75 Et cetera 75 100 60 80 Total =SUM(B3:B8) =SUM(C3:C8) =SUM(D3:D8) =SUM(E3:E8) If total of month is greather than $1,000, highlighted in blue Minimum =MIN(B3:B8) =MIN(C3:C8) =MIN(D3:D8) =MIN(E3:E8)

May 450 160 60 100 50 95 =SUM(F3:F8)

=MIN(F3:F8) =MIN(G3:G8)

Expected Yearly Budget 10000 9000

8000 7000 6000 5000 4000 3000 2000 1000 0

Rent

Groceries

Social

Bills

Savings

Et cetera

June 450 150 50 150 100 40 =SUM(G3:G8)

Total

arly Budget: Excel Application Assignment July 450 200 100 100 50 110 =SUM(H3:H8)

August 450 100 30 150 95 8500 =SUM(I3:I8)

September 450 150 100 100 75 25 =SUM(J3:J8)

October 450 175 150 150 45 50 =SUM(K3:K8)

=MIN(H3:H8) =MIN(I3:I8) =MIN(J3:J8) =MIN(K3:K8)

November 450 200 150 100 50 50 =SUM(L3:L8)

December 450 200 300 150 50 50 =SUM(M3:M8)

=MIN(L3:L8) =MIN(M3:M8)

Average =AVERAGE(B3:M3) =AVERAGE(B4:M4) =AVERAGE(B5:M5) =AVERAGE(B6:M6) =AVERAGE(B7:M7) =AVERAGE(B8:M8)