Chapter 10, Problem 12ICA

Write the output value that would appear in a cell if the equation were executed in Excel. You should answer these questions WITHOUT actually using Excel, as practice for the exam. If the cell will appear blank, write “BLANK” in the space provided.

	= IF(OR(C1 > D3, D3 < E1), “YES”, “NO”)	Output
(a)	C1 = 10   E1 = –5   D3 = 0.1*C1^(– 5*E1)
(b)	C1 = 10   E1 = 5   D3 = 0.1*C1^(–5*E1)
	= IF(AND(G4/H3 > 2, H3 > 3), G4, MAX(2, G4, H3, 5*J2-10))	Output
(c)	G4 = 30   H3 = 5   J2 = 2
(d)	G4 = 10   H3 = 8   J2 = 10