70.2K

Verified Solution

Link Copied!

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 A -15 32 48 1 2 3 4 5 B 4.5 6 3.5 -1.3 -1.5 (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 D1 in the table above, then copied and pasted into cell E3. Your job is to complete the table below, indicating in the right column the formula that would appear in cell E3 after copying the formula from D1 to cell E3. Formula in D1 Resulting Formula in E3 =C3"B4 =A1+B$1 =SUM(A$1:B$3)/6 (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:B3Y/SUM(C1.C3) =MIN(SAS1:$B$3)-19

Answer & Explanation Solved by verified expert

See Answer