Which of the following is an absolute cell reference?

A. !A!1

B. $A$1

C. #a#1

D. A1

You can do it
  1. How do you delete a column?
  2. Which of the following is not a valid data type in Excel?
  3. When you insert an excel file into a word document. The data are
  4. When all the numbers between 0 and 100 in a range should be displayed in Red Color, apply
  5. The spelling dialog box can be involved by choosing spelling from ________ menu.
  6. Status indicators are located on the
  7. Paste Special allows some operation while you paste to new cell. Which of the following operation is…
  8. You can set Page Border in Excel from
  9. In a worksheet you can select
  10. Where can you change automatic or manual calculation mode in Excel?
  11. To center worksheet titles across a range of cells, you must
  12. Which is not the function of Edit, Clear command?
  13. Where can you set the shading color for a range of cells in Excel?
  14. Each excel file is called a workbook because
  15. Which of the following is an absolute cell reference?
  16. Files created with Lotus 1-2-3 have an extension
  17. Which command will you choose to convert a column of data into row?
  18. Which key do you press to check spelling?
  19. Which of the following formulas will Excel Not be able to calculate?
  20. Which button do you click to add up a series of numbers?
  21. Ctrl + D shortcut key in Excel will
  22. By default Excel provides 3 worksheets. You need only two of them, how will you delete the third one?
  23. To save a workbook, you:
  24. In the formula, which symbol specifies the fixed columns or rows?
  25. You can enter which types of data into worksheet cells?
  26. When a row of data is to be converted into columns
  27. You cannot link excel worksheet data to a word document
  28. MS-EXCEL is based on .........?
  29. Concatenation of text can be done using
  30. Multiple calculations can be made in a single formula using .......