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

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

You can do it
  1. When a range is selected, how can you activate the previous cell?
  2. While Finding and Replacing some data in Excel, which of the following statement is valid?
  3. Excel worksheet cells work very similarly to what common element of the windows graphical user interface
  4. Getting data from a cell located in a different sheet is called ......
  5. Which function is not available in the Consolidate dialog box?
  6. To activate the previous cell in a pre-selected range, press
  7. In Excel, a Data Series is defined as what?
  8. You can copy data or formulas
  9. Multiple calculations can be made in a single formula using .......
  10. If you begin typing an entry into a cell and then realize that you dont want your entry placed into…
  11. In the formula, which symbol specifies the fixed columns or rows?
  12. Which menu option can be used to split windows into two?
  13. What does COUNTA () function do?
  14. What is represented by the small, black square in the lower-right corner of an active cell or range?
  15. How can you update the values of formula cells if Auto Calculate mode of Excel is disabled?
  16. To view a cell comment
  17. When integrating word and excel, word is usually the
  18. Which of the following is not the correct method of editing the cell content?
  19. The short cut key Ctrl + R is used in Excel to
  20. How can you remove borders applied in cells?ACC
  21. A typical worksheet has …. Number of columns
  22. Which of the cell pointer indicates you that you can make selection?
  23. Rounding errors can occur
  24. Which Chart can be created in Excel?
  25. Which would you choose to create a bar diagram?
  26. When you link data maintained in an excel workbook to a word document
  27. Concatenation of text can be done using
  28. The auto calculate feature
  29. Which of the following options is not located in the Page Setup dialog box?
  30. MS-EXCEL is based on .........?