1. In cell H11, create a formula to give the total cost of the order. Copy and p
ID: 2508391 • Letter: 1
Question
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 78Explanation / Answer
1. In Cell H11 enter
=F11*G11
Copy cell H11 and paste in remaining column.
2. In Cell I11 enter
=F11+(F11*0.0825)
Copy cell I11 and paste in remaining column.
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.