Fully Paid Yes Yes Client ID 4153 Job Number Date 4148 2020/7/2 4149 2020/7/5 4150 2020/7/8 4151 2020/7/13 4152 2020/7/17 4153 2020/7/20 4154 2020/7/24 4155 2020/7/26 Client ID 15928 15458 14051 17769 20626 19488 17464 13824 Client Name Ebony Telecoms AHA Networks Euro- Chirah Technold Epsilon Tech Shaw Constructi Revenue $7, 335.00 $10, 571.00 $5, 488.00 $23, 128.00 $16, 456.00 $17, 585.00 $17, 596.00 $19,503.00 Highest Reven $23, 128.00 Yes Yes Yes Wiz Labs Use the data above to answer the following multiple choice questions. For each question change the correct option to TRUE (it will change to green), leave the others FALSE. 1 A B C D Hoy nany rots in an excel yorksheet? Infinite 1048576 1024 16384 FALSE TRUE FALSE FALSE 2 A Thich of the following is a relative cell reference? $B$3 B3 $B3 B$3 FALSE TRUE FALSE FALSE 3 A B Humbers in Excel autoratically align Bottom Left Top Right Top Left Bottom Right FALSE FALSE FALSE TRUE D 4 The fornula =COUNT(E6:F13) vill return 16 15 8 B D FALSE FALSE FALSE FALSE An error 5 A B C D Thich of the folloving rould calculate average revenue? = (F6:F13) /8 =AVG (F6:F13) '=AVERAGEIFS(F6:F13) =AVERAGE (F6:F13) FALSE FALSE FALSE TRUE full? 6 A B C D Thich for ula vill correctly calculate hor rany clients have paid in =COUNT (G6:G13) FALSE =SUM (G6:G13) FALSE =SUMIFS (G6:G13, "Yes") FALSE =COUNTIFS(G6:G13, "Yes") TRUE B D The fornula =VLOOKUP (19, B6:G13, 1, FALSE) vill return an error, why? Because the lookup value is not in the first column FALSE Because it is a range lookup FALSE Because it is an exact match lookup FALSE Because the lookup range has not been made absolute FALSE 8 A B C D The fornula =IF (AND (F13>19000, G13'Yes'), 'Call', 'No Call') vill return No Call FALSE An error FALSE Yes FALSE Call FALSE