On the Movies worksheet, in cell B1,(Total Gross Sales)

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 movie field.

Total Gross Sales
(filtered)
Average Gross Sales
(filtered)
Total Movies
(filtered)
BudgetDirectorCompanyCountryGenreGrosscharacterYearmovieMovieNameMovieRating
$      130,000,000.00Chris MillerDreamWorks AnimationUSAAnimation$ 149,260,504.00Antonio Banderas2011Mov-5962Puss in BootsPG
$        30,000,000.00Mark WatersAngry FilmsUSAAction$     7,791,146.00Zoey Deutch2014Mov-7522Vampire AcademyPG-13
$        95,000,000.00Steve MartinoBlue Sky StudiosUSAAnimation$ 161,321,843.00Ray Romano2012Mov-4914Ice Age: Continental DriftPG
$        16,600,000.00Joachim RønningRecorded Picture Company (RPC)UKAdventure$     1,517,410.00Pål Sverre Hagen2012Mov-8761Kon-TikiPG-13

Members

  • Access to 2 Million+ Textbook solutions
  • Ask any question from 24/7 available
    Tutors
$9.99
VIEW SOLUTION

OR

Non-Members

Get help from Accounting Tutors
Ask questions directly from Qualified Online Accounting Tutors.
Best for online homework assistance.