Solved

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

Question 14

Multiple Choice

Exhibit 15.1
The following questions employ the AON network and partial spreadsheet below. 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 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