Home

To hold row and column titles in place so that they do not scroll when you scroll a worksheet click the

A. Unfreeze panes command on the window menu

B. Freeze panes command on the window menu

C. Hold titles command on the edit menu

D. Split command on the window menu

You can do it
  1. Multiple calculations can be made in a single formula using
  2. When a label is too long to fit within a worksheet cell, you typically must
  3. The spelling dialog box can be involved by choosing spelling from ________ menu.
  4. You can activate a cell by
  5. Which of the following series type is not valid for Fill Series dialog box?
  6. What is the short cut key to highlight the entire column?
  7. Which command will you choose to convert a column of data into row?
  8. You want to set such that when you type Baishakh and drag the fill handle, Excel should produce Jestha,…
  9. Right clicking something in Excel:
  10. When the formula bar is active, you can see
  11. You can auto fit the width of column by
  12. How do you select an entire column?
  13. You cannot link excel worksheet data to a word document
  14. How do you delete a column?
  15. To record a sequence of keystrokes and mouse actions to play back later we use:
  16. Which of the following options is not located in the Page Setup dialog box?
  17. What is the short cut key to replace a data with another in sheet?
  18. Which of the following formulas is not entered correctly?
  19. To delete an embedded objects, first
  20. What are the tabs that appear at the bottom of each workbook called?
  21. Which of the following is a correct order of precedence in formula calculation?
  22. Which elements of worksheet can be protected from accidental modification
  23. What happens when dollar signs ($) are entered in a cell address? (e$B$2:$B$10)
  24. To copy formatting from one area in a worksheet and apply it to another area you would use:
  25. Text formulas:
  26. Getting data from a cell located in a different sheet is called ......
  27. You can select a single range of cells by
  28. How can you update the values of formula cells if Auto Calculate mode of Excel is disabled?
  29. Which menu option can be used to split windows into two?
  30. You can copy data or formulas