$09$

$f_x$

A

B

C

D

E

F

G

$H$

J

K

L

M

N

$0$

P

Data Insights Questions

Inventory Worksheet

Use an INDEX MATCH function to fill in Column D by assigning the appropriate Category with the given Store Location using the small table L$2$:M$7.$

What is the Total Revenue for all the products in the Middle store location? Ensure that your answer is in Accounting format.

What is the Average inventory amount for the Back store location? Use formatting tools to decrease the decimal so that the displayed value is a whole number.

How many products are in the Inventory Type "Clothing Staples"?

Use the VLOOKUP function to determine which product has the Item ID $1254$#RT$.$

Use an INDEX MATCH function to determine which product has the largets amount of inventory.