Steps to Perform:

Step	Instructions	Points Possible
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
10	Insert a function in cell G5 to calculate the first student's monthly payment, using appropriate relative and absolute cell references.	14
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

100

AutoSave Off H ave r o Timotijevic_exploring_e02_grader_h1.xlsx - Saved Search Ilija Timotijevic IT - X File Home Insert Draw Page Layout Formulas Data Review ViewHelp Acrobat Share Comments M & Cut === 207 0 alle Wrap Text Merge & Center - AutoSum oSum" 47 Fill Sort & Clear Filter General $ ~ % Paste = 9 92 400 Insert Delete Format Ideas Sensitivity Conditional Format as Cell Formatting Table Styles Find & Select Alignment Number Styles Cells Editing Ideas Sensitivity [ Copy ater Format Painter Clipboard x A B Calibri 11 A^^ BI U - - v A E Font r fix C D E Inland Jewelers B2 F G H I J K L M N O P Q R S T U V A 2 Date nm + Name Ring Type Cost Personalized Total Years Monthly Payment Silver Gold Titanium Platinum Platinum Gold Titanium Yes Yes No No Yes No Yes 5 Dodson 6 Jones 7 Clarke 8 Ranger 9 McKinley 10 Broadnax 11 Burch 12 Totals 13 14 15 Ring Type 16 Silver 17 Gold 18 Titanium 19 Platinum 20 Cost $ 400.00 $ 550.00 $ 700.00 $ 750.00 5% Personalizing Surcharge Interest Rate 3% 22 23 24 ClassRing O " - + 100% AutoSave Off H ave r o Timotijevic_exploring_e02_grader_h1.xlsx - Saved Search Ilija Timotijevic IT - X File Home Insert Draw Page Layout Formulas Data Review ViewHelp Acrobat Share Comments M & Cut === 207 0 alle Wrap Text Merge & Center - AutoSum oSum" 47 Fill Sort & Clear Filter General $ ~ % Paste = 9 92 400 Insert Delete Format Ideas Sensitivity Conditional Format as Cell Formatting Table Styles Find & Select Alignment Number Styles Cells Editing Ideas Sensitivity [ Copy ater Format Painter Clipboard x A B Calibri 11 A^^ BI U - - v A E Font r fix C D E Inland Jewelers B2 F G H I J K L M N O P Q R S T U V A 2 Date nm + Name Ring Type Cost Personalized Total Years Monthly Payment Silver Gold Titanium Platinum Platinum Gold Titanium Yes Yes No No Yes No Yes 5 Dodson 6 Jones 7 Clarke 8 Ranger 9 McKinley 10 Broadnax 11 Burch 12 Totals 13 14 15 Ring Type 16 Silver 17 Gold 18 Titanium 19 Platinum 20 Cost $ 400.00 $ 550.00 $ 700.00 $ 750.00 5% Personalizing Surcharge Interest Rate 3% 22 23 24 ClassRing O " - + 100%