Samantha is a distributor of jewelry. She uses Excel 2013 to record her inventory and order forms. Samantha's worksheet for her company's monthly orders needs to display summary information including the total number of items ordered and the amount of revenue generated from those orders.
-Samantha wants to find out how much money she will make on her largest order,which is currently in row E.Cell E4 contains the number of items ordered and cell E5 contains the price per item.An appropriate formula would be ____.
A)=E4+E5
B)=E5/E4
C)=E4*E5
D)=E4^E5

Question

Quizplus · Accepted Answer

The formula to calculate the total revenue for the largest order is the number of items ordered multiplied by the price per item. This can be calculated using the formula =E4*E5, which multiplies the value in cell E4 with the value in cell E5.

Samantha Is a Distributor of Jewelry