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. An excel workbook is a collection of
  2. How can you find specific information in a list?
  3. When you want to insert a blank imbedded excel object in a word document you can
  4. The short cut key Ctrl + R is used in Excel to
  5. To select an entire column in MS-EXCEL, press?
  6. Which Chart can be created in Excel?
  7. Which of the following is a popular DOS based spreadsheet package?
  8. Concatenation of text can be done using
  9. How do you select an entire column?
  10. You cannot link excel worksheet data to a word document
  11. How can you delete a record?
  12. A numeric value can be treated as a label value if it precedes with
  13. You can check the conditions against __________ when applying conditional formatting
  14. The Name box on to the left of formula bar
  15. How can you remove borders applied in cells?ACC
  16. Which of the following option is not available in Paste Special dialog box?
  17. The chart wizard term data series refers to
  18. Which of the following is a correct order of precedence in formula calculation?
  19. Which tool you will use to join some cells and place the content at the middle of joined cell?
  20. How do you display current date only in MS Excel?
  21. B7:B9 indicates:
  22. What happens when dollar signs ($) are entered in a cell address? (e$B$2:$B$10)
  23. How many worksheets can a workbook have?
  24. In EXCEL, you can sum a large range of data by simply selecting a tool button called .....?
  25. Which is not the function of Edit, Clear command?
  26. What are the tabs that appear at the bottom of each workbook called?
  27. You can select a single range of cells by
  28. You can auto fit the width of column by
  29. The Delete key of keyboard is assigned to which command in Excel?
  30. Which of following is Not one of Excels what-if function?