PivotTable and PivotChart reports provide ways to calculate and summarize your data. You can enhance the results by writing your own formulas to create calculated fields and calculated items. Which of the following is not true for Calculated items in PivotTable?

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 formula =VLOOKUP(A1,B2:D100,3,0) returns a result from column:

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?