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)

Budget	Director	Company	Country	Genre	Gross	character	Year	movie	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

Answer rating: 100% (QA)

Answer Total Gro... View the full answer