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 yup
  1. Excel uniquely identifies cells within a worksheet with a cell name
  2. Which of the following option is not available in Paste Special dialog box?
  3. Which of the following is the latest version of Excel
  4. Which of the following is not a worksheet design criterion?
  5. How can you delete a record?
  6. Concatenation of text can be done using
  7. Multiple calculations can be made in a single formula using .......
  8. The short cut key Ctrl + R is used in Excel to
  9. Which of the following series type is not valid for Fill Series dialog box?
  10. Which elements of worksheet can be protected from accidental modification
  11. Which is used to perform what if analysis?
  12. How can you print three copies of a workbook?
  13. Which function is used to calculate depreciation, rates of return, future values and loan payment amounts?
  14. What is the short cut key to replace a data with another in sheet?
  15. Comments put in cells are called .....
  16. How can you show or hide the gridlines in Excel Worksheet?
  17. When a label is too long to fit within a worksheet cell, you typically must
  18. Ctrl + D shortcut key in Excel will
  19. You can move a sheet from one workbook into new book by
  20. To hold row and column titles in place so that they do not scroll when you scroll a worksheet click…
  21. Which of the following action removes a sheet from workbook?
  22. To activate the previous cell in a pre-selected range, press
  23. Which of the following is invalid statement?
  24. Which of the following is not a valid data type in Excel?
  25. If you begin typing an entry into a cell and then realize that you dont want your entry placed into…
  26. To edit in an embedded excel worksheet object in a word document
  27. You can select a single range of cells by
  28. How do you delete a column?
  29. What does COUNTA () function do?
  30. The autofill feature