Given the Following Spreadsheet, Write the appropriate Formula/ Expression/
Function to be used for (a) to (e)
a. Write down the formula to calculate the Total Quantity in cell C8.
b. Write down the formula to calculate amount of the product GLOVES in cell E7.
c. Write down the formula to calculate total amount in cell E8
d. Write down the formula to find out the average quantity in cell C9.
e. Write down the function to show the highest quantity in cell C10.
Answers
Answer:
Given the Following Spreadsheet, Write the appropriate Formula/ Expression/
Function to be used for (a) to (e)
a. Write down the formula to calculate the Total Quantity in cell C8.
b. Write down the formula to calculate amount of the product GLOVES in cell E7.
c. Write down the formula to calculate total amount in cell E8
d. Write down the formula to find out the average quantity in cell C9.
e. Write down the function to show the highest quantity in cell C10.
Explanation:
Given the Following Spreadsheet, Write the appropriate Formula/ Expression/
Function to be used for (a) to (e)
a. Write down the formula to calculate the Total Quantity in cell C8.
b. Write down the formula to calculate amount of the product GLOVES in cell E7.
c. Write down the formula to calculate total amount in cell E8
d. Write down the formula to find out the average quantity in cell C9.
e. Write down the function to show the highest quantity in cell C10.