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

Please do not use chat terms. Example: avoid using "grt" instead of "great".

You can do it
  1. Which is used to perform what if analysis?
  2. Which of the following is not information you can specify using the solver?
  3. To copy cell contents using drag and drop press the
  4. What are the tabs that appear at the bottom of each workbook called?
  5. A __________ is a grid with labeled columns and rows.
  6. A circular reference is
  7. Which of the following is the oldest spreadsheet package?
  8. Which would you choose to create a bar diagram?
  9. You can select a single range of cells by
  10. Which of the following methods can not be used to edit the contents of a cell?
  11. Which function is used to calculate depreciation, rates of return, future values and loan payment amounts?
  12. The Chart wizard term data categories refers to;
  13. Concatenation of text can be done using
  14. How do you select an entire column?
  15. How can you show or hide the gridlines in Excel Worksheet?
  16. How do you rearrange the data in ascending or descending order?
  17. In Excel, a Data Series is defined as what?
  18. To save a workbook, you:
  19. Which of the following is not a worksheet design criterion?
  20. Which of the following is an absolute cell reference?
  21. You can copy data or formulas
  22. Which of the following is not the correct method of editing the cell content?
  23. Which of the following is invalid statement?
  24. To edit in an embedded excel worksheet object in a word document
  25. When a label is too long to fit within a worksheet cell, you typically must
  26. Which button do you click to add up a series of numbers?
  27. Which of the following is not true regarding Conditional Formatting?
  28. Which of following is Not one of Excels what-if function?
  29. Without using the mouse or the arrow keys, what is the fastest way of getting to cell A1 in a spreadsheet?
  30. The auto calculate feature