Please complete this excel assignment

User Generated

fjntlbyb

Business Finance

Description

Unformatted Attachment Preview

Office 2016 – myitlab:grader – Instructions Excel Project EX16_XL_CH02_GRADER_CAP_HW - Inland Jewelers 1.12 Project Description: You are an account manager for Inland Jewelers, a regional company that makes custom class rings for graduating seniors. Your supervisor requested a workbook to report on new accounts created on payment plans. The report should provide details on total costs to the student as well as payment information. Each ring financed has a base price that can fluctuate based on ring personalization. Instructions: For the purpose of grading the project you are required to perform the following tasks: Step Points Possible Instructions 1 Start Excel. Download and open the file named exploring_e02_grader_h1.xlsx. 0 2 Insert a function in cell B2 to display the current date from your system. 10 3 With cell B2 selected, set the width of column B to AutoFit. 2 4 Insert a VLOOKUP function in cell C5 to display the ring cost for the first student. 14 5 Copy the formula from cell C5 to the range C6:C11. 6 6 Apply Accounting number format to the range C5:C11. 3 7 Insert an IF function in cell E5 to calculate the total due. If the student has chosen to personalize the ring, there is an additional charge of 5% located in cell B21 that must be applied; if not, the student only pays the base price. Use appropriate relative and absolute cell references. 14 8 Copy the formula from cell E5 to the range E6:E11. 6 9 Apply Accounting number format to the range E5:E11. 3 Insert a function in cell G5 to calculate the first student's monthly payment, using appropriate relative and absolute cell references. 14 10 Updated: 02/08/2018 1 Current_Instruction.docx Office 2016 – myitlab:grader – Instructions Step Excel Project Points Possible Instructions 11 Copy the formula from cell G5 to the range G6:G11. 7 12 Apply Accounting number format to the range G5:G11. 3 13 Calculate totals in cells C12, E12, and G12. 7 14 Apply Accounting number format to the cells C12, E12, and G12, if necessary. 2 15 Set 0.3" left and right margins and ensure the page prints on only one page. 5 16 Insert a footer with your name on the left side, the sheet name in the center, and the file name on the right side. 4 17 Save the workbook. Close Excel. Submit the file as directed by your instructor. 0 Total Points Updated: 02/08/2018 2 100 Current_Instruction.docx Inland Jewelers Date Name Dodson Jones Clarke Ranger McKinley Broadnax Burch Totals Ring Type Silver Gold Titanium Platinum Ring Type Silver Gold Titanium Platinum Platinum Gold Titanium $ $ $ $ Cost 400.00 550.00 700.00 750.00 Personalizing Surcharge 5% Interest Rate 3% Cost Personalized Yes Yes No No Yes No Yes Total Monthly Payment Years 1 1 2 3 3 2 3
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

The solution is attached.Please, give me feedback.

Inland Jewelers
Date

#######
Name

Dodson
Jones
Clarke
Ranger
McKinley
Broadnax
Burch
To...


Anonymous
Just what I was looking for! Super helpful.

Studypool
4.7
Indeed
4.5
Sitejabber
4.4

Similar Content

Related Tags