To copy formatting from one area in a worksheet and apply it to another area you would use:

A. The Edit > Copy Format and Edit>Paste Format commands form the menu

B. The Copy and Apply Formatting dialog box, located under the Format > Copy and Apply menu

C. There is no way to copy and apply formatting in Excel You have to do it manually

D. The Format Painter button on the standard toolbar

You can do it
  1. Data can be arranged in a worksheet in a easy to understand manner using
  2. Microsoft Excel is a powerful ...........
  3. While Finding and Replacing some data in Excel, which of the following statement is valid?
  4. The Delete key of keyboard is assigned to which command in Excel?
  5. An Excel Workbook is a collection of .......
  6. You can convert existing excel worksheet data an charts to an HTML document by using
  7. Which of the following format you can decide to apply or not in AutoFormat dialog box?
  8. The name box
  9. When all the numbers between 0 and 100 in a range should be displayed in Red Color, apply
  10. Which language is used to create macros in Excel?
  11. It is acceptable to let long text flow into adjacent cells on a worksheet when
  12. When you want to insert a blank imbedded excel object in a word document you can
  13. Which of the following is invalid statement?
  14. Which of the following you can paste selectively using Paste Special command?
  15. To create a formula, you first:
  16. What does COUNTA () function do?
  17. In a worksheet you can select
  18. When you link data maintained in an excel workbook to a word document
  19. Which of the following action removes a sheet from workbook?
  20. Which of the following is the latest version of Excel
  21. What is the correct way to refer the cell A10 on sheet3 from sheet1?
  22. When a label is too long to fit within a worksheet cell, you typically must
  23. Which command will you choose to convert a column of data into row?
  24. Getting data from a cell located in a different sheet is called ......
  25. To delete an embedded objects, first
  26. When you copy a formula
  27. If you begin typing an entry into a cell and then realize that you dont want your entry placed into…
  28. How can you delete a record?
  29. To center worksheet titles across a range of cells, you must
  30. The short cut key Ctrl + R is used in Excel to