Do not specify a password for the document. Hide the Applicants, Application PivotTable, and Terms and Definitions worksheets. In the Dashboard worksheet, hide the contents of columns O through Q. Use the arrow buttons in cells F19 and G19 to select the values Accountant and Onsite Interview. The application will now be able to retrieve data on applicants that match specified search criteria. In cell G19, create a list validation based on the data in the range Q8:Q13. In cell F19, create a list validation based on the data in the range O8:O18. Change the chart title to Application History.

Move and resize the chart to cover the range J6:K15. Insert a funnel chart of the data in the range F8:G13. Move the WordArt object to the upper-left corner of the worksheet.Īpply an 18-point golden glow text effect to the WordArt object, choosing the effect in the fourth row and first column of the gallery of glow effects. Insert the WordArt object showing text in a black font with a hard red drop shadow located in the third row and second column of the WordArt gallery.Ĭhange the default text to Invent Software. In the Dashboard worksheet, create the following WordArt object: In the Documentation worksheet, enter your name and the date. Save the workbook as NP_EX_12_Invent in the location specified by your instructor. Open the NP_EX_12-3.xlsm workbook located in the Excel12 > Case1 folder included with your Data Files. David already created part of the application and needs you to finish it. The application will be used by staffers in the HR department, so it must be easy to use with safeguards to help prevent user error. David is using Excel to track the hiring process from initial job postings through interviews to job offers and wants your help in developing an application to automate the process reporting key hiring metrics. Invent Software David Wright is a hiring manager for the Human Resources (HR) department at Invent Software, a growing company that creates software for inventory management. Data File needed for this Case Problem: NP_EX_12-3.xlsm

How to use xlsm file