Add a formula in column J that returns "Yes" if the category in column E is $"$S$"$ and $"$No$"$ if it isn't. What is the formula in cell J$10?$

$.$ Add a formula in column K that returns "Yes" if the category in column E is $"$L$"$ or $"$C$"$ and $"$No$"$ if it isn't. What is the formula in cell K$27?$

Add a formula in column $L$ that returns "Yes" if the manufacturer is Microsoft and the Quantity is less than $1,000$ and $"$No$"$ if it isn't. What is the formula in cell L$43?$

Using a formula, low many Item IDs does IB $M$ have?

Using any formula, what is the total quantity of Hewlett$-$Packard Items in Category C$?$

Add a formula in column $M$ that joins the Manufacturer name, a hyphen, and the manufacturer category into one cell. What is the formula in cell M$10?$