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. Excel probably considers the cell entry January 1, 2000 to be a
  2. Which of the following is the oldest spreadsheet package?
  3. Which area in an excel window allows entering values and formulas
  4. Comments put in cells are called
  5. Which of following is Not one of Excels what-if function?
  6. Paste Special allows some operation while you paste to new cell. Which of the following operation is…
  7. The command Edit >> Fill Across Worksheet is active only when
  8. You cannot link excel worksheet data to a word document
  9. What is the short cut key to highlight the entire column?
  10. It is acceptable to let long text flow into adjacent cells on a worksheet when
  11. You can edit a cell by
  12. Which of the following is not information you can specify using the solver?
  13. Which of the cell pointer indicate that you can move the content to other cell?
  14. Documentation should include
  15. To center worksheet titles across a range of cells, you must
  16. Which of the following is not a valid data type in excel
  17. Files created with Lotus 1-2-3 have an extension
  18. The active cell:
  19. To record a sequence of keystrokes and mouse actions to play back later we use:
  20. To copy cell contents using drag and drop press the
  21. Which would you choose to create a bar diagram?
  22. Right clicking something in Excel:
  23. By default Excel provides 3 worksheets. You need only two of them, how will you delete the third one?
  24. What will be the output if you format the cell containing 5436.8 as #,##0.00'?
  25. You can activate a cell by
  26. Which of the following is not a term of MS-Excel?
  27. How can you remove borders applied in cells?ACC
  28. When a range is selected, how can you activate the previous cell?
  29. Getting data from a cell located in a different sheet is called ......
  30. How can you delete a record?