Shelly Cashman Excel 2019 | Module 1: Textbook Project

SETH GRAHAM
Textbook

SUBMISSION #1 | SCORE IS: 81 OUT OF 100 GE ver. 10.0.0-rc0000

1. Non-graded - Project: Real Estate Budget Worksheet and Chart

2. Non-graded - Starting and Using Excel
3. Non-graded - Selecting a Cell
4. Entering Text
To Enter the Worksheet Titles 4/4
To Enter Column Titles 4/4
To Enter Row Titles 0/4
In the Monthly Finances worksheet, cell A4 should contain the text "Commission".
5. Entering Numbers
To Enter Numbers 4/4
6. Calculating Sums and Using Formulas
To Sum a Column of Numbers 4/4
7. Using the Fill Handle to Copy a Cell to Adjacent Cells
To Copy a Cell to Adjacent Cells in a Row 4/4
To Calculate Multiple Totals at the Same Time 4/4
8. Calculating Average, Maximum, and Minimum Values
To Enter a Formula Using the Keyboard 4/4
To Copy a Cell to Adjacent Cells in a Row Using the Fill Handle 4/4
9. Non-graded - Saving the Project
10. Formatting the Worksheet
To Change a Cell Style 4/4
To Change the Font 5/5
To Apply Bold Style to a Cell 5/5
To Increase the Font Size of a Cell Entry 5/5
To Change the Font Color of a Cell Entry 5/5
To Center Cell Entries across Columns by Merging Cells 5/5
To Format Rows Using Cell Styles 0/5
In the Monthly Finances worksheet, cell A19 should be formatted using the Accent6 cell style.
To Format Numbers in the Worksheet 5/5
To Adjust the Column Width 5/5
11. Adding a Pie Chart to the Worksheet
To Apply a Style to a Chart 0/5
In the Monthly Expense Chart worksheet, the pie chart should be formatted using the Style 6 chart style.

12. Changing the Sheet Tab Names and Colors

To Move a Chart to a New Sheet 5/5
To Change the Sheet Tab Name and Color 5/5
13. Non-graded - Document Properties
14. Printing a Worksheet
To Preview and Print a Worksheet in Landscape Orientation 0/5
The Monthly Finances worksheet should be formatted using Landscape orientation.
15. Non-graded - Viewing Automatic Calculations
16. Non-graded - Correcting Errors
Monthly Expenses

1
2
3
4
5
6
7
8
 Frangold Real Estate Bud
Monthly Estimates
Income January February March April May June
Commisision $ 12,000.00 $ 12,000.00 $ 14,000.00 $ 14,000.00 $ 16,000.00 $ 18,500.00
Interest 100.00 100.00 100.00 100.00 100.00 100.00
Total $ 12,100.00 $ 12,100.00 $ 14,100.00 $ 14,100.00 $ 16,100.00 $ 18,600.00

Expenses January February March April May June

Rent $ 1,500.00 $ 1,500.00 $ 1,500.00 $ 1,500.00 $ 1,500.00 $ 1,500.00
Utilities 325.00 325.00 325.00 325.00 325.00 325.00
Advertising 400.00 400.00 400.00 400.00 400.00 400.00
Website - - - - - -
Printing 200.00 200.00 200.00 200.00 200.00 200.00
Office Supplies 200.00 - - 200.00 - -
Gas 100.00 100.00 100.00 100.00 100.00 100.00
Miscellaneous 250.00 250.00 250.00 250.00 250.00 250.00
Total $ 2,975.00 $ 2,775.00 $ 2,775.00 $ 2,975.00 $ 2,775.00 $ 2,775.00

$ 9,125.00 $ 9,325.00 $ 11,325.00 $ 11,125.00 $ 13,325.00 $ 15,825.00

old Real Estate Budget
Monthly Estimates
July August September October November December Total
$ 20,000.00 $ 18,500.00 $ 18,500.00 $ 14,000.00 $ 14,000.00 $ 16,500.00 $ 188,000.00
100.00 100.00 100.00 100.00 100.00 100.00 1,200.00
$ 20,100.00 $ 18,600.00 $ 18,600.00 $ 14,100.00 $ 14,100.00 $ 16,600.00 $ 189,200.00

July August September October November December Total

$ 1,500.00 $ 1,500.00 $ 1,500.00 $ 1,500.00 $ 1,500.00 $ 1,500.00 $ 18,000.00
325.00 325.00 325.00 325.00 325.00 325.00 3,900.00
400.00 400.00 400.00 400.00 400.00 400.00 4,800.00
500.00 - - - - - 500.00
200.00 200.00 200.00 200.00 200.00 200.00 2,400.00
200.00 - - 200.00 - - 800.00
100.00 100.00 100.00 100.00 100.00 100.00 1,200.00
250.00 250.00 250.00 250.00 250.00 250.00 3,000.00
$ 3,475.00 $ 2,775.00 $ 2,775.00 $ 2,975.00 $ 2,775.00 $ 2,775.00 $ 34,600.00

$ 16,625.00 $ 15,825.00 $ 15,825.00 $ 11,125.00 $ 11,325.00 $ 13,825.00 $ 154,600.00