Excel recognizes certain values, such as ____ and Quarter 1, as parts of larger lists. When you drag the fill handle from a cell containing one of these values, Excel fills the cells with the appropriate series?

Select Home->Fill->Series. Excel displays the Series dialog box. Which of the following represent the 'Growth' type?

Multiple calculations can be made in a single formula using?

Which of the following statements is True Using PivotTables and Charts?

Excel provides the following analysis features for instant data analysis, Choose a True statements?

The following formula uses Get last name from name?

Which worksheet function returns the smallest value for which the cumulative binomial distribution is less than or equal to a criterion value?

What will F11 command do?

What tab would you use to format a section of text as a table?

I have a column of values in ranges A2:A100 that I need to concatenate with the number 2. Which of the following is not a way to do this?

The values for A1:A5 are A1=1, A2=3, A3=2, A4=5, A5=4. The formula PERCENTRANK(A1:A5,A2) returns the value: