Solved

The Following Questions Employ the AON Network and Partial Spreadsheet

Question 41

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

Correct Answer:

verifed

Verified

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

Related Questions

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

Q35: Exhibit 15.4<br>The following questions are based on

Q37: <br>The following questions are based on the

Q43: A company wants to use PERT to

Q44: <br>The following questions are based on the

Q45: <br>The following questions are based on the

Q46: How many paths are there in the

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

Q67: Exhibit 15.3<br>The following questions are based on

Q72: If we are employing Activity-On-Arc (AOA) network