USING MICROSOFT EXCEL 2016 - Guided Project 6-3 - The Wear-Ever Shoes

USING MICROSOFT EXCEL 2016 Guided Project 6-3 Guided Project 6 3 The Wear-Ever Shoes company maintains inventory data and customer satisfaction survey results in your workbook. You use Lookup & Reference, Database, and Logical functions to complete the data. You also use a Financial function to calculate depreciation and a Text function to enter email addresses. Skills Covered in This Project • Nest the INDEX and MATCH functions. • Use SUMIFS from the Math & Trig category. • Use DAVERAGE. • Create an IFS formula. • Use a Text function to concatenate text strings. • Calculate depreciation with the DB function. Step 1: Download start file 1. 2. 3. 4. 5. Open the WearEverShoes-06 start file. Click