MS Excel Assessment

Exit

Question 1 of 1

  Time Left


0
72195
0
120
block

Open the Module 16 'Springvale' Exercise. Change the value of cell E4 to €1000 and create an Autosum function inside cell E11 fro the range E4 to E9. What should the IF statement be in cell B11 to ensure the Total inside E11 does not go outside its range?

Select the Correct Answers  

(0/0)














72196
0
120
none
72198
0
120
none
72199
0
120
none
72200
0
120
none
71690
0
120
none
72202
0
120
none
72203
0
120
none
72204
0
120
none
71693
0
120
none
72205
0
120
none
72206
0
120
none
71695
0
120
none
72208
0
120
none
71698
0
120
none