> > >

Microsoft Office MCQs

In Microsoft Excel 2010, The LOOKUP function returns a value either from a one-row or one-column range or from an array. Which of the following statements are true regarding the LOOKUP function in Microsoft Excel 2010?

lookup_value is an optional argument of the LOOKUP function in Microsoft Excel 2010 when the vector form is used.

The values in the array used by the LOOKUP function in Microsoft Excel 2010 must be in the ascending order.

If the array used by the LOOKUP function in Microsoft Excel 2010 contains more columns than rows, then LOOKUP searches for the value of lookup_value in the first column.

If the array used by the LOOKUP function in Microsoft Excel 2010 contains more rows than columns, then LOOKUP searches for the value of lookup_value in the first column.

Answer

Correct Answer: The values in the array used by the LOOKUP function in Microsoft Excel 2010 must be in the ascending order.

Explanation:

Note: This Question is unanswered, help us to find answer for this one

Microsoft Office Skill Assessment

Your Skill Level: Poor

Retake Quizzes to improve it

More Microsoft Office MCQ Questions

What will happen if the Junk E-mail filter of Microsoft Outlook 2010 does NOT consider a message to be spam but considers it to be phishing?

Suppose that you have selected some text in a Microsoft Word 2016 document and you want to strikethrough that selected text, then which of the following keyboard shortcuts will you use?

Which functional key is used for spelling and grammar check in a Microsoft Word 2016 document?

Which type of circle represent(s) the top of the hierarchy in a Sunburst chart in Microsoft Word 2016,?

Which is correct about subtotal and total fields in a Microsoft Excel 2016 PivotTable report?

Which option is NOT a default watermark in the Watermark gallery in Microsoft Word 2016?

Microsoft Office Skill Assessment

Login to see Skill Score (It's Free)

Your Skill Level: Poor

Retake Quizzes to improve it