Home

The numbers in our worksheet look like this: You want them to look like this: $1,000.How can you accomplish this?

A. None of these

B. Select Format > Money from the menu

C. Click the Currency Style button on the formatting toolbar

D. You have to retype everything and manually add the dollar signs, commas, and decimals

Correct Answer : C.


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 remove borders applied in cells?ACC
  2. Text formulas:
  3. Which of the following is not a valid data type in Excel?
  4. Which setting you must modify to print a worksheet using letterhead?
  5. You can edit a cell by
  6. You can use drag-and-drop to embed excel worksheet data in a word document
  7. How do you display current date and time in MS Excel?
  8. How can you show or hide the gridlines in Excel Worksheet?
  9. A typical worksheet has …. Number of columns
  10. To copy cell contents using drag and drop press the
  11. Comments can be added to cells using
  12. Status indicators are located on the
  13. A numeric value can be treated as a label value if it precedes with
  14. In the formula, which symbol specifies the fixed columns or rows?
  15. You can merge the main document with data source in Excel. In mail merge operation, Word is usually
  16. In help menu of Excel, which of the following tabs are found?
  17. What is the short cut key to highlight the entire column?
  18. An excel workbook is a collection of
  19. Rounding errors can occur
  20. Which command will you choose to convert a column of data into row?
  21. Files created with Lotus 1-2-3 have an extension
  22. Excel displays the current cell address in the ........
  23. Excel probably considers the cell entry January 1, 2000 to be a
  24. Hyperlinks can be
  25. B7:B9 indicates:
  26. Which would you choose to create a bar diagram?
  27. The first cell in EXCEL worksheet is labeled as
  28. In EXCEL, you can sum a large range of data by simply selecting a tool button called .....?
  29. Long text can be broken down into many lines within a cell. You can do this through
  30. Excel files have a default extension of