Use the following spreadsheets to answer the question B D H ID Book Title Publication Category 1 Revenues Downloadable? Digital Date Audio CD? Format? 2H5521 A Great Getaway History 1/10/2020 $21.400 Yes TRUE 3 BG789 Down Memory Lane Biographies 1/16/2020 $24,870 No No FALSE 4. MS533 The Murder Club Mystery ft Suspense 2/22/2020 $23.145 No Yes TRUE 5 CB325 Eating Well Cookbooks 3/13/2020 $15, 220 No No FALSE 6 RM622 Beyond the Stars Romance 4/28/2020 $15.000 Yes Yes TRUE 7 CB453 Susan's Kitchen Cookbooks 6/7/2020 $11 250 No No FALSE CD697 My Favorite Things Children's 7/28/2020 $17,960 No No FALSE 9 BG720 My Life's Work Biographies 8/4/2020 $16.490 Yes Yes TRUE 10 CD512 The Friendly Moose Children's 8/17/2020 $11.670 No Yes TRUE 11 MS328 The Last Night Mystery Suspense 9/23/2020 $19.810 No Yes TRUE 12 MS210 Dark Waters Mystery & Suspense 10/6/2020 $13,782 Yes Yes TRUE 13 HS329 Traveling Through Time History 11/9/2020 S9 M5 No No FALSE The spreadsheet shown above is for Hometown Booksellers, Inc. The spreadsheet shows revenues earned from books published and sold during 2020. The financial manager for the company entered a formula in cell N7 below that calculated average revenues for books with a Category of Biographies. M N 5 Category 6 Biographies 7 Average Revenues $20,680 Which of the following formulas could have been used in cell N7? 1. AVERAGEIF(A1:H13,"Revenues".M5:M6) 2. -AVERAGEIF(C1:C13,M6,E1E13) 3. -DAVERAGE(C1:C13,M6.E1:13) 4.-DAVERAGE(A1:H13,"Revenues".MS:M6) 4 only 1 and 4