What happens when dollar signs ($) are entered in a cell address? (e$B$2:$B$10)

A. An absolute cell address is created

B. Cell address will change when it is copied to another cell

C. The sheet tab is changed

D. The status bar does not display the cell address

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

You can do it
  1. In Excel, the Fill Color button on the Formatting toolbar is used for what?
  2. Where can you set the shading color for a range of cells in Excel?
  3. Excel files have a default extension of
  4. What is the correct way to refer the cell A10 on sheet3 from sheet1?
  5. Which elements of worksheet can be protected from accidental modification
  6. How many worksheets can a workbook have?
  7. You cannot link excel worksheet data to a word document
  8. Long text can be broken down into many lines within a cell. You can do this through
  9. What is the short cut key to replace a data with another in sheet?
  10. How can you update the values of formula cells if Auto Calculate mode of Excel is disabled?
  11. To copy formatting from one area in a worksheet and apply it to another area you would use:
  12. You can copy data or formulas
  13. Excel worksheet cells work very similarly to what common element of the windows graphical user interface
  14. Which of the cell pointer indicate that you can move the content to other cell?
  15. To edit in an embedded excel worksheet object in a word document
  16. Which tool you will use to join some cells and place the content at the middle of joined cell?
  17. How do you delete a column?
  18. You can use the drag and drop method to
  19. You can use drag-and-drop to embed excel worksheet data in a word document
  20. In Excel, a Data Series is defined as what?
  21. To copy cell contents using drag and drop press the
  22. MS-EXCEL is based on .........?
  23. Rounding errors can occur
  24. Which of the following is not true regarding Conditional Formatting?
  25. It is acceptable to let long text flow into adjacent cells on a worksheet when
  26. To select an entire column in MS-EXCEL, press?
  27. Which menu option can be sued to split windows into two
  28. Right clicking something in Excel:
  29. A numeric value can be treated as label value if ...... precedes it.
  30. Which of the following is invalid statement?