Home

When you copy a formula

A. Excel erases the original copy of the formula

B. Excel edits cell references in the newly copied formula

C. Excel adjusts absolute cell references

D. Excel doesnt adjust relative cell references

You can do it
  1. Which command will you choose to convert a column of data into row?
  2. Which language is used to create macros in Excel?
  3. To activate the previous cell in a pre-selected range, press
  4. The name box
  5. Which of the following is not the correct method of editing the cell content?
  6. The chart wizard term data series refers to
  7. Which would you choose to create a bar diagram?
  8. A worksheet range is a
  9. Which of the following is not a basic step in creating a worksheet?
  10. What is the short cut key to replace a data with another in sheet?
  11. Which of the following is not true regarding Conditional Formatting?
  12. B7:B9 indicates:
  13. Which of the following option is not available in Paste Special dialog box?
  14. Excel worksheet cells work very similarly to what common element of the windows graphical user interface
  15. A numeric value can be treated as label value if ...... precedes it.
  16. How can you delete a record?
  17. Which of the following is invalid statement?
  18. Multiple calculations can be made in a single formula using .......
  19. In EXCEL, you can sum a large range of data by simply selecting a tool button called .....?
  20. Which of the following Excel screen components can NOT be turned on or off?
  21. Each excel file is called a workbook because
  22. What do you call the chart that shows the proportions of how one or more data elements relate to another…
  23. What are the tabs that appear at the bottom of each workbook called?
  24. Which elements of a worksheet can be protected from accidental modification?
  25. Which of the following format you can decide to apply or not in AutoFormat dialog box?
  26. When you copy a formula
  27. Which function is used to calculate depreciation, rates of return, future values and loan payment amounts?
  28. To create a formula, you can use:
  29. Comments can be added to cells using
  30. Which of the following is a popular DOS based spreadsheet package?