You have been asked to determine whether the grand total yearly sales goals were met. The 2019 yearly sales goals were met if the yearly sales were $25,000,000 or more. In cell G36, using a logical function, determine whether the yearly sales goals were met. Set the formula to return a value of Yes if the goal was met or a value of No if the goal was not met.

X Calibri 11 A General Paste B IU .. A $ ~ % ) 60 .000 Conditional Format as Formatting Table Styles Clipboard Font Alignment Number G26 fic H | A B D E F 25 Jeans 445,321 446,123 449,154 451,876 1,792,474 26 Outerwear 445,321 446,123 449,154 451,876 1,792,474 27 Pants 445,321 446,123 449,154 451,876 1,792,474 28 Shorts 445,321 446,123 449,154 451,876 1,792,474 29 Sleepwear 445,321 446,123 449,154 451,876 1,792,474 30 Socks 445,321 446,123 449,154 451,876 1,792,474 31 Sweaters 445,321 446,123 449,154 451,876 1,792,474 32 Swimsuits 445,321 446,123 449,154 451,876 1,792,474 33 Total 5,343,852 5,353,476 5,389,848 5,422,512 21,509,688 34 35 Quarter 1 Quarter 2 Quarter 3 Quarter 4 Yearly Sales Sales Goal Met? 36 Grand Total 14,161,032 $ 14,302,800 14,185,092 14,307,012 56,955,936 37 Women's % of Sales 62% 63% 62% 62% 38 Men's % of Sales 38% 37% 38% 38% 39 40