1. In cell H11, create a formula to give the total cost of the order. Copy and paste the formula down through the rest of the database to generate the total cost for each order listed.

2. In Cell I11, create a formula resulting in the total sale of the order using the total cost generated in the question before and a sales tax of 8.25%.

Inset Dw Page Layout Formulas Data Review View Hep Tel mewhet File Calbr Dh Copy Calculation Form at Panter B 1 u % , |-8-2 | Conditional Format as check Cell Linked Cell Note Formatting Table East SouthWhitman Sofvino Nested Rep IF Unit Cost Total Cost Total ? ? Sheetsheet2Sheet3 - O Type here to search 99 09 29 39 49 59 $ 79 89 eek 99-99-99 00 99 99-99-99-99 29 99 99 9-99 3 3 3 20-3 00 95-9 en al al -al-al aa -ra-ra-ra -ra 1 2 om 12 13 14 15 16 17 18 19 21 22 23 24 25 20 27-28 29 31 32 34 35 36 37 38 39 40 41 42 43 4 5 78