Please answer parts A and B using the table.

Answer all questions in the exam. Most questions ask you to provide formulas. When providing formulas, use cells references whenever possible. Assume that actual numbers in cells could change, so do not enter the number in a cell, but reference the cell or cell range. Use formulas that are as simple and uncomplicated as possible and be sure to use Excel symbols. QUESTION 1: Consider the table below: D E 1 2 3 4 5 A -21 23 30 B 7.5 5.0 4.5 4.3 C -3.3 -2.5 -2.7 -2.1 (A): 6 Pts) 2-POINTS FOR EACH ENTRY IN THE TABLE BELOW. Look at the next table. In the left column you see three formulas. Assume each of these three formulas is entered into cell B2 in the table above, then copied and pasted into cell E5. Your job is to complete the table below, indicating in the right column the formula that would appear in cell E5 after copying the formula from B2 to cell E5, Formula in B2 Resulting Formula in E5 =C3 B4 =A1+B$1 =SUM(A$2:B$3)/9 (B): (6 Pts) 2-POINTS FOR EACH ENTRY IN THE TABLE BELOW. In this next table, in the right column enter the number that would appear in cell E2 if the formula in the left column was in cell E2. (Be sure to show your work) Formula in E2 Number appearing in Cell E2 based on the formula in the left column =C2"$A$3 =SUM(B1:B3)/SUM(C1:03) =MIN($A$1:$B$3)+31