/nPlease complete the numbered tasks below using any resources at your disposal. All data necessary to complete this assignment are contained in the 'Reference', 'Data', and 'Value' sheets. Show your resulting work and explain what you did - feel free to create new sheets as needed. All tests are due back to lauren. viernes@oracle.com by 12pm EST Monday, August 7th. 1. 2. 3. Excel Tasks Map the corresponding Forecast Type Group from 'Reference' to each Probability on 'Data'. Create a new column on 'Data' that divides each row's Pipeline by the Division Value on 'Value'. Create a column on 'Data' that shows 'Government' if Credit Receiver is NACT Government and Education otherwise return 'Private Sector'. Create a column on 'Data' that shows 'Greater Than $10K' if Pipeline is > 10,000 otherwise return 'Less Than $10K'. 4. 5. What's the total Pipeline value of your opportunities? 6. Please identify your top 3 Customers by Pipeline. 7. Display the count of Opportunity ID by Customer. 8. What distinct count of Customers have you piped an opportunity for? 9. Show Pipeline value by Credit Receiver and Opportunity Status. 10. Which opportunities - if any - are not close date compliant? 11. What Lead Type is most prevalent among your open opportunities (see: Opportunity Status)?

Fig: 1