Question

Which of the following is not a function in MS Excel?

• A. If
• B. SUM
• C. VLOOKUP
• D. None of these

Answer 1

Answer:

D. None of these

Different Functions in Excel

• Functions are predefined formulas that perform calculations using specific values (arguments) in a particular order.
• SUM: Adds a range of numbers.
•   - Example: `=SUM(A1:A10)` adds the values in cells A1 through A10.
• AVERAGE: Calculates the average of a range of numbers.
•   - Example: `=AVERAGE(B1:B10)` calculates the average of the values in cells B1 through B10.
• - IF: Performs a logical test and returns one value if true and another if false.
•   - Example: `=IF(C1>100, "High", "Low")` returns "High" if the value in C1 is greater than 100, otherwise "Low."
• - VLOOKUP: Looks up a value in the first column of a range and returns a value in the same row from a specified column.
•   - Example: `=VLOOKUP(D1, A1:B10, 2, FALSE)` looks for the value in D1 within the range A1:B10 and returns the corresponding value from the second column.