Acct 315 In Practice Excel 365 Application Capstone Project (Ch 5 7)

In Practice Excel 365: Application Capstone Project 3 These instructions are compatible with both Microsoft Windows and Mac operating systems. For this project, your tasks include billing statistics and survey results for Courtyard Medical Plaza (CMP). You group, format, and consolidate worksheets, and build an array formula. You also create a template with data validation lists and form controls. [Student Learning Outcomes: 5.1, 5.4, 5.6, 6.2, 6.3, 6.4, 6.7, 7.1, 7.2, 7.3, 7.4, 7.5, 7.6] Files Needed: CourtyardMedical_Project3-Excel-ACP-3.xlsx and CMPLogo.png Completed Project File Names: [your name]-CourtyardMedical_Project3-Excel-ACP-3.xlsx Skills Covered in this Project • Use the COUNTIF function. • Build SUMIFS formulas. • Build borders and add fill to format a worksheet. • Build a date calculation. • Create an IF formula. • Nest XMATCH and INDEX functions. • Build an array formula. • Group and format worksheets. • Copy a worksheet and rename a tab. • Create a static data consolidation. • Insert a picture in a worksheet. • Create a custom template. • Convert an array to a range. • Set data validation with a list. • Nest an IFERROR formula. • Insert a check box form control. • Check accessibility. • Add worksheet protection. • Create a workbook from a template. Steps to complete this project: Mark the steps as checked when you complete them.