Need help with how to answer questions on document attached? thank you.

 

EXCEL REVIEW OF FORMULAS and FUNCTIONS:Use the diagram below for question 1:ABCD1287327624318781496205585512621566745801.Evaluate Each:a.=A3-C6/A1+D2b.=MAX(A6:D6)+A3/B2c.=D4+A5*B2-SUM(C5:C7)d.=MIN(A2:D4)+B6/D1e.=(B6-C6)/D1*A72.Write an Excel formula to perform each of the following:a.Add the values stored in cells B4, F4, and H4, and divide the result by theproduct of the values stored in E6 and G6.b.Multiply the value stored in C5 by the average of the values stored in cells C2through C11.c.Subtract the value stored in cell A7 from the value in A3 and divide the resultby the value stored in B9.d.Divide the smallest value stored in cells D3 through D10 by the sum of thevalues stored in cells B15 and F15.3.Write an IF function for cell D6 that checks the value in cell D5 and assigns the value of1 to cell D6 if D5 is 10 and assigns a value of 0 to cell D6 if D5 is not 10.4.Assume cell C4 contains the following entry= E15a.If the fill handle on Cell C4 is dragged to the right one cell to cell D4, whatwill appear in cell D4?b.If the fill handle on cell C4 is dragged down to cell C5, what will appear incell D5?c.If the fill handle on cell C4 is dragged up to cell C3, what will appear in cellC3?d.If the fill handle on cell C4 is dragged left to cell B4, what will appear in cellB4?5.Assume that cell D11 contains the following formula:= K$11 - $F$8 + H12 * $G10If this formula in D11 is copied to the clipboard, and then pasted into cell G7,how will this formula appear in cell G7?

Attachments:

• 1496724948-CGS 1100 Assessment for Excel Learning Outcome 1 1.pdf