Question: I need help in these formulas i just neeed formulas sp that i put in correspondence columns and cell and i get values its need

I need help in these formulas i just neeed formulas sp that i put in correspondence columns and cell and i get values its need urgent

I need help in these formulas i just neeed formulas sp that

10.Type the formulas to calculate the following: In cell B9, calculate the grand total amount owing for all customers. In cell B10, calculate the total cost amount of all the mussels and crabs sold. In cell B11, calculate the amount of profit or loss made from these sales. In cell A11, replace the label with a calculation to determine whether or not the amount in cell B11 is a Profit from Sales or a Loss from Sales as the label (assume that would be considered a Profit rather than a Loss) Adjust the row heights to show the whole label for A11:A14. Tip: use a similar alternative method to adjusting the column-width. In cell B12, calculate how many customers your grandfather has. In cell B13, calculate how many customers bought crabs. In cell B14, calculate the total sale amount for all the customers who bought 10 or more kilograms of mussels. In cell B15, calculate the average number of whole kilograms of seafood sold - mussels and crabs. 11. Align all the summary values so that they appear in the middle of the row (i.e. vertically centred). 112. Add borders around cells as follows: All the report summary cells - A9:B15 - default border style. A Green, Accent 6, Darker 50% thick outside border (default width) around the detail cells A1:B7. 13. Format all the remaining labels (headings) to Bold and all the money results to Currency (not Accounting) to 2 decimal places. 114. Hide columns J to M. 10.Type the formulas to calculate the following: In cell B9, calculate the grand total amount owing for all customers. In cell B10, calculate the total cost amount of all the mussels and crabs sold. In cell B11, calculate the amount of profit or loss made from these sales. In cell A11, replace the label with a calculation to determine whether or not the amount in cell B11 is a Profit from Sales or a Loss from Sales as the label (assume that would be considered a Profit rather than a Loss) Adjust the row heights to show the whole label for A11:A14. Tip: use a similar alternative method to adjusting the column-width. In cell B12, calculate how many customers your grandfather has. In cell B13, calculate how many customers bought crabs. In cell B14, calculate the total sale amount for all the customers who bought 10 or more kilograms of mussels. In cell B15, calculate the average number of whole kilograms of seafood sold - mussels and crabs. 11. Align all the summary values so that they appear in the middle of the row (i.e. vertically centred). 112. Add borders around cells as follows: All the report summary cells - A9:B15 - default border style. A Green, Accent 6, Darker 50% thick outside border (default width) around the detail cells A1:B7. 13. Format all the remaining labels (headings) to Bold and all the money results to Currency (not Accounting) to 2 decimal places. 114. Hide columns J to M

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!