A D Use this sample excel worksheet of financial data to answer the next three questions WEWN B Order Date Customer Name Sales Representative 1/2/20 A. White Rebecca 1/5/20 Y. Asabere Robert 1/23/20 C. Brown Robert 1/24/20 R. Patel Ravi 6 2/6/20 A. Moore Robert 7 2/28/20 P. Tran Rebecca 3/1/20 P. Kim Rebecca 9 4/10/20 M. Pollett Rebecca 4/11/20 X. Xu Rebecca 11 4/17/20 A. Moore Rebecca 4/20/20 C Brown Jaime 13 4/20/20 C. Brown Jaime D E Units Sold Order Revenue 22 $1,979.78 1 $89.99 512 $46,074.88 4 $359.96 2 $179.98 89 $8,009.11 3 $269.97 40 $3,599.60 32 $2,879.68 85 $7,649.15 30 $2,699.70 1010 $90,889.90 Question 53 1 pts Consult ABC Corp. 2020 Outer MacBook Air esc 20 333 4 11 ! 2 # 3 2 $ 4 5 & 7 6 8 9 0 Q W E R T Y U 1 O i Question 53 Consult ABC Corp. 2020 Orders. To calculate the year-to-date total for units sold in column F, what would you put in cell F2? 0-22 0-1010 O-E2 O-02 Question 54 Consult ABC Corp. 2020 Orders. What is the first step in the calculating year-to-date total for revenue? Ensuring all columns are properly formatted Sorting order revenue in descending order Sorting order date in chronological order Sorting order revenue in ascending order MacBook Air Question 55 What is the general formula for year-to-date totals? O Current value + most recent year to date total -Current value + earliest year to date total -Current value + greatest year to date total Sum of entire column D Question 56 What is the formula for percent change? o (New-Baseline)/New! (Baseline News/Baseline! (New-Baseline)/Baseline (New-Baseline)/Baseline! Macl