Question
(Date is in cell A2 and title Inland Jewelers in A1:G1) Steps 1-15: Insert a function in cell B2 to display the current date from
Steps 1-15:
Insert a function in cell B2 to display the current date from your system. |
With cell B2 selected, set the width of column B to AutoFit. |
Insert a VLOOKUP function in cell C5 to display the ring cost for the first student. |
Copy the formula from cell C5 to the range C6:C11. |
Apply Accounting number format to the range C5:C11. |
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 cellB21that must be applied; if not, the student only pays the base price. Use appropriate relative and absolute cell references. |
Copy the formula from cell E5 to the range E6:E11. |
Apply Accounting number format to the range E5:E11. |
Insert a function in cell G5 to calculate the first student's monthly payment, using appropriate relative and absolute cell references. |
Copy the formula from cell G5 to the range G6:G11. |
Apply Accounting number format to the range G5:G11. |
Calculate totals in cells C12, E12, and G12. |
Apply Accounting number format to the cells C12, E12, and G12, if necessary. |
Set0.3" left and right margins and ensure the page prints on only one page. |
Insert a footer with your name on the left side, the sheet name in the center, and the file name on the right side. |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started