MS EXCEL MCQ Questions and Answers Quiz

11. Which of the following options is appropriate to show the numbers 9779851089510 in a cell?

  1. Enclose the number is brackets
  2. Place the character T before the number
  3. Place the character TX before the number
  4. Apply the Text format in the cell and type the numbers

12. Which of the following shortcuts can be used to insert a new line in the same cell?

  1. Enter
  2. Alt + Enter
  3. Ctrl + Enter
  4. Shift + Enter

13. An Excel file is generally called a / an :

  1. E-Spreadsheet
  2. Woorksheet
  3. Workbook
  4. Sheet

14. Which of the following is the oldest spreadsheet package ?

  1. Excel
  2. StarCalc
  3. VisiCalc
  4. None of the above

15. Which key do you press to check spelling?

  1. F3
  2. F5
  3. F7
  4. F9

16. What is the keyboard shortcut for creating a chart from the selected cell range ?

  1. F9
  2. F10
  3. F11
  4. F12

17. Which function is used to calculate depreciation, rates of return, future values and loan payment amounts ?

  1. Financial
  2. Statistical
  3. Logical
  4. None of the above

18. MS-EXCEL can be used to automate

  1. Financial statements, Business forecasting
  2. Transaction registers, inventory control
  3. Accounts receivable, accounts payable
  4. Any of the above

19. Which of the following format you can decide to apply or not in AutoFormat dialog box ?

  1. Font format
  2. Number format
  3. Border format
  4. All of the above

20. Which menu option can be used to split windows into two?

  1. Format -> Window
  2. View -> Window-> Split
  3. Window -> Split
  4. View –> Split
Tags

MCQ Multiple Choice Questions and Answers on MS EXCEL

MS EXCEL Trivia Questions and Answers PDF

MS EXCEL Question and Answer

Spreading Knowledge Across the World

USA - United States of America  Canada  United Kingdom  Australia  New Zealand  South America  Brazil  Portugal  Netherland  South Africa  Ethiopia  Zambia  Singapore  Malaysia  India  China  UAE - Saudi Arabia  Qatar  Oman  Kuwait  Bahrain  Dubai  Israil  England  Scotland  Norway  Ireland  Denmark  France  Spain  Poland  and many more....