skip to Main Content
The smarter way
to do assignments.

Please note that this is just a preview of a school assignment posted on our website by one of our clients. If you need assistance with this question too, please click on the Order button at the bottom of the page to get started.

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
Instructions
Points Possible
1
Open the file e12c1Inventory.xlsx and save it as a
Macro-Enabled Template named
e12c1Inventory_LastFirst.
Note, Mac users, disregard the slicer placeholders, as they are not
used in the project.
0.000
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 top-left corner of cell G7. Assign the
Sort macro. Edit the button text to display the word
Sort.
20.000
6
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.
Function Depreciation (Value, Rate)
Depreciation = Value * Rate
End Function
0.000
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
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
100.000

GET HELP WITH THIS ASSIGNMENT TODAY

Clicking on this button will take you to our custom assignment page. Here you can fill out all the additional details for this particular paper (grading rubric, academic style, number of sources etc), after which your paper will get assigned to a course-specific writer. If you have any issues/concerns, please don’t hesitate to contact our live support team or email us right away.

How It Works        |        About Us       |       Contact Us

© 2018 | Intelli Essays Homework Service®