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

  1. Home

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

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

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

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

4.The Format Painter button on the standard toolbar

Posted Date:-2021-02-11 17:14:26

More MCQS Questions and answers

  1. A circular reference is
  2. How do you select an entire column?
  3. To create a formula, you first:
  4. To edit in an embedded excel worksheet object in a word document
  5. Which of the following is not information you can specify using the solver?
  6. You can use the format painter multiple times before you turn it off by
  7. All worksheet formula
  8. An excel workbook is a collection of
  9. Comments put in cells are called
  10. Each excel file is called a workbook because
  11. Excel files have a default extension of
  12. Excel probably considers the cell entry January 1, 2000 to be a
  13. How can you find specific information in a list?
  14. How can you print three copies of a workbook?
  15. How do you delete a column?
  16. How do you insert a row?
  17. Hyperlinks can be
  18. In a worksheet you can select
  19. Which of the following methods cannot be used to enter data in a cell
  20. Multiple calculations can be made in a single formula using
  21. Rounding errors can occur
  22. Status indicators are located on the
  23. Text formulas:
  24. The name box
  25. To activate the previous cell in a pre-selected range, press
  26. To center worksheet titles across a range of cells, you must
  27. To copy formatting from one area in a worksheet and apply it to another area you would use:
  28. To create a formula, you can use
  29. To hold row and column titles in place so that they do not scroll when you scroll a worksheet click the
  30. When a label is too long to fit within a worksheet cell, you typically must
  31. When integrating word and excel, word is usually the
  32. When the formula bar is active, you can see
  33. When you insert an excel file into a word document. The data are
  34. When you link data maintained in an excel workbook to a word document
  35. Which area in an excel window allows entering values and formulas
  36. Which button do you click to add up a series of numbers?
  37. Which is used to perform what if analysis?
  38. Which of following is Not one of Excel’s what-if function?
  39. Which of the following is a popular DOS based spreadsheet package?
  40. Which of the following is not a basic step in creating a worksheet?
  41. Which of the following is not a way to complete a cell entry?
  42. Which of the following is the oldest spreadsheet package?
  43. Which of the following will not cut information?
  44. You can activate a cell by
  45. You can convert existing excel worksheet data an charts to an HTML document by using
  46. You can copy data or formulas
  47. You can enter which types of data into worksheet cells?
  48. You can use the formula palette to
  49. You can use the horizontal and vertical scroll bars to
  50. You cannot link excel worksheet data to a word document
Search
Olete Team
Online Exam Test Top Tutorials are Core Java,Hibernate ,Spring,Sturts.The content on Online Exam Test website is done by expert team not only with the help of books but along with the strong professional knowledge in all context like coding,designing, marketing,etc!