1. Based on the figure, which of the following choices is the valee It ralse argun function in cell BII? A. B10>=100 B. The second IF function C. The first IF function D. 100 or More 2. Consider a separate function whe 7$15000,5000,0). What is the value if true? figure above) A. 15000 B. 5000 C. 0 D. 20000 3. Which of the following Excel format codes woald display a month spelled out, A. mm B. tnmenm C. "m"m D. MMm 4. Which of the following is a new coemmand in Fxeel 2013 for recogrizing a patten the patter for matching eellis? A. Atulofither B Advanced Filiet C. Flash Fill D. Prvotrable 1. Based on the figure, which of the following choices is the valee It ralse argun function in cell BII? A. B10>=100 B. The second IF function C. The first IF function D. 100 or More 2. Consider a separate function whe 7$15000,5000,0). What is the value if true? figure above) A. 15000 B. 5000 C. 0 D. 20000 3. Which of the following Excel format codes woald display a month spelled out, A. mm B. tnmenm C. "m"m D. MMm 4. Which of the following is a new coemmand in Fxeel 2013 for recogrizing a patten the patter for matching eellis? A. Atulofither B Advanced Filiet C. Flash Fill D. Prvotrable