On the Movies worksheet, in cell B1,(Total Gross Sales) enter a function that will calculate the...

On the Movies worksheet, in cell B1,(Total Gross Sales) enter a function that will calculate the total gross sales for records visible in the table. Format as Accounting. In cell B2(Average Gross Sales), enter a function that will calculate the average gross sales for records visible in the table. Format as Accounting. In cell B3 (Total Movies) enter a function that will calculate the number of movies visible in the table, using the MovieID field.

Total Gross Sales (filtered)
Average Gross Sales (filtered)
Total Movies (filtered)

Budget	Director	Company	Country	Genre	Gross	StarActor	Year	MovieID	MovieName	MovieRating
$ 130,000,000.00	Chris Miller	DreamWorks Animation	USA	Animation	$ 149,260,504.00	Antonio Banderas	2011	Mov-5962	Puss in Boots	PG
$ 30,000,000.00	Mark Waters	Angry Films	USA	Action	$ 7,791,146.00	Zoey Deutch	2014	Mov-7522	Vampire Academy	PG-13
$ 95,000,000.00	Steve Martino	Blue Sky Studios	USA	Animation	$ 161,321,843.00	Ray Romano	2012	Mov-4914	Ice Age: Continental Drift	PG
$ 16,600,000.00	Joachim Rønning	Recorded Picture Company (RPC)	UK	Adventure	$ 1,517,410.00	Pål Sverre Hagen	2012	Mov-8761	Kon-Tiki	PG-13

Expert Solution

Total Gross Sales	$ 319,890,903.00
Average Gross Sales	$ 79,972,725.75
Total Movies	4

ekkarill92 answered 3 years ago

(In cell B15, enter a formula that uses the IF function and tests whether the total...

(In cell B15, enter a formula that uses the IF function and tests whether the total sales for Q1 (cell B8) is greater than or equal to 1000000. If the condition is true, multiply the total sales for Q1 by 0.18 to calculate a commission of 18%. If the condition is false, multiply the total sales for Q1 by 0.10 to calculate a commission of 10%.)

insert an If function in cell 5 to calculate the total due, if the student has...

insert an If function in cell 5 to calculate the total due, if the student has chosen to personalize the ring there is an additional charge of 5% located in cell B12 that must be applied: if not the student only pays the base price. Use appropriate relative and absolute cell references in excel

On the Mortgage worksheet, use the data provided to enter a formula in cell B6 to calculate the principal of the loan that will be required to purchase the house.

Mortgage InformationAnnual Interest Rate4.90%Repayment Years30Price of House$275,000Down Payment$55,000Principal of LoanMonthly PaymentsOn the Mortgage worksheet, use the data provided to enter a formula in cell B6 to calculate the principal of the loan that will be required to purchase the house.On the Mortgage worksheet, use the PMT function in cell B7 to calculate the monthly payments of the mortgage. Use cell locations from this worksheet to define each argument of the function. Assume that payments are made at the end of...

Ensure that the Facilities worksheet is active. Enter a reference to the beginning loan balance in cell B12 and enter a reference to the payment amount in cell C12.

13 Ensure that the Facilities worksheet is active. Enter a reference to the beginning loan balance in cell B12 and enter a reference to the payment amount in cell C12. 14 Enter a function in cell D12, based on the payment and loan details, that calculates the amount of interest paid on the first payment. Be sure to use the appropriate absolute, relative, or mixed cell references. 15 Enter a function in cell E12, based on the payment and loan details, that calculates the amount...

In the green cells calculate total Gross Profit (i.e., Sales - COGS) using the condition(s) as...

In the green cells calculate total Gross Profit (i.e., Sales - COGS) using the condition(s) as specified and without creating a helper column, using Filters, or Pivot Tables. Date Product Region SalesRep Customer Sales COGS Gross Profit 4/19/2020 Product3 Region3 SalesRep2 Customer16 $ 14,046 $ 5,337 All products: 4/19/2020 Product7 Region4 SalesRep15 Customer72 $ 2,504 $ 1,703 Product9 only: 4/19/2020 Product2 Region4 SalesRep18 Customer71 $ 1,505 $ 843 Product3 and SalesRep16 only: 4/19/2020 Product6 Region4 SalesRep14 Customer88 $ 4,232 $ ...

On the Loan worksheet, in cell C9, enter a PMT function to calculate the monthly payment for the Altamonte Springs 2018 facilities loan. Ensure that the function returns a positive value and set the references to cells B5 and B6 as absolute references.

On the Loan worksheet, in cell C9, enter a PMT function to calculate the monthly payment for the Altamonte Springs 2018 facilities loan. Ensure that the function returns a positive value and set the references to cells B5 and B6 as absolute references. Copy the formula to the range C10:C15On the Attendance worksheet, in cell L5, enter an IF function to determine if the percentage in cell K5 is greater than or equal to the goal in cell H18. The...

Please format answer into a table Calculate gross sales, variable costs, and gross margin (profit) for...

Please format answer into a table Calculate gross sales, variable costs, and gross margin (profit) for each product and for an entire company. Calculate break-even sales dollars for a company. Determine the relevant cash flows for a planned asset purchase. Madison Company produces four lines of accessories for major U.S. combine manufacturers. The lines are known by the code letters A, B, C, and D. The current sales mix for Madison Company and the contribution margin ratio for these product...

In cell C6 in the Summary sheet, enter a nested IF function to determine which city...

In cell C6 in the Summary sheet, enter a nested IF function to determine which city had the highest temperature. Based on the result returned in B6, enter the city name as OKC or Tulsa or Lawton in C6. Remember to enclose city names in double quotation marks in the function. Use Help if needed to help you understand a nested IF statement. Copy the formula down the High-City column.

Write a program function code in Python that prompts the user to enter the total of...

Write a program function code in Python that prompts the user to enter the total of his/her purchase and add 5% as the VAT. The program should display the total without and with VAT. ( that mean i should ask the user to enter the number of their item " so i think that i should use range" then print the result with and without the VAT )

Write a Java program in Eclipse to calculate the total cost to enter into a waterpark...

Write a Java program in Eclipse to calculate the total cost to enter into a waterpark for a family/group Ticket rates are listed below kids (Age 12 and under)=$ 12.50 Regular( Age between12 -55) =$ 18.25 Seniors (55 and above) = $15.00 Tax =7% Your program should ask the user to enter the total number of members in their group. User needs to enter the ages for all members. Write appropriate error messages for invalid entries. An array should be...

Question