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+F2), \$\#\#\#\#\#) TEXT( E2*(1+F2), "\$\#\#.\#\#") E2(1+F2) 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