What does the VLOOKUP function do? – McqOptions

MCQOPTIONS

1.	What does the VLOOKUP function do?
A.	Looks up text that contain v
B.	Checks whether text is the same in one cell as in the next
C.	Finds related records
D.	All of above
Answer» D. All of above

Discussion

No Comment Found

Related MCQs

<p>Which among the following will not set text in selected cells to italics?</p>
<p>Youar German supplier still invoices for parts in deutsche marks. How does Excel convert those sums to Euros?</p>
<p>Which among the following methods can not be used to enter data in a cell?</p>
<p>How should you print a selected area of a worksheet if a different area needs to printed ?</p>
<p>What is a function inside another function is called ?</p>
<p>Which among the following is a correct order of precedence in a formula calculation?</p>
<p>What kind of charts can an excel produce ?</p>
<p>You can open the Highlight Changes dialog box by choosing Track Changes from the . Menu.</p>
<p>To protect a worksheet, you can choose Protection and the Protect Sheet from the .. menu</p>
<p>You can quickly change the appearance of your work by choosing Auto Format from the . Menu</p>