USING MICROSOFT EXCEL 2016 - Guided Project 6-3 - The Wear-Ever Shoes (Update in 2025) скачать в хорошем качестве

USING MICROSOFT EXCEL 2016 - Guided Project 6-3 - The Wear-Ever Shoes (Update in 2025)

Join this channel to get access to perks:    / @calculusphysicschemaccountingt   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 the Enable Editing button. The file will be renamed automatically to include your name. Change the project file name if directed to do so by your instructor, and save it. Click the Inventory sheet tab. Select cells A3:I39, click the Name box, type Inventory as the range name, and press Enter. Select cell L5 and type WE006. Create a nested function with INDEX and MATCH to display inventory for a product. a. Select cell L6. b. Click the Lookup & Reference button [Formulas tab, Function Library group] and choose INDEX. Select the first argument list array, row_num, column_num and click OK. c. For the Array argument, type Inventory. d. Click the Row_num box and click the Name box arrow. Choose MATCH in the list or choose More Functions to find and select MATCH. The INDEX function uses this MATCH statement to find the row. e. Click cell L5 for the Lookup_value argument. f. Click the Lookup_array box and select cells A3:A39. This MATCH function finds the row that matches cell L5 in column A. g. Click the Match_type argument and type 0. h. Click INDEX in the Formula bar. i. Click the Column_num argument, click the Name box arrow, and choose MATCH (Figure 6-91).