20 TOP Ms Excel Multiple Choice Questions and Answers

List of top 20 most frequently asked ms excel multiple choice questions and answers pdf download free

Ms Excel Multiple Choice Questions and Answers List

  1. What function displays row data in a column or column data in a row?
  2. When you insert an Excel file into a Word document, the data are
  3. Except for the …… function, a formula with a logical function shows the word “TRUE” or “FALSE” as a result
  4. Macros are “run” or executed from the ….. Menu.
  5. You can open the consolidate dialog box byte choosing Consolidate from the ….. Menu.
  6. Each excel file is called a workbook because
  7. Which types of charts can excel produce?
  8. How are data organized in a spreadsheet?
  9. What does the VLOOKUP function do?
  10. Gridlines
  11. You can print only an embedded chart by
  12. Which of the following is a correct order of precedence in a formula calculation?
  13. A function inside another function is called a ….. Function.
  14. How should you print a selected area of a worksheet, if you’ll want to print a different area next time?
  15. Your German supplier still invoices for parts in deutsche marks. How can you have Excel convert those sums to Euros?
  16. Which function calculates your monthly mort age payment?
  17. 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?
  18. Which of the following methods cannot be used to enter data in a cell?
  19. Which of the following will not set text in selected cells to italics?
  20. Which of the following methods cannot be used to edit the content of cell?
This entry was posted in Ms Excel MCQs. Bookmark the permalink.

Leave a Reply

Your email address will not be published. Required fields are marked *