Rate1 Rate2 Year 1 Year 2 Increase 10%-10%! 0.3 15% 10 0.2 0.304 20% 10% 0.4 25% ins. Questions 38-39 Figure 8. If you copy the formula in cell E2 ( C2*SA$2+D2 SB$2) to cell E3 in above graph, what will be the number in E3? a 0.03 b. 0.035 c. 0.06 d. 0.15 39. If you change the formula in cell E2 to ( C2 SA2+D2 $82), what will be the number in E3? a. 0.035 b. 0.06 c. 0.1 d. 0.15 40. If an Excel problem is to determine how many units of each of three products should be sold to reach a certain profit, which of the following tools would likely be the best choice? a. Goal Seek b. Scenario c. Trendline d. Solver Extra Credit Questions (41-44) 41. Selecting the Column G& H then choose Insert>Column, What will happen? a. 2 Columns will be inserted after Column F b. 2 Columns will be inserted after Column G c. 2 Columns will be inserted after Column H d. 2 Columns will be inserted after Column I 42. Which of the following is an incorrect enterprise view of information technology a. Processes are analytical for executives and transactional for analysts b. Granularity is coarse for executives and fine for analysts. c. Processing is OLTP for executives and OLAP for analysts. d. None of these