To create a formula, you can use:

A. Values but not cell references

B. Cell references but not values

C. Values or cell references although not both at the same time

D. Value and cell references

You can do it
  1. You can use the formula palette to
  2. A typical worksheet has . Number of columns
  3. Excel displays the current cell address in the ........
  4. Which elements of worksheet can be protected from accidental modification
  5. Which of the following formulas will Excel Not be able to calculate?
  6. The Cancel and Enter buttons appear in the:
  7. You can use drag-and-drop to embed excel worksheet data in a word document
  8. Which of the following formulas is not entered correctly?
  9. Comments can be added to cells using
  10. If you begin typing an entry into a cell and then realize that you dont want your entry placed into…
  11. Which of the cell pointer indicates you that you can make selection?
  12. Which of the following option is not available in Paste Special dialog box?
  13. A numeric value can be treated as label value if ...... precedes it.
  14. Getting data from a cell located in a different sheet is called ......
  15. Tab scroll buttons are place on Excel screen
  16. It is acceptable to let long text flow into adjacent cells on a worksheet when
  17. How can you delete a record?
  18. Files created with Lotus 1-2-3 have an extension
  19. Which of the following is a correct order of precedence in formula calculation?
  20. What do you call the chart that shows the proportions of how one or more data elements relate to another…
  21. How can you find specific information in a list?
  22. When a label is too long to fit within a worksheet cell, you typically must
  23. How can you print three copies of a workbook?
  24. In EXCEL, you can sum a large range of data by simply selecting a tool button called .....?
  25. To edit in an embedded excel worksheet object in a word document
  26. Without using the mouse or the arrow keys, what is the fastest way of getting to cell A1 in a spreadsheet?
  27. When you copy a formula
  28. When all the numbers between 0 and 100 in a range should be displayed in Red Color, apply
  29. Which of the following is not a basic step in creating a worksheet?
  30. If you need to remove only the formatting done in a range (numbers and formula typed there should not…