BUSI 201 Assignment 8 Excel 2016 Skill Review 6.2
3. Start with the Analysis worksheet. Use the SUMPRODUCT function to calculate the total value of the inventory. Use the values in the Selling Price column and the corresponding values in the Stock column as the Array arguments. a. Click cell B2. b. Type =SUMPRODUCT( c. Click the Inventory sheet tab, and then click and drag to select cells G3:G25. d. Type, and then click and drag to select cells H3:H25. e. Type ) and press [Enter]. f. The formula should look like this: =SUMPRODUCT(Inventory!G3:G25, Inventory! H3:H25)
Geschreven voor
- Instelling
- University Of California - Berkeley
- Vak
- BUSINESS 201 (BUSINESS201)
Documentinformatie
- Geüpload op
- 5 augustus 2021
- Aantal pagina's
- 19
- Geschreven in
- 2016/2017
- Type
- Tentamen (uitwerkingen)
- Bevat
- Vragen en antwoorden
Onderwerpen
-
busi 201 assignment 8 excel 2016 skill review 62