undefined
The following table, scraped from finance.yahoo.com, shows the historical daily prices of Facebook (NASDAQ: FB) from the time the company went public (Friday, May 18, 2012) to June 29, 2012. The Facebook CEO would like to learn how many times the closing price (close) less the opening price (open) was greater than $0.75. Which of the following steps accomplishes this task? Assume you are using empty column I for your operations. B D E G H 1 2 3 4 5 2012-05-18 9 10 12 13 14 15 16 17 18 19 20 21 22 23 24 25 20 26 27 28 29 30 31 CSC 105, Spring 2013 - Introduction to Information Technology Date Open High Low Close Volume Adj Close | SEL 38.22 573976400 8.23 2012-05-21 36.53 36.66 33 34.00 1681927001 34.03 |2012-05-22 32.61 30.94 31 1101788808 31 |2012-06-23 31.37 32.51 31.38 32 73800000 32 2012-05-24 32.50 33.21 31.77 33.00 50237200 33.03 2012-05-23 32 31.11 31,911 37149800 31.91 |2012-05-29 31.481 31.691 28.65 28.8476003000 28.84 2012-06-30 28.1 29.55 27.80 28.15 572579001 28.19 2012-05-31 20.50 29.67 26.33 29. 111639200 29.6 2012-06-01 28.86 27.39 27.72 41855500 27.72 2012-06-04 27.2 27.85 26.44 28.5 35230301 26.9 2012-06-05 26.7 27.76 25.75 25.07 42473400 25.07 |2012-06-06 26.07 27.17 25.52 26.61 61499200 26.01 2012-06-07 27 27.35 26.15 26.31 281595001 26.31 2012-06-08 27.78 26.44 27.01 58034000 27.1 |2012-06-11 27.10 20.07 26.04 27.01 20219600 27.01 |2012-06-12 27.48 27.77 26.95 27415816800 274 |2012-08-13 27.681 27.1 27.27 17102800 27.27 |2012-08-14 27.68 27.38 20.25 16855000 28.29 2012-06-13 20.51 30.1 28.35 30.01 43563 30.01 2012-06-18 29.96 32.00 29.41 31.41 42978900 31.41 2012-06-19 31.54 32.18 30.7 31.91 30849000 81.91 2012-06-20 31.931 31.15 31.6 1555360 31.6 2012-06-21 31.67 32.31 31.51 31.84 218753001 31.84 |2012-06-22 32.41 33.45 92.08 33.00 748340001 33.05 2012-08-25 32.81 353.021 31.55 32.00 24352900 32.05 |2012-06-20 32.60 32.5 33.1 243507001 33.1 2012-06-27 32.46 32 32.8 31.9 314 32 23 28568000 32 23 2012-06-28 31.cel 32.191 30.9 31.38 17713300 31.38 |2012-08 20 31.94 31.991 30.76 31.11 19520900 31.1 34 A. Use the following IF statement starting at cell 15 and dragging down to cell 134 =IF(NOT(F5-C5>0.75), 1.0) Next, use the following SUM function: =SUM(15:134) B. Use the following IF statement starting at cell 15 and dragging down to cell 134: =IF(ABS(F5 - C5)>0.75, 1.0) Next, use the following SUM function: =SUM(15:134) C. Use the following IF statement starting at cell 15 and dragging down to cell 134: =IF(F5 - C5>0.75, 1.0) Next, use the following SUM function: =SUM(15:134) D. Use the following IF statement starting at cell 15 and dragging down to cell 134: =IF(|F5 - C5>0.75, 1.0) Next, use the following SUM function: =SUM15:134) E. Use the following IF statement starting at cell 15 and dragging down to cell 134: =IF($F$5 - $C$5>0.75, 1, 0) Next, use the following SUM function: O=SUM 15:134)
