MS EXCEL multiple choice questions and answers on MS EXCEL MCQ questions quiz on MS EXCEL objective questions. Professionals, Teachers, Students and Kids Trivia Quizzes to test your knowledge on the subject.

MS EXCEL Quiz Question with Answer


1. What is the short cut key to highlight the entire column ?

  1. Ctrl + Space Bar
  2. Ctrl + Enter
  3. Ctrl + Right Arrow key
  4. None of the above

2. How do you rearrange the data in ascending or descending order ?

  1. Data, Sort
  2. Data, Form
  3. Data, Table
  4. None of the above

3. If 4/6 entered in a cell without applying any formats, Excel will treat this as

  1. Date
  2. Text
  3. Fraction
  4. None of the above

4. How do you display current date and time in MS Excel?

  1. date ()
  2. Today ()
  3. now ()
  4. time ()

5. How do you display current date only in MS Excel?

  1. date ()
  2. Today ()
  3. now ()
  4. time ()

6. Formatting a cell in Currency, you can specify

  1. Decimal Places
  2. Currency Symbol
  3. Percentage symbol
  4. None of the above

7. Which is not the function of “Edit, Clear” command?

  1. Delete contents
  2. Delete notes
  3. Delete cells
  4. Delete formats

8. Which of the following is not an underline option in the format cells dialog box?

  1. Double
  2. Single Accounting
  3. Double Accounting
  4. Single Engineering

9. Comments can be added to cells using

  1. Edit -> Comments
  2. Insert -> Comment
  3. File -> Comments
  4. View –> Comments

10. Which would you choose to create a bar diagram?

  1. Edit, Chart
  2. Insert, Chart
  3. Tools, Chart
  4. Format, Chart

Tags :


Multiple Choice Questions and Answers on MS EXCEL


MS EXCEL Multiple Choice Questions and Answers


MS EXCEL Trivia Quiz


MS EXCEL Question and Answer PDF Online





Spreading Knowledge Across the World

USA - United States of America  Canada  United Kingdom  Australia  New Zealand  South America  Brazil  Portugal  England  Scotland  Norway  Ireland  Denmark  France  Spain  Poland  Netherland  Germany  Sweden  South Africa  Ghana  Tanzania  Nigeria  Kenya  Ethiopia  Zambia  Singapore  Malaysia  India  Pakistan  Nepal  Taiwan  Philippines  Libya  Cambodia  Hong Kong  China  UAE - Saudi Arabia  Qatar  Oman  Kuwait  Bahrain  Dubai  Israil  and many more....