Exhibit 15.1
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))

Question

Exhibit 15.1
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))

Quizplus · Accepted Answer

The Answer of Exhibit 15.1
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))

Exhibit 15.1 The Following Questions Employ the AON Network and Partial Spreadsheet