Format cell Range A12: J27 as an Excel Table. Be sure to include a Total Row (Table Tools Design Tab Table Style Options) and apply the following: SUM for all numeric values Count under Date Booked. Apply the Dollar sign symbol to the monetary totals Decrease decimal for number of travelers so it displays a whole number.

Oceana Cruises Summer Season Luxury Cruise Packages (6/1/21 through 8/31/21) Per Person Package Information (does not include air travel) $ 599.00 Destination Cost Assumptions Air Travel Per Person Early Booking Discount Threshold (before) Early Booking Discount Rate 4/1/2021 15.00% $ $ Caribbean Mediterranean Panama Canal South Pacific 1,799.00 3,299.00 2,799.00 $ 3,849.00 Client Shalala, Donna Trout, Patricia Vagelos, Paul Schuda, Jay Oliver, Deby Rose, Ann C Leatherman, Courtney Azevedo, Tricia Cook, Pamela Gyorog, Mike Chu, Johnathon Richstone, Ellen Epstein, Lee Valentino, Elizabeth Delman, Amy Destination Air Travel Date Booked Number of Travel Total Cruise Cosy Total Air Travel Cd Total Travel Package Cos Early Booking Discoun Net Travel Package Cost (5) Caribbean INo 1/17/20211 1 South Pacific Yes 1/28/2021 2 Panama Canal Yes 2/3/2021 1 Caribbean Yes 2/5/2021 1 Caribbean No 3/13/2021 3 Panama Canal No 3/15/2021 2 Mediterranean Yes 3/30/2021 2 Mediterranean Yes 3/31/2021 2 Panama Canal No 4/4/2021 2 Caribbean No 4/11/2021 2 Caribbean INo 4/19/2021 2 South Pacific Yes 4/20/2021 2 Mediterranean Yes 4/21/2021 3 South Pacific Yes 4/24/2021 2 Panama Canal Yes 5/1/2021 2 21 Oceana Cruises Summer Season Luxury Cruise Packages (6/1/21 through 8/31/21) Per Person Package Information (does not include air travel) $ 599.00 Destination Cost Assumptions Air Travel Per Person Early Booking Discount Threshold (before) Early Booking Discount Rate 4/1/2021 15.00% $ $ Caribbean Mediterranean Panama Canal South Pacific 1,799.00 3,299.00 2,799.00 $ 3,849.00 Client Shalala, Donna Trout, Patricia Vagelos, Paul Schuda, Jay Oliver, Deby Rose, Ann C Leatherman, Courtney Azevedo, Tricia Cook, Pamela Gyorog, Mike Chu, Johnathon Richstone, Ellen Epstein, Lee Valentino, Elizabeth Delman, Amy Destination Air Travel Date Booked Number of Travel Total Cruise Cosy Total Air Travel Cd Total Travel Package Cos Early Booking Discoun Net Travel Package Cost (5) Caribbean INo 1/17/20211 1 South Pacific Yes 1/28/2021 2 Panama Canal Yes 2/3/2021 1 Caribbean Yes 2/5/2021 1 Caribbean No 3/13/2021 3 Panama Canal No 3/15/2021 2 Mediterranean Yes 3/30/2021 2 Mediterranean Yes 3/31/2021 2 Panama Canal No 4/4/2021 2 Caribbean No 4/11/2021 2 Caribbean INo 4/19/2021 2 South Pacific Yes 4/20/2021 2 Mediterranean Yes 4/21/2021 3 South Pacific Yes 4/24/2021 2 Panama Canal Yes 5/1/2021 2 21