What does the VLOOKUP function do?

  1. Home

Question:
 What does the VLOOKUP function do?

1. Looks up text that contain ‘v’

2.Checks whether text is the same in one cell as in the next

3.Finds related records

4.All of above

Posted Date:-2021-02-11 17:34:13

More MCQS Questions and answers

  1. Each excel file is called a workbook because
  2. What does the VLOOKUP function do?
  3. Which of the following is not an option in the spelling dialog box?
  4. you can use the formula palette to
  5. Your German supplier still invoices for parts in Deutsche marks. How can you have Excel convert those sums to Euros?
  6. 164. Which function calculates your monthly mortage payment?
  7. A function inside another function is called a ….. function.
  8. A user wishes to remove a spreadsheet from a workbook. Which is the correct sequence of events that will do this?
  9. Can you set 0.5 inch left indentation for a cell in Excel?
  10. Excel is a
  11. Formatting a cell in Currency you can specify
  12. Formatting a cell in Number format you can’t set
  13. Gridlines
  14. How are data organized in a spreadsheet?
  15. How should you print a selected area of a worksheet if you’ll want to print a different area next time?
  16. If you are working in English (US) Chinese or Japanese Excel 2002 can speak data as you enter it to help you verify accuracy. How do you activate this feature?
  17. If you need a text to show vertically in a cell. How will you achieve this?
  18. If you press …. the cell accepts your typing as its contents.
  19. Except for the …… function a formula with a logical function shows the word “TRUE” or “FALSE” as a result
  20. Macros are “run” or executed from the ….. menu.
  21. Merge cells option can be applied from
  22. Pre-made sheet formats like Simple Classic Accounting Colorful et can be applied from
  23. Qtr 1 Qtr 2 Qtr 3” is an example of a
  24. Special category of Number tab in Format Cells dialog box can be used to apply formats like
  25. The autofill feature
  26. The cell reference for a range of cells that starts in cell B1 and goes over to column G and down to row 10 is ….
  27. The spelling tool is placed on ______ toolbar
  28. To copy cell contents using drag and drop press the
  29. To create an interactive Pivot Table for the web you use a Microsoft Office Web component called
  30. To protect a worksheet you can choose Protection and the Protect Sheet from the ….. menu
  31. What feature enables you to adjust or back solve the value in a cell to reach a desired outcome in a formula?
  32. What is an expression that tells how the numbers in a determined set of cells are to be calculated?
  33. What is entered by the function =today
  34. What is the keyboard shortcut (button or buttons to be pressed) for creating a chart from the selected cells?
  35. What Pivot Table toolbar button updates the data in a Pivot Table or Pivot Chart report if the source data chas changed
  36. what term describes a background that appears as a grainy non smooth surface
  37. Which function will you use to enter current time in a woksheet cell?
  38. Which of the following is a correct order of precedence in a formula calculation?
  39. Which of the following is not a valid Zoom percentage in Excel?
  40. Which of the following is not a worksheet design criterion?
  41. Which of the following methods can not be used to enter data in a cell?
  42. Which of the following methods cannot be used to edit the content of cell?
  43. Which of the following will not set text in selected cells to italics?
  44. Which types of charts can excel produce?
  45. You can automatically adjust the size of text in a cell if they do not fit in width by
  46. You can edit existing Excel data by pressing the
  47. You can open the consolidate dialog box byt choosing Consolidate from the ….. menu.
  48. You can open the Highlight Changes dialog box by choosing Track Changes from the …. Menu.
  49. You can print only an embedded chart by
  50. You can quickly change the appearance of your work by choosing Auto Format from the …. Menu
Search
Olete Team
Online Exam Test Top Tutorials are Core Java,Hibernate ,Spring,Sturts.The content on Online Exam Test website is done by expert team not only with the help of books but along with the strong professional knowledge in all context like coding,designing, marketing,etc!