Formula Management | MCQs

Explanation

The VLOOKUP function in Excel is used to search for a value in the first column of a range

And return a value in the same row from a specified column.

It is commonly used for looking up data in a table or range.

Explanation

• Type the entire equation: = B1+B2+B3+B4+B5
• Use the SUM function: = SUM(B1: B5)
• Press the Enter key to complete the formula