Home

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. To hold row and column titles in place so that they do not scroll when you scroll a worksheet click…
  2. You can use the horizontal and vertical scroll bars to
  3. Files created with Lotus 1-2-3 have an extension
  4. Comments can be added to cells using
  5. What do you call the chart that shows the proportions of how one or more data elements relate to another…
  6. The name box
  7. In Excel, the Fill Color button on the Formatting toolbar is used for what?
  8. Which of the following is not a way to complete a cell entry?
  9. Comments can be added to cells using ......
  10. Tab scroll buttons are place on Excel screen
  11. You can set Page Border in Excel from
  12. Microsoft Excel is a powerful ...........
  13. The active cell:
  14. Which of the following is an absolute cell reference?
  15. Excel files have a default extension of
  16. Which setting you must modify to print a worksheet using letterhead?
  17. To create a formula, you can use:
  18. You want to set such that when you type Baishakh and drag the fill handle, Excel should produce Jestha,…
  19. Getting data from a cell located in a different sheet is called ......
  20. You can auto fit the width of column by
  21. In EXCEL, you can sum a large range of data by simply selecting a tool button called .....?
  22. When you want to insert a blank imbedded excel object in a word document you can
  23. Rounding errors can occur
  24. In help menu of Excel, which of the following tabs are found?
  25. How do you rearrange the data in ascending or descending order?
  26. Which of the following methods cannot be used to enter data in a cell
  27. To select an entire column in MS-EXCEL, press?
  28. How can you find specific information in a list?
  29. Which area in an Excel window allows entering values and formulas?
  30. To copy cell contents using drag and drop press the