To convert the date 12/14/2014 in cell A1 to text in the format of YYYYMMDD, which is a valid option?

What is the correct term for separating contents from one cell into two by a common character?

If there is text in cell C5 and the formula in cell F10 =SUM(B2:E6) then the formula result will...

Which worksheet function returns the skewness of a distribution?

What is the fastest way to convert an array containing unrelated formulas that begin with the equal sign, but are stored as text into real formulas?

What is the formula for the Mean of a set of numbers?

Statistical methods have been used for statistical analyses. A brief list of the more popular methods as following?

Which of the following function(s) accepts criteria?

Which of the following is/are array formulas?

Which of the following function accepts a range as an input?

What does the Excel 'Reduce file size....' option do? (choose all that apply)