Home

Which area in an excel window allows entering values and formulas

A. Title bar

B. Menu bar

C. Formula bar

D. Standard toolbar

You can do it
  1. Which of the following you can paste selectively using Paste Special command?
  2. What does COUNTA () function do?
  3. It is acceptable to let long text flow into adjacent cells on a worksheet when
  4. What is the correct way to refer the cell A10 on sheet3 from sheet1?
  5. You cannot link excel worksheet data to a word document
  6. Which is used to perform what if analysis?
  7. Getting data from a cell located in a different sheet is called ......
  8. Microsoft Excel is a powerful ...........
  9. If you need to remove only the formatting done in a range (numbers and formula typed there should not…
  10. Which of the following formulas will Excel Not be able to calculate?
  11. You can use the formula pallette to
  12. You can select a single range of cells by
  13. Which button do you click to add up a series of numbers?
  14. When the formula bar is active, you can see
  15. A worksheet range is a
  16. Which of the following is not a term of MS-Excel?
  17. MS Excel provides the default value for step in Fill Series dialog box
  18. Text formulas:
  19. Which of the following is not a valid data type in excel
  20. MS-EXCEL is based on .........?
  21. Concatenation of text can be done using
  22. When integrating word and excel, word is usually the
  23. You can check the conditions against __________ when applying conditional formatting
  24. Which of the following series type is not valid for Fill Series dialog box?
  25. When all the numbers between 0 and 100 in a range should be displayed in Red Color, apply
  26. The Paste Special command lets you copy and paste:
  27. Ctrl + D shortcut key in Excel will
  28. To copy formatting from one area in a worksheet and apply it to another area you would use:
  29. To record a sequence of keystrokes and mouse actions to play back later we use:
  30. Which of the following methods cannot be used to enter data in a cell