Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

J +/- Q1: Design the following table using MS-Excel. (Color, borders, fonts and Alignments) B E F G H Expenses Total Month Monthly Income Rent

image text in transcribed
J +/- Q1: Design the following table using MS-Excel. (Color, borders, fonts and Alignments) B E F G H Expenses Total Month Monthly Income Rent Elect. Water Internet Saving expenses Expenses Jan 850 350 50 35 30 300 3 4 Feb 750 350 50 30 30 300 5 Mar 800 350 45 25 30 300 6 Apr 800 350 55 30 30 300 7 Highest 8 Lowest 9 Average 10 Q2: Rename the work sheet to "Expenses" 23: In the columns B to I use the currency (US $ ) format. Q4: Calculate the Total Expenses. Q5: Calculate the Saving (=Income - Total Expenses) Q6: In column I use the IF formula to type Positive if the value of the saving is greater than or equal to zero and Negative if it is less than zero. 27: Calculate the Highest row. 08: Calculate the lowest row. 09: Calculate the average Row. Q10: Write your name inside cell (17)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Personal Finance A Practical Approach

Authors: Jane King, Mary Carey

1st Edition

0199668833, 9780199668830

More Books

Students also viewed these Finance questions