Home

Which of the following formulas will Excel Not be able to calculate?

A. =SUM(Sales)-A3

B. =SUM(A1:A5)*.5

C. =SUM(A1:A5)/(10-10)

D. =SUM(A1:A5)-10

You can do it
  1. You can auto fit the width of column by
  2. When integrating word and excel, word is usually the
  3. An excel workbook is a collection of
  4. Status indicators are located on the
  5. Long text can be broken down into many lines within a cell. You can do this through
  6. What is the short cut key to replace a data with another in sheet?
  7. To select an entire column in MS-EXCEL, press?
  8. Tab scroll buttons are place on Excel screen
  9. To remove the content of selected cells you must issue ______ command
  10. What is the correct way to refer the cell A10 on sheet3 from sheet1?
  11. Concatenation of text can be done using
  12. A numeric value can be treated as label value if ...... precedes it.
  13. Hyperlinks can be
  14. MS-EXCEL is based on .........?
  15. In a worksheet you can select
  16. Which of the following formulas is not entered correctly?
  17. Which Chart can be created in Excel?
  18. Each excel file is called a workbook because
  19. A __________ is a grid with labeled columns and rows.
  20. Which of the following is not a valid data type in excel
  21. Which of the following is a correct order of precedence in formula calculation?
  22. Which of the following option is not available in Paste Special dialog box?
  23. Which function is not available in the Consolidate dialog box?
  24. MS Excel provides the default value for step in Fill Series dialog box
  25. Data can be arranged in a worksheet in a easy to understand manner using
  26. Multiple calculations can be made in a single formula using
  27. Rounding errors can occur
  28. The auto calculate feature
  29. Which tool you will use to join some cells and place the content at the middle of joined cell?
  30. You can copy data or formulas