MS EXCEL Quiz Question with Answer


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 :


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....