Question

Which of the following is NOT present in the function library category in MS - Excel 2007?
1. Logical
2. Series
3. Financial
4. Text

Answer 1

Correct Answer - Option 2 : Series

The correct answer is Series.

• MS Excel
  • It is a spreadsheet program for data analysis and documentation.
  • It contains a number of rows and columns where the intersection of a column and a row is a "cell".
  • Each cell contains one point of data.
  • It is developed by Microsoft.
  • It features calculation, graphing tools, pivot tables, etc
• Main Functions in MS Excel ​

1. Count and Sum: Countif, Count Characters, Not Equal to, etc.
2. Logical: If, Comparision Operators, Or, Roll the Dice, etc.
3. Cell References: Relative, absolute, and mixed reference
4. Date & Time: Characters like "/" and ":" used to enter date & time.
5. Text: Excel has many functions to offer when it comes to manipulating text strings.
6. Lookup & Reference: VLOOKUP, HLOOKUP, etc.
7. Financial: This function illustrates Excel's most popular financial functions.
8. Statistical: Statistical function in Excel.