Examlex

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?


Definitions:

Related Questions