type the steps please, the software being used Is microsoft excel

On the LoanConditions worksheet begin to create a one-variable data table by typing various interest rates ranging from 4% through 10% in increments of 1% in cells D3:09. In cell E2, reference the cell that calculates the monthly payment amount for the loan. Apply a custom format to cell E2 so that the cell appears to be Monthly Payment. Finish the one-variable data table to see the monthly payment amount for each interest rate. Apply conditional formatting to the range E3:E9 using the gradient fill, green data bar option. On the Break-Even Analysis worksheet begin to create a one- variable data table by referencing the cell that calculates the total expenses in cell H4. In cell 14, reference the cell that calculates the gross revenue. In cell J4, reference the cell that calculates the net income. Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments x Calibri (Body) Conditional Formatting v Insert v V 12 Ai V Currency FM Format as Table v 48- 0 Delete v V Paste 60 V A. V Ideas $ v % 9 V 00 >0 Sensitivity Cell Styles Sort & Filter Format v Find & Select D6 fx A B D E F G . j K M . N o Q 20 S T 1 Red Bluff Golf Course & Pro Shop Break-even Analysis for Golf Lessons 2 3 Revenue Expenses Revenue Net Income 4 5 Total Clients Golf Lesson Fee Gross Revenue $125.00 10 20 6 30 7 Expenses 8 Fixed Costs 40 9 50 10 Manager Salaries Utilities Equipment Depreciation Insurance Client Demand 60 $4,669.00 $427.00 $1,122.00 $328.00 11 70 80 12 13 90 Total Fixed Costs Variable Costs 14 100 15 Instructor Commission Supplies per Client 10% $9.95 16 17 Total Variable Costs 18 Total Expenses 19 Net Income 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 Break-Even Analysis Loan Conditions Fees AndDemand + Ready - + 100% Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments x Calibri (Body) Conditional Formatting v Insert v V Ai 11 General AM Format as Table v Delete v V Paste 60 V A V $ V Ideas % 9 00 >0 Sensitivity V Cell Styles v Sort & Filter Format v Find & Select D15 fx A B D E F G H 1 j L M N o Q R S T U One-Variable Data Table 1 Red Bluff Loan Conditions 2 Loan Amount $200,000 3 Term (Years) 10 4 Interest Rate 6.00% 5 Down Payment $25,000 6 Monthly Payment $1,942.86 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 Break-Even Analysis Loan Conditions FeesAndDemand + Ready - + 100% Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments x Calibri (Body) Conditional Formatting v Insert v V 12 Ai V General FM 48- 0 Format as Table v Delete v V Paste B. I U 60 A V V Ideas $ v % 9 00 >0 V Sensitivity Cell Styles v Sort & Filter Format v Find & Select A1 fx Golf Lesson Pricing A B D E F G . K L M . N o P Q R S T U V w Two-Variable Data Table Lesson Fees 135 120 125 130 140 145 150 1 Golf Lesson Pricing 2 Total Clients 75 3 Lesson Fee $150.00 4 Gross Revenue $11,250.00 5 Fixed Costs $9,554.10 6 Variable Costs $856.78 7 Net Income $839.12 45 50 55 60 8 65 70 9 10 Client Demand 75 11 80 12 85 90 13 14 95 15 100 16 105 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 33 34 35 36 37 Break-Even Analysis Loan Conditions FeesAndDemand + Ready - 100%