Text formulas:

A. Replace cell references

B. Return ASCII values of characters

C. Concatenate and manipulate text

D. Show formula error value

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

You can do it
  1. An Excel Workbook is a collection of .......
  2. What is represented by the small, black square in the lower-right corner of an active cell or range?
  3. Which of the following is not true about Find and Replace in Excel
  4. Which of the following methods cannot be used to enter data in a cell
  5. Microsoft Excel is a powerful ...........
  6. Which of the following formulas is not entered correctly?
  7. To select an entire column in MS-EXCEL, press?
  8. You can copy data or formulas
  9. The numbers in our worksheet look like this: You want them to look like this: $1,000.How can you accomplish…
  10. Concatenation of text can be done using
  11. Which of the following series type is not valid for Fill Series dialog box?
  12. You can use the formula pallette to
  13. When you want to insert a blank imbedded excel object in a word document you can
  14. It is acceptable to let long text flow into adjacent cells on a worksheet when
  15. To copy formatting from one area in a worksheet and apply it to another area you would use:
  16. Which elements of a worksheet can be protected from accidental modification?
  17. Which function is used to calculate depreciation, rates of return, future values and loan payment amounts?
  18. You can merge the main document with data source in Excel. In mail merge operation, Word is usually
  19. Which menu option can be sued to split windows into two
  20. Excel uniquely identifies cells within a worksheet with a cell name
  21. Which of the following Excel screen components can NOT be turned on or off?
  22. Excel worksheet cells work very similarly to what common element of the windows graphical user interface
  23. Without using the mouse or the arrow keys, what is the fastest way of getting to cell A1 in a spreadsheet?
  24. Which of the following is not the correct method of editing the cell content?
  25. Right clicking something in Excel:
  26. A circular reference is
  27. Documentation should include
  28. Which of the following is not a way to complete a cell entry?
  29. The command Edit >> Fill Across Worksheet is active only when
  30. Which is used to perform what if analysis?