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 2 years ago

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.

Calculate the gross margin in dollars and percentage for thehome department if:Net sales =...

Calculate the gross margin in dollars and percentage for the home department if:Net sales = 140,000Billed cost of merchandise = $84,000Cost discount = 7.5%Shipping charges = $240

7.In cell N2, enter a formula using the IF function as follows to determine which work...

7.In cell N2, enter a formula using the IF function as follows to determine which work tier Kay Colbert is qualified for: a.The IF function should determine if the student's Post-Secondary Years is greater than or equal to 4, and return the value 2 if true or the value 1 if false.

The movie industry is a competitive business. The opening weekend gross sales ($ millions), the total...

The movie industry is a competitive business. The opening weekend gross sales ($ millions), the total gross sales ($ millions), the number of theaters the movie was shown in, and the number of weeks the movie was in release are common variables used to measure the success of a movie. Data on the top 100 grossing movies released in 2016 (Box Office Mojo website) are contained in the attached Excel file. We will use the numerical methods of descriptive statistics...

Question