CMR282 Miami Module 4 EL2 Excelsheet Assignments Help To Do:
Assessments 1, 2, 3, and 4
CMR 282 Module 4 textbook assignments
Submit the following files:
I already uploaded the files needed. All the instructions are in the word file. Make sure this assignment is do by yourself, not copy from others or Internet. We have turnitin to check if it was copied. CMR 282
Chapter 2 Module 4
Create Range Names and Use the Lookup Function
Save the workbook with the name EL2-C2-A1-RSROctLabor
Modify the range named LaborCost to include cell F22.
Change the range name for the range named Hr to Hours.
In cell E7, create a VLOOKUP formula to return the correct hourly rate based on the technician
code in cell D7. Use the range name RateChart within the formula to reference the hourly rate
chart. Make sure Excel will return values for exact matches only.
6. Create or copy the following formulas:
a. Copy the VLOOKUP formula in cell E7 and paste it into the range E8:E22.
b. In cell F7, multiply the values in the range named Hours by the hourly rate in cell E7. Add
the ROUND function to ensure that all labor costs are rounded to the nearest cent (two
c. Copy the formula in cell F7 and paste it into the range F8:F22.
d. Create the formula in cell F23 to sum the values in the column.
7. Preview and then print the worksheet.
8. Save and then close EL2-C2-A1-RSROctLabor
Use Conditional Statistical and Math Functions
Note: For all the functions in Assessment 2 except those in Step 3, use range names in the formulas to
1. Open EL2-C2-A1-RSROctLabor
2. Save the workbook with the name EL2-C2-A2-RSROctLabor
3. Using the range named TechCode, create COUNTIF formulas in these cells:
I9: Count the number of calls made by technician 1.
I10: Count the number of calls made by technician 2.
I11: Count the number of calls made by technician 3.
4. In cell I14, create a COUNTIFS formula to count the number of calls made by technician 3 for
which the hours logged were greater than three. Use range names (TechCode and Hours) where
5. Using the ranges named TechCode and LaborCost, create SUMIF formulas in these cells
J9: Add the labor cost for calls made by technician 1.
J10: Add the labor cost for calls made by technician 2.
J11: Add the labor cost for calls made by technician 3.
6. Using the ranges named TechCode, LaborCost, and Hours, create a SUMIFS formula in cell J14 to
add the labor cost for calls made by technician 3 (criteria 1) in which the hours logged were
greater than three (criteria 2).
7. Using the named ranges TechCode and LaborCost, create AVERAGEIF formulas in these cells:
J18: Average the labor cost for calls made by technician 1.
J19: Average the labor cost for calls made by technician 2.
J20: Average the labor cost for calls made by technician 3.
8. Ensure that the Comma format has been applied to the cells or ranges:
9. Save, print, and then close EL2-C2-A2-RSROctLabor
Use the PMT and PPMT Financial Functions
1. Open PrecisionWarehouse.xlsx.
2. Save the workbook with the name EL2-C2-A3-PrecisionWarehouse
3. Using cell references, create a PMT formula in cell D8 to calculate the monthly loan payment for
a proposed loan from NewVentures Capital Inc.
a. Note: The PMT function uses the same arguments as the PPMT function with the
exception, that there is no Per criterion. Remember to divide the rate by 12 and multiply
the nper by 12 to use monthly units.
4. Using cell references, create PPMT formulas to find the principal portion of the loan payment for
the first loan payment in cell D10 and the last loan payment in cell D11.
5. In cell D13, create a formula to calculate the total cost of the loan by multiplying the monthly
loan payment times the amortization period in years times 12.
6. Print the worksheet.
7. Save and then close EL2-C2-A3-PrecisionWarehouse
Use Logical Functions
1. Open ACPremiumReview.xlsx.
2. Save the workbook with the name EL2-C2-A4-ACPremiumReview. The following range names
have been created:
3. Using named ranges, create a formula in cell G4 to display Yes if the number of at fault claims is
greater than one and the current rating is greater than two. Both conditions must test true to
display Yes; otherwise, display No in the cell. Hint: Use a nested IF and AND formula.
4. Using named ranges, create a formula in cell H4 to display Yes in the cell if either the number of
claims is greater than two or the current deductible is less than $1,000.00; otherwise, display No
in the cell. Hint: Use a nested IF and OR formula.
5. Center the results in cells G4 and H4 and then copy and paste the formulas into the ranges
G5:G23 and H5:H23, respectively. Deselect the range after copying.
6. Save, print, and then close EL2-C2-A4-ACPremiumReview.
Hourly Rate Chart
RSR Computer Services
Labor Cost Report
In-Home Computer Service Billings
TOTAL LABOR COST
Labor Cost Statistics
By Technician Code
Technician 3 calls over 3 hours
By Technician Code
AllClaims Insurance Brokers
Insurance Policy Premium Review
Precision Design and Packaging
Proposed New Warehouse Construction
Financing through NewVentures Capital Inc.
Quoted interest rate per annum
Amortization period in years
Principal amount to be borrowed
Monthly loan payment
Principal portion of first loan payment
Principal portion of last loan payment
Total cost of loan
Purchase answer to see full
Our Unique Features
Custom Papers Means Custom Papers
This is what custom writing means to us: Your essay starts from scratch. Plagiarism is unacceptable. We demand the originality of our academic essay writers and they only deliver authentic and original papers. 100% guaranteed! If your final version is not as expected, we will revise it immediately.
Qualified and Experienced Essay Writers
Our team consists of carefully selected writers with in-depth expertise. Each writer in our team is selected based on their writing skills and experience. Each team member is able to provide plagiarism-free, authentic and high-quality content within a short turnaround time.
Free Unlimited Revisions
If you think we missed something, send your order for a free revision. You have 10 days to submit the order for review after you have received the final document. You can do this yourself after logging into your personal account or by contacting our support.
Prompt Delivery and 100% Assuarance
We understand you. Spending your hard earned money on a writing service is a big deal. It is a big investment and it is difficult to make the decision. That is why we support our claims with guarantees. We want you to be reassured as soon as you place your order. Here are our guarantees: Your deadlines are important to us. When ordering, please note that delivery will take place no later than the expiry date.
100% Originality & Confidentiality
Every paper we write for every order is 100% original. To support this, we would be happy to provide you with a plagiarism analysis report on request.We use several writing tools checks to ensure that all documents you receive are free from plagiarism. Our editors carefully review all quotations in the text. We also promise maximum confidentiality in all of our services.
24/7 Customer Support
We help students, business professionals and job seekers around the world in multiple time zones. We also understand that students often keep crazy schedules. No problem. We are there for you around the clock. If you need help at any time, please contact us. An agent is always available for you.
Try it now!
How it works?
Follow these simple steps to get your paper done
Place your order
Fill in the order form and provide all details of your assignment.
Proceed with the payment
Choose the payment system that suits you most.
Receive the final file
Once your paper is ready, we will email it to you.
Our services are second to none. Every time you place an order, you get a personal and original paper of the highest quality.
While a college paper is the most common order we receive, we want you to understand that we have college writers for virtually everything, including: High school and college essays Papers, book reviews, case studies, lab reports, tests All graduate level projects, including theses and dissertations Admissions and scholarship essays Resumes and CV’s Web content, copywriting, blogs, articles Business writing – reports, marketing material, white papers Research and data collection/analysis of any type.
Any Kind of Essay Writing!
Whether you are a high school student struggling with writing five-paragraph essays, an undergraduate management student stressing over a research paper, or a graduate student in the middle of a thesis or dissertation, homeworkmarketpro.com has a writer for you. We can also provide admissions or scholarship essays, a resume or CV, as well as web content or articles. Writing an essay for college admission takes a certain kind of writer. They have to be knowledgeable about your subject and be able to grasp the purpose of the essay.
Quality Check and Editing Support
Every paper is subject to a strict editorial and revision process. This is to ensure that your document is complete and accurate and that all of your instructions have been followed carefully including creating reference lists in the formats APA, Harvard, MLA, Chicago / Turabian.
Prices and Discounts
We are happy to say that we offer some of the most competitive prices in this industry. Since many of our customers are students, job seekers and small entrepreneurs, we know that money is a problem. Therefore, you will find better prices with us compared to writing services of this calibre.