Question

Please make an Excel Document for the listed information.

Annual Salary: $35,404.96
Monthly Salary: $2,950.41

Annual 10% (Savings): $3,540.49

Monthly Amount (Savings): $295.04

Monthly Payments:

Apartment - $850

Electricity - $47.08

Internet - $49.50

Phone - $98.88

Cable - $100.05

Student Loan - $710.86

Gym - $53.63

Netflix - $10.79

Spotify - $10.12

Food, Gas, Etc. - $350

New Car - $399.98

Insurance - $303.96

Amount Spent Monthly: $2,984.85

Amount Spent Annually: $35,818.20

Answer 1

FIRST OF ALL OPEN AN EXCEL DOCUMENT AND ENTER THE TITLES AND EXPENSES.

           YOU NEED TO ENTER THE MONTHLY SALARY AND OTHER EXPENSE AMOUNTS IN THE COLUMN

SELECT CELL B5 AND ENTER THE FORMULA =B4*10/100   AND PRESS ENTER TO DISPLAY THE 10% SAVINGS AUTOMATICALLY

SELECT CELL C4 AND ENTER THE FORMULA =B4*12       IN ORDER TO DISPLAY ANNUAL SALARY AUTOMATICALLY WHEN WE ENTER THE MONTHLY SALARY.

SELECT THE CELL C4 TO C 19 AND PRESS CTRL +D OR SELECT FILL > DOWN TO COPY THE FORMULA IN THE CELL C4 TO THE CELLS UP TO C 19. SO THAT MONTHLY SALARY, EXPENSE AND SAVINGS WILL AUTOMATICALLY CONVERTED TO YEARLY AMOUNTS.

SELECT CELL B19 AND ENTER FORMULA =SUM(B7:B18)           TO SUM ALL THE EXPENSES.

YOU CAN USE FILL COLOR TO COLOR THE CELLS ACCORDING TO YOUR DESIRE.