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.