help!

What value will the MAXA function return if given the values .02,.07,.09, and NA? 0 .09 NA \#Name 9) When using the 1900 date system, the date 1/1/1900 is equivalent to what number? 0 1 1 .1 If the function =XLOOKUP(H13,C4:C10,B4:B10, "Item Not Found", 1,1) is used, what will happen if an exact match is not found? The function will return the next larger item. The function will retum the next smaller item. The function will perform a wildcard match. The function will retum the value \#NA. 2) What function would most efficiently accomplish the same thing as =(B5+C5+D5+E5+F5)/5 ? =COUNT(B5:F5)=SUM(B5:F5)=AVERAGE(B5:F5)=MEDIAN(B5:F5) When you start to type =AV, what feature displays a list of functions and defined names? Function ScreenTip Function Arguments dialog box Insert Function dialog box Formula Auto Complete 5) Which of the following functions should be used to insert the current date and time in a cell? =NOW() =CURRENT() =DATE =TODAY() Which of the following is not a comparison operator? \&