When you start to type =AV, what feature displays a list of functions and defined names?

If you autofill the formula =RANK.AVG(A1,$A$1:$A$5,0 ) from B1 to B5, what would the value be in B5?

A B 1 7 2 5 3 8 4 9 5 7 A) 4 B) 3 C) 4.5 D) 3.5

Which of the following file formats is similar to PDF, but is not so popular?

A. XML B. XPS C. DOC D. XPL