Home

What will be the output if you format the cell containing 5436.8 as #,##0.00'?

A. 5430

B. 5436.80

C. 5436.8

D. 6.8

Correct Answer : B.


Download Objective type questions of Microsoft Excel PDF

Visit our PDF store

Get all objective type questions of Microsoft Excel MCQ

You can do it
  1. How can you print three copies of a workbook?
  2. Which of the following formulas will Excel Not be able to calculate?
  3. In Excel, a Data Series is defined as what?
  4. Which of the following is a popular DOS based spreadsheet package?
  5. In help menu of Excel, which of the following tabs are found?
  6. Rounding errors can occur
  7. Which of the following options is not located in the Page Setup dialog box?
  8. When all the numbers between 0 and 100 in a range should be displayed in Red Color, apply
  9. Edit >> Delete command
  10. The first cell in EXCEL worksheet is labeled as
  11. How do you display current date only in MS Excel?
  12. Which of the following format you can decide to apply or not in AutoFormat dialog box?
  13. You can use the horizontal and vertical scroll bars to
  14. Excel uniquely identifies cells within a worksheet with a cell name
  15. You can check the conditions against __________ when applying conditional formatting
  16. To copy formatting from one area in a worksheet and apply it to another area you would use:
  17. Which of the following is not a way to complete a cell entry?
  18. Which tool you will use to join some cells and place the content at the middle of joined cell?
  19. How do you delete a column?
  20. When you insert an excel file into a word document. The data are
  21. Which key do you press to check spelling?
  22. Which of the cell pointer indicates that you can fill series?
  23. What does COUNTA () function do?
  24. It is acceptable to let long text flow into adjacent cells on a worksheet when
  25. Which elements of a worksheet can be protected from accidental modification?
  26. How do you rearrange the data in ascending or descending order?
  27. Excel files have a default extension of
  28. Which of the following is not the correct method of editing the cell content?
  29. Which of the following is not a valid data type in Excel?
  30. While Finding and Replacing some data in Excel, which of the following statement is valid?