In the formula, which symbol specifies the fixed columns or rows?

A. $

B. *

C. %

D. &

You can do it
  1. Which of the following is not true regarding Conditional Formatting?
  2. You can move a sheet from one workbook into new book by
  3. What are the tabs that appear at the bottom of each workbook called?
  4. Which area in an excel window allows entering values and formulas
  5. Which of the following format you can decide to apply or not in AutoFormat dialog box?
  6. Which of the following action removes a sheet from workbook?
  7. How many worksheets can a workbook have?
  8. To copy cell contents using drag and drop press the
  9. In EXCEL, you can sum a large range of data by simply selecting a tool button called .....?
  10. Which of the cell pointer indicates you that you can make selection?
  11. Which elements of worksheet can be protected from accidental modification
  12. To center worksheet titles across a range of cells, you must
  13. Which menu option can be sued to split windows into two
  14. Which of the following is a popular DOS based spreadsheet package?
  15. Which key do you press to check spelling?
  16. Which of the following is not a way to complete a cell entry?
  17. Which of the following is the oldest spreadsheet package?
  18. MS Excel provides the default value for step in Fill Series dialog box
  19. Rounding errors can occur
  20. Which of the following is not true about Find and Replace in Excel
  21. You can use the formula palette to
  22. Which of the following methods cannot be used to enter data in a cell
  23. How can you remove borders applied in cells?ACC
  24. You can activate a cell by
  25. Paste Special allows some operation while you paste to new cell. Which of the following operation is…
  26. Where can you change automatic or manual calculation mode in Excel?
  27. Which of the following is not a basic step in creating a worksheet?
  28. Concatenation of text can be done using
  29. How can you update the values of formula cells if Auto Calculate mode of Excel is disabled?
  30. Which of the following is invalid statement?