Expert answer:Excel assignment!!

Expert answer:I attached 2 files below. The Excel file is where to do the work. Word file contains questions. Please use my file to do the work……….
duong_e12c1inventory.xlsx

ex16xlch12gradercaphw___apartment_inventory_12_instructions.docx

Unformatted Attachment Preview

HOME CONTENTS INVENTORY LIST
NAME
ADDRESS
PHONE
INSURANCE POLICY NUMBER
INSURANCE AGENT NAME
INSURANCE AGENT PHONE
INSURANCE COMPANY
INSURANCE COMPANY PHONE
TOTAL ESTIMATED VALUE ON ALL ITEMS
$575.00
ROOM/AREA
ITEM DESCRIPTION
MAKE/MODEL
SN/ID NUMBER
DATE
PURCHASED
PURCHASE
WHERE PURCHASED PRICE
Living room
Coffee table
unknown
none
7/1/2012
Local seller
$125.00
$75.00 Yes
Hallway
Glass sculpture
local artist
none
2/10/2010
artist
$300.00
$300.00 Yes
Kitchen
Microwave oven
AB1234-56-789
5/15/2013
online
$250.00
$200.00 No
ESTIMATED
CURRENT VALUE PHOTO? NOTES
Teak with bamboo inlay
Office 2016 – myitlab:grader – Instructions
Excel Project
EX16_XL_CH12_GRADER_CAP_HW – Apartment Inventory 1.2
Project Description:

Instructions:
For the purpose of grading the project you are required to perform the following tasks:
Step
1
Points
Possible
Instructions
Open the file e12c1Inventory.xlsx and save it as a Macro-Enabled Template named
e12c1Inventory_LastFirst.
0.000
Note, Mac users, disregard the slicer placeholders, as they are not used in the project.
2
Apply the Droplet theme. Apply the Title cell style to the cell B2. Apply the Yellow Orange
theme colors.
12.000
3
Unlock the ranges B15:K17 and D4:D12.
6.000
4
Record a macro named Sort. Ensure the macro sorts the Inventory list in ascending order
based on the dates listed in column F.
0.000
5
Create a form control button beginning in the top-left corner of cell F4 and ending in the topleft corner of cell G7. Assign the Sort macro. Edit the button text to display the word Sort.
20.000
Use the VBA Editor to create a new module. Type the following VBA code to create a custom
depreciation function (be sure to include the blank lines after the first line and before the last
line). Save and exit the VBA Editor.
6
Function Depreciation (Value, Rate)
0.000
Depreciation = Value * Rate
End Function
7
Insert two rows above row 12. Enter the Row heading DEPRECIATION RATE in cell B12,
and DEPRECIATION in cell B13.
10.000
8
Use the Depreciation function in cell D13 to calculate depreciation based on the Total
Estimated Value on All Items (cell D14) and the Depreciation Rate (D12).
12.000
9
Clear the contents in the range B17:K19.
5.000
Updated: 07/25/2017
1
Current_Instruction.docx
Office 2016 – myitlab:grader – Instructions
Excel Project
Step
Instructions
Points
Possible
10
Create a new worksheet named Code to the right of the HOME CONTENTS INVENTORY LIST.
5.000
11
Open the VBA Editor and display the module containing the sort code. Copy the code
beginning with the text Sub Sort () and ending with the first instance of the text End Sub.
Paste the contents in cell B2 of the Code worksheet. Do not close the VBA Editor.
15.000
12
Open the VBA Editor and display the module containing the DEPRECIATION function. Copy the
code beginning with the text Function Depreciation(Value, Rate) and ending with the first
instance of the text End Function. Paste the contents in cell B23 of the Code worksheet. Close
the VBA Editor.
15.000
13
Save the file as e12c1Inventory_LastFirst in the Excel file format. Close the file. Based on
your instructor’s directions, submit e12c1Inventory_LastFirst.
0.000
Total Points
Updated: 07/25/2017
2
100.000
Current_Instruction.docx
…
Purchase answer to see full
attachment

How it works

1. Paste your instructions in the instructions box. You can also attach an instructions file
2. Select the writer category, deadline, education level and review the instructions 
3. Make a payment for the order to be assignment to a writer
4.  Download the paper after the writer uploads it 

Will the writer plagiarize my essay?

You will get a plagiarism-free paper and you can get an originality report upon request.

Is this service safe?

All the personal information is confidential and we have 100% safe payment methods. We also guarantee good grades