Question 1. - The discount in Cell D4 must be applied to Cells C2:C4. What is the correct formula for Cell C2? A. B2-($D$4*A2) B. B2-($D4*B2) C. B2-(E2*B2) =$B$2-($D4*B2) D. B2-($E$2*B2) =B2-(D$4*$B$2)

Question 2. - What formula would produce the value in Cell C18? A. CONCATENATE(A18, , , B18) B. COMBINA(A18, B18) C. FULLADDRESS(A18, B18) D. COMBINA(A18, B18

Question 3

What is the correct way to sort Data

Record the journal entry needed for a plane ticket payment for Jane Smith from the admin department. The ticket is from xyz travel agency for the amount of $2000.00 from Newyork to California and it is due July 15th. Is this an income or expense transaction?

Invoice #563603 xyz company LTD Professional and Legal Services through 5/31/19 Amount: $18,000.00 Payment is due in full upon receipt

\begin{tabular}{|l|c|c|c|} \hline & A & B & C \\ \hline 17 & City & State & City and State \\ \hline 18 & Montpelier & VT & Montpelier, VT \\ \hline 19 & Concord & NH & \\ \hline 20 & Hartford & CT & \\ \hline 21 & Springfield & MA & \\ \hline & & & \end{tabular} A. Find the Conditional Formatting option, and then choose New Rule. B. Find the Data option, and then choose Refresh All. C. Find the Sort \& Filter option, and then choose Filter. D. Find the Sort \& Filter option, and then choose Custom Sort. General Journal H Date Memo General Journal H Date Memo \begin{tabular}{|l|c|c|c|} \hline & A & B & C \\ \hline 17 & City & State & City and State \\ \hline 18 & Montpelier & VT & Montpelier, VT \\ \hline 19 & Concord & NH & \\ \hline 20 & Hartford & CT & \\ \hline 21 & Springfield & MA & \\ \hline & & & \end{tabular} A. Find the Conditional Formatting option, and then choose New Rule. B. Find the Data option, and then choose Refresh All. C. Find the Sort \& Filter option, and then choose Filter. D. Find the Sort \& Filter option, and then choose Custom Sort. General Journal H Date Memo General Journal H Date Memo