Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please answer questions 4 - 6 : Use the data below for questions 4 - 6 . The data shows orders at an online retailer.

Please answer questions 4-6: Use the data below for questions 4-6. The data shows orders at an online retailer. 4. What formula would one use to display the State Sales Tax in the "Desired Output" formula shown in column H? That is,8.82% for IL,5.43% for WI, and so on. TEXT($F$4,"#.##%") TEXT(F4,"#.##%") F4 TEXT(F$4,"#.##%") TEXT($F4, #.##%)5. What formula would one use to display the order total Order Subtotal*(1+ State Tax Rate ) in the "Desired Output" formula shown in column H ? TEXT(E2^(1+F 2)., $#####) TEXT( E2*(1+F2),"$##.##") E 2^(1+F 2) TEXT("E2*(1+F2)","$###.##")6. Using concatenation, how would you construct the "Desired Output" formula above? Call State Tax Rate formula (selected question 4): TAX Call Order Total formula (selected in question 5): OrderTotal ="Total including" & C2 & "state sales tax of" & TAX& "is:" & Order Total ="Total including"&C2 & "state sales tax of" & TAX& " is:" & OrderTotal ="Total including " & C2 & " state sales tax of " & " TAX" & " is: " & " OrderTotal" ="Total including " & C2 & " state sales tax of " & TAX& " is: " & OrderTotal

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions