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 E5 to calculate the Earliest Start Time?
A) E2 + D2
B) MAX(IF(ISERR(FIND($A$5:$A$17,C5)),0,$F$5:$F$17))
C) H2 − D2
D) MIN(IF(ISNUMBER(FIND(A5,$C$2:$C$8)),$G$2:$G$8))

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 E5 to calculate the Earliest Start Time?
A) E2 + D2 
B) MAX(IF(ISERR(FIND($A$5:$A$17,C5)),0,$F$5:$F$17)) 
C) H2 − D2 
D) MIN(IF(ISNUMBER(FIND(A5,$C$2:$C$8)),$G$2:$G$8))

Quizplus · Accepted Answer

The array formula in cell E5 calculates the Earliest Start Time by finding the maximum value of Finish Time (column F) for each Task ID (column A) that has a predecessor of C5. This is done using the IF, FIND, and ISERR functions together with an array formula.

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