Which of the following is not a function in MS Excel?
AIf
BSUM
CVLOOKUP
DNone of these
Answer:
D. None of these
Read Explanation:
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.