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

C2 x K L B C D E F H 1 J Total Gross Sales 1 (filtered) Average Gross Sales 2 (filtered) Total Movies 3 (filtered) 4 5 Budget Directo Company Country Genre -7 Gross - StarActor Year MovielD - MovieName 6 $ 130,000,000.00 Chris Miller DreamWorks Animation USA Animation $ 149,260,504.00 Antonio Bandera 2011| Mov-5962 Puss in Boots 8 $ 30,000,000.00 Mark Waters Angry Films USA Action $ 7.791.146.00 Zoey Deutch 2014) Mov-7522 Vampire Academy 19 $ 95,000,000.00 Steve Martino Blue Sky Studios USA Animation $ 161,321,843.00 Ray Romano 2012 Mov-4914 Ice Age: Continental Drift 16,600,000.00 Joachim Rnning Recorded Picture Company (RPC) UK Adventures 1,517,410.00 Pl Sverre Hagen 2012 Mov-8761 Kon-Tiki 33 34 35 Data from Move Industry: Three Decades of Movies" compiled by Daniel Grijalva, https://www.kaggle.com/danielgrijalvas/movies/data 36 37 38 39 40 41 MovieRating - PG PG-13 PG PG-13 42 43 44 45 46