the data , but use references from the original data .
Format the Total Revenue , Expenses , and Net Income in bold , and choose a fill color for the Net Income . Perform a one-way analysis ( i . e ., Week5 , iLab 6 ) to see at what sales volume level MP3 player sales add at least $ 1,000 to net income . Apply conditional formatting to the options that produce at least $ 1,000 in net income in the above table . Format all the numeric data and labels on the worksheet using consistent and business like formatting options . Save your work ( CTRL + s ). Continue using the ‗ Quest 4 – Financials ‘ worksheet : Music on Demand ( MoD ) wants to apply for a 20-year loan and they need to know how much the monthly payment will be with a $ 10,000 down payment or a $ 20,000 down payment on a loan of $ 160,000 . The annual interest rate is 3 % and payment is assumed to be made at the end of the period . Complete the chart and calculate the monthly payment , using an Excel function . Secure / Protect , without a password , the Quest 4-Financials worksheet tab . Save your work ( CTRL + s ). Organization , Planning and Consolidation Strategies ( TCO ‘ s 5 , 7 , & 8 ; 40 Points ) Using the ‗ Quest 5 – Organizing Data ‘ worksheet : Consolidate the information on the Quest 5-Organizing Data sheet from the three ( 3 ) worksheets ( DC Branch , Houston Branch , and LA Branch ), using consolidation strategies that include : Group sheets and use the auto-fill to complete the list of months in Column A and add totals for rows and columns . Apply formatting to column headings and merge and center a title across row 1 for each sheet . Open the blank worksheet , Quest 5-Organizing Data , and on the data tab click consolidate . Choose the sum function to sum the data . Add each worksheet to the consolidated Summary .