Solved

The Following Questions Employ the AON Network and Partial Spreadsheet

Question 13

Multiple Choice


The following questions employ the AON network and partial spreadsheet below. The following questions employ the AON network and partial spreadsheet below. -Refer to Exhibit 15.1. What array formula is placed in cell H5 to calculate the Latest Finish Time? A) E2 + D2 B) MAX(IF(ISNUMBER(FIND($A$2:$A$8,C5) ) ,$F$2:$F$8) ) C) H2 - D2 D) MIN(IF(ISERR(FIND(A5,$C$5:$C$17) ) ,MAX($F$5:$F$17) ,$G$5:$G$17) ) The following questions employ the AON network and partial spreadsheet below. -Refer to Exhibit 15.1. What array formula is placed in cell H5 to calculate the Latest Finish Time? A) E2 + D2 B) MAX(IF(ISNUMBER(FIND($A$2:$A$8,C5) ) ,$F$2:$F$8) ) C) H2 - D2 D) MIN(IF(ISERR(FIND(A5,$C$5:$C$17) ) ,MAX($F$5:$F$17) ,$G$5:$G$17) )
-Refer to Exhibit 15.1. What array formula is placed in cell H5 to calculate the Latest Finish Time?


A) E2 + D2
B) MAX(IF(ISNUMBER(FIND($A$2:$A$8,C5) ) ,$F$2:$F$8) )
C) H2 - D2
D) MIN(IF(ISERR(FIND(A5,$C$5:$C$17) ) ,MAX($F$5:$F$17) ,$G$5:$G$17) )

Correct Answer:

verifed

Verified

Unlock this answer now
Get Access to more Verified Answers free of charge

Related Questions

Q7: Exhibit 15.1<br>The following questions employ the AON

Q10: One of PERT's bold assumptions is that<br>A)

Q21: Exhibit 15.2<br>The following questions employ the AON

Q23: Exhibit 15.1<br>The following questions employ the AON

Q26: Exhibit 15.5<br>The following questions use the information

Q31: Exhibit 15.1<br>The following questions employ the AON

Q39: Exhibit 15.6<br>The following questions use the information

Q53: Exhibit 14.13<br>The following questions use the information

Q63: Exhibit 15.5<br>The following questions use the information

Q70: Exhibit 14.13<br>The following questions use the information