Home

Text formulas:

A. Replace cell references

B. Return ASCII values of characters

C. Concatenate and manipulate text

D. Show formula error value

Correct Answer : C.


Download Objective type questions of Microsoft Excel PDF

Visit our PDF store

Get all objective type questions of Microsoft Excel MCQ

Also checkout these categories

Time and Work MCQ Basics of Neurology MCQ Surface Area MCQ Rearrangement Set 10 MCQ Pipes and Cistern MCQ Atomic Structure MCQ Wound Repair And Care MCQ Payroll MCQ Industrial Engineering & Production Management Test MCQ Coding MCQ Choosing the correct sentence MCQ Botany MCQ

Please do not use chat terms. Example: avoid using "grt" instead of "great".

Submit
Load More..
You can do it
  1. What does COUNTA () function do?
  2. The Cancel and Enter buttons appear in the:
  3. Which Chart can be created in Excel?
  4. Which button do you click to add up a series of numbers?
  5. The numbers in our worksheet look like this: You want them to look like this: $1,000.How can you accomplish…
  6. A worksheet range is a
  7. You can move a sheet from one workbook into new book by
  8. To save a workbook, you:
  9. Tab scrolling button
  10. What do you call the chart that shows the proportions of how one or more data elements relate to another…
  11. To create a formula, you first:
  12. If you need to remove only the formatting done in a range (numbers and formula typed there should not…
  13. In EXCEL, you can sum a large range of data by simply selecting a tool button called .....?
  14. The auto calculate feature
  15. Which of the following is not a term of MS-Excel?
  16. The chart wizard term data series refers to
  17. When a range is selected, how can you activate the previous cell?
  18. To edit in an embedded excel worksheet object in a word document
  19. Comments put in cells are called .....
  20. Excel worksheet cells work very similarly to what common element of the windows graphical user interface
  21. Which elements of a worksheet can be protected from accidental modification?
  22. You can auto fit the width of column by
  23. Status indicators are located on the
  24. Which of the following is not true about Find and Replace in Excel
  25. How can you update the values of formula cells if Auto Calculate mode of Excel is disabled?
  26. Which menu option can be used to split windows into two?
  27. You can activate a cell by
  28. To center worksheet titles across a range of cells, you must
  29. Which area in an Excel window allows entering values and formulas?
  30. A numeric value can be treated as label value if ...... precedes it.