2 excel homework jewelers 15

• For educators
• English (US)
• English (India)
• English (UK)
• Greek Alphabet

This problem has been solved!

You'll get a detailed solution that helps you learn core concepts.

Question: Exp19_Excel_Ch02_CapAssessment_Inland_JewelersProject Description:You are an account manager for Inland Jewelers, a regional company that makes custorn class rings for graduating s Your supervisor requested a workbook to report on new accounts created on payment plans. The report should provic on total costs to the student as well as payment information.

1. Start Excel and open the file named Exp19_Excel...

Not the question you’re looking for?

Post any question and get expert help quickly.

• High School
• You don't have any recent items yet.
• You don't have any courses yet.
• You don't have any books yet.
• You don't have any Studylists yet.
• Information

Exp19 Excel Ch02 Cap Assessment Inland Jewelers Instructions

Information systems for management (itom 2308), southern methodist university, students also viewed.

• Exp19 Excel Ch08 HOEAssessment Robert's Flooring Instructions
• Doctrine OF Fairness - exercise
• Niti ayog - article
• Con Law Outline
• Kahn Con Law I Spring 2019 Sullivan Casebook
• 3L Con Law Outline

Related documents

• Fall 2016 Hanna Fed Inc Tax Outline
• Income Tax Outline
• MKTG 3340 Syllabus
• Fall 2021 MNO3370 Syllabus - Section 008H
• Business Ethics Reflection Week 3
• Chem Notes Chapter 14

Preview text

Grader - instructions excel 2019 project, exp19_excel_ch02_capassessment_inland_jewelers, 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., steps to perform:, step instructions, 1 start excel. download and open the file named, exp19_excel_ch02_cap_inlandjewelers. grader has, automatically added your last name to the beginning of the filename., 2 insert a function in cell b2 to display the current date from your, 3 with cell b2 selected, set the width of column b to autofit. 0, 4 insert a vlookup function in cell c5 to display the ring cost for the, first student. the cost of the ring type should be an exact match. use, appropriate relative and absolute cell references., 5 copy the formula from cell c5 to the range c6:c11. 6, 6 apply accounting number format to the range c5:c11. 4, 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 $b$21, that must be added to the cost of the ring; if, not, the student only pays the base price. use appropriate relative and, absolute cell references., 8 copy the formula from cell e5 to the range e6:e11. 6, 9 apply accounting number format to the range e5:e11. 3, 10 insert a function in cell g5 to calculate the first student's monthly, payment, using appropriate relative and absolute cell references., ensure the result is a positive number., 11 copy the formula from cell g5 to the range g6:g11. 7, 12 apply accounting number format to the range g5:g11. 4, 13 calculate totals in cells c12, e12, and g12. 7, created on: 08/08/2023 1 exp19_excel_ch02_capassessment - inland jewelers 1., step instructions points, 14 apply accounting number format to the cells c12, e12, and g12. 2, 15 set 0" left and right margins and ensure the page prints on only one, 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., 17 save and close exp19_excel_ch02_cap_inlandjewelers. exit, excel. submit the file as directed, total points 100, created on: 08/08/2023 2 exp19_excel_ch02_capassessment - inland jewelers 1..

• Multiple Choice

Course : Information Systems for Management (ITOM 2308)

University : southern methodist university.

• More from: Information Systems for Management ITOM 2308 Southern Methodist University 8   Documents Go to course