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

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 formula uses the MAX function combined with IF and ISERR to find the maximum value from a range, which is a common approach to calculate the earliest start time in project management tasks.

The Following Questions Employ the AON Network and Partial Spreadsheet