{"id":47961,"date":"2022-04-02T13:28:24","date_gmt":"2022-04-02T13:28:24","guid":{"rendered":"https:\/\/assignmenttutors.net\/blog\/exp19_excel_ch02_capassessment_inland_jewelers-computer-science-homework-help\/"},"modified":"2022-04-02T13:28:24","modified_gmt":"2022-04-02T13:28:24","slug":"exp19_excel_ch02_capassessment_inland_jewelers-computer-science-homework-help","status":"publish","type":"post","link":"https:\/\/assignmenttutors.net\/blog\/exp19_excel_ch02_capassessment_inland_jewelers-computer-science-homework-help\/","title":{"rendered":"Exp19_excel_ch02_capassessment_inland_jewelers | Computer Science homework help"},"content":{"rendered":"
\n

\u00a0<\/p>\n

Exp19_Excel_Ch02_CapAssessment_Inland_Jewelers<\/strong><\/h2>\n

\u00a0Exp19 Excel Ch02 CapAssessment Inland Jewelers\u00a0<\/p>\n

Project Description:<\/strong><\/h3>\n

You are an account manager for Inland Jewelers, a regional company \u00a0that makes custom class rings for graduating seniors. Your supervisor \u00a0requested a workbook to report on new accounts created on payment plans. \u00a0The report should provide details on total costs to the student as well \u00a0as payment information. Each ring financed has a base price that can \u00a0fluctuate based on ring personalization.<\/p>\n

Start \u00a0\u00a0Excel. Download and open the file named Exp19_Excel_Ch02_Cap_InlandJewelers.xlsx<\/em>. Grader has automatically added \u00a0\u00a0your last name to the beginning of the filename.<\/p>\n

Insert a function in cell B2 to \u00a0\u00a0display the current date from your system.<\/p>\n

With cell B2 selected, set the \u00a0\u00a0width of column B to AutoFit.<\/p>\n

Insert a VLOOKUP function in \u00a0\u00a0cell C5 to display the ring cost for \u00a0the first student. The cost of the ring \u00a0\u00a0type should be an exact match. \u00a0Use appropriate relative and absolute cell \u00a0\u00a0references.<\/p>\n

Copy the formula from cell C5 to \u00a0\u00a0the range C6:C11.<\/p>\n

Apply Accounting number format \u00a0\u00a0to the range C5:C11.<\/p>\n

Insert an IF function in cell E5 to calculate the total \u00a0\u00a0due. If the \u00a0student has chosen to personalize the ring, there is an \u00a0\u00a0additional \u00a0charge of 5% located in cell B21 that must be added to the cost of \u00a0\u00a0the \u00a0ring; if not, the student only pays the base price. Use appropriate \u00a0\u00a0\u00a0relative and absolute cell references.<\/p>\n

Copy the formula from cell E5 to \u00a0\u00a0the range E6:E11.<\/p>\n

Apply Accounting number format \u00a0\u00a0to the range E5:E11.<\/p>\n

Insert a function in cell G5 to \u00a0\u00a0calculate the first student’s \u00a0monthly payment, using appropriate relative and \u00a0\u00a0absolute cell \u00a0references. Ensure the result is a positive number.<\/p>\n

Copy the formula from cell G5 to \u00a0\u00a0the range G6:G11.<\/p>\n

Apply Accounting number format \u00a0\u00a0to the range G5:G11.<\/p>\n

Calculate totals in cells C12, \u00a0\u00a0E12, and G12.<\/p>\n

Apply Accounting number format \u00a0\u00a0to the cells C12, E12, and G12.<\/p>\n

Set 0.3″ left and right \u00a0\u00a0margins and ensure the page prints on only one page.<\/p>\n

Insert a footer with your name \u00a0\u00a0on the left side, the sheet name in the center, and the file name on the \u00a0\u00a0right side.<\/p>\n

Save and close Exp19_Excel_Ch02_Cap_InlandJewelers.xlsx<\/em>. \u00a0\u00a0Exit Excel. Submit the file as directed<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

\u00a0 Exp19_Excel_Ch02_CapAssessment_Inland_Jewelers \u00a0Exp19 Excel Ch02 CapAssessment Inland Jewelers\u00a0 Project Description: You are an account manager for Inland Jewelers, a regional company \u00a0that makes custom class rings for graduating seniors. Your supervisor \u00a0requested a workbook to report on new accounts created on payment plans. \u00a0The report should provide details on total costs to the student as […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[16],"tags":[],"class_list":["post-47961","post","type-post","status-publish","format-standard","hentry","category-education"],"_links":{"self":[{"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/posts\/47961","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/comments?post=47961"}],"version-history":[{"count":0,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/posts\/47961\/revisions"}],"wp:attachment":[{"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/media?parent=47961"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/categories?post=47961"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/tags?post=47961"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}