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

Related Questions

  1. What happens when dollar signs ($) are entered in a cell address? (e$B$2:$B$10)
  2. What does COUNTA () function do?
  3. Which of the following is an absolute cell reference?
  4. A circular reference is
  5. If you begin typing an entry into a cell and then realize that you dont want your entry placed into…
  6. The first cell in EXCEL worksheet is labeled as
  7. Rounding errors can occur
  8. An Excel Workbook is a collection of .......
  9. Which setting you must modify to print a worksheet using letterhead?
  10. The chart wizard term data series refers to
  11. To copy cell contents using drag and drop press the
  12. When the formula bar is active, you can see
  13. You want to set such that when you type Baishakh and drag the fill handle, Excel should produce Jestha,…
  14. Edit >> Delete command
  15. Which of the cell pointer indicates that you can fill series?
  16. Excel files have a default extension of
  17. A worksheet can have a maximum of …. Number of rows
  18. Which of following is Not one of Excels what-if function?
  19. Which of the following option is not available in Paste Special dialog box?
  20. Multiple calculations can be made in a single formula using
  21. You want to track the progress of the stock market on a daily basis. Which type of chart should you…
  22. What symbol is used before a number to make it a label?
  23. It is acceptable to let long text flow into adjacent cells on a worksheet when
  24. Without using the mouse or the arrow keys, what is the fastest way of getting to cell A1 in a spreadsheet?
  25. Which of the following options is not located in the Page Setup dialog box?
  26. When a label is too long to fit within a worksheet cell, you typically must
  27. To return the remainder after a number is divided by a divisor in EXCEL we use the function?
  28. Concatenation of text can be done using
  29. Getting data from a cell located in a different sheet is called ......
  30. A worksheet range is a

Please do not use chat terms. Example: avoid using "grt" instead of "great".