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

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

Which of the following is/are array formulas?

Which of the following function(s) accepts criteria?

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

Which formulas use absolute references?

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?

Which worksheet function returns the skewness of a distribution?

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

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

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