Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Limb, brush clean up $100.00 Mulch, labor + product, Caleb Zitter $120.00 Trim Bushes, Caleb Zitter $50.00 Leaves, Caleb Zitter $75.00 New furnace and A/C,

Limb, brush clean up $100.00
Mulch, labor + product, Caleb Zitter $120.00
Trim Bushes, Caleb Zitter $50.00
Leaves, Caleb Zitter $75.00
New furnace and A/C, Harding Heating $5,650.00
New Deck, Carlos Ortiz $2,650.00
New electric hot water heater, True Blue service $1,500.00
Misc plumbing, True Blue service $204.50
New whirlpool stainless steel dishwasher $413.50
New whirlpool stainless steel electric range $465.31
New whirlpool stainless steel fridge $651.85
Shower recessed shelf plus trim $112.15
New kitchen pulls $79.96
New hallway pulls plus bath outlet covers $24.93
Backsplash tile, kitchen, plus grout $143.77
Bathroom floor tile $292.57
Toilet $207.41
Bathroom mirror plus new lighting $167.84
New dishwasher hose $21.71
Shower wall grout $14.80
Bath glass block window $96.76
Kitchen faucet $205.31
Bath toilet paper, towel hangers $74.99
Bath faucet $106.54
Bath vanity $206.38
Ceiling fan with light , bonus room $118.49
Paint, bath, kitchen and bonus room $65.76
Paint match, touch up main part house $30.53
New Quartz kitchen counter tops, Granite Designers $1,980.00
Shower wall tile $419.64
New shower head and tub handles $74.09
Electrical work, hot water heater, Oscar Guevara $650.00
New Blinds, Bob Allen $554.11
Shower Rod and Rings $45.57
Hardwood floors kitchen, Dm Floor covering $900.00
Devon Oak laminate flooring bonus room, Dm Floor covering $850.00
Interior remodel, Carlos Ortiz $5,385.00
New outlet covers $14.03
Mold Remediation, Certified Water and Mold Restoration, LLC $3,135.00
Management fee $80.00
Cleaning fee $180.00
Snow removal $40.00
TOTAL

$28,157.50

Create a practical, professional, and meaningful workbook with several named worksheets for a personal project or a work-related project. Project must be complex enough to include the requirements below.

Documentation Page Necessary information and brief description of what workbook is used for. Clear directions of where requirements are located in project.

Worksheet 1 Information organized in a) a table *there can be multiple worksheets or b) a worksheet with total lines. Clear, professional, meaningful.

Worksheet 2 Create chart with legend and axis labeled (Module #4).

Visual Features Use TWO of the following: a) Conditional Formatting (Module #2) b) Sparklines or Data Bars (Module #4) c) Hyperlinks (Module #6)

Advanced Features Include ONE of the following: a) a PivotTable and Slicer (Module #5) OR b) a Macro and button. (Module #7)

Clarifying Features Create Validation Rules and set visible cues (cell styles) for data entry. (Module #7 & Module #2)

Simplifying Features Create/Use ONE of the following: a) a VLookup Function with table (Module #3) OR b) an Excel Application could include a Macro (Module #7)

Functions Include TWO Advanced Functions from Modules #2, #3 and #8: a) PMT function d) OR function b) IF function e) Nested function c) AND function

Basic Features Use cell references so the workbook can adjust with any changes. Format to print properly (include headers/footers). (Module #2)

NOTE: It needs to be in an excel book, please. I just need an excel worksheet for the project please, I only got explanation the last time. Thank you!!

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

Cost Management Strategies For Business Decisions

Authors: Ronald Hilton, Michael Maher, Frank Selto

3rd Edition

0072830085, 978-0072830088

More Books

Students also viewed these Accounting questions

Question

Why are ratios and trends used in financial analysis?

Answered: 1 week ago