Which of the following functions in MS Excel searches for a specific value in the leftmost column of a table array and returns a value in the same row from a specified column?
Explanation:
VLOOKUP stands for Vertical Lookup. It searches down the leftmost column of a range for a key and returns a value from the specified column in that row.
Explanation:
You can create calculated fields by typing an expression in the Field row of the query design grid, or using the Expression Builder. Both are valid.
No comments yet. Be the first to start the discussion!