excel

Excel Practical Exercise Module 2

Note: Open a workbook and save as EX-PE2-YourName. Each exercise in

a worksheet Tab.

Exercise 1: Analyzing Emergency Student Loans

The Student Assistance office at your school provides emergency loans at simple

interest. The data obtained from six types of loans and the desired report format arc

shown in Table 2-9. The required formulas are shown in Table 2-10. Use the

concepts and techniques presented in this chapter to create and format the worksheet.

Include total, average, maximum, and minimum values for Principal, Interest, and

Amount Due.

Use conditional formatting to change the formatting to white font on a red

background in any cell in of the Amount Due that contains a value greater than 20000.

Create a 3-D Clustered Bar chart with the Amount Due of each Loan Type.

Change the name of the sheet tab to M2-Exercise 1

Exercise 2: Analyzing Profit Potential

You work for Humi-Corporation, an online retailer of home humidifiers. Your

manager wants to know the profit potential of their inventory based on the items in

inventory listed in Table 2-12. Table 2-12 contains the format of the desired report.

The required formulas are shown in Table 2-13. Use the concepts and techniques

developed in this chapter to create and format the worksheet. The company just

received 67 additional desk-sized humidifiers and shipped out 48 room-sized

humidifiers. Update the appropriate cells to reflect the change in inventory.

Use conditional formatting to change the formatting to white font on a green background

in any cell in of the Total Value that contains a value greater than 20,000.00.

Create a 3-D Clustered Bar chart with the Total Cost and Total Value of each Item.

Insert a 3D pie chart of the Potential Profit

Change the name of the sheet tab to M2-Exercise 2