Home

Which is used to perform what if analysis?

A. Solver

B. Goal seek

C. Scenario Manager

D. All of above

You can do it
  1. Getting data from a cell located in a different sheet is called ......
  2. Which of the following is not a term of MS-Excel?
  3. Text formulas:
  4. How do you rearrange the data in ascending or descending order?
  5. The Name box on to the left of formula bar
  6. To remove the content of selected cells you must issue ______ command
  7. Which of the following is the oldest spreadsheet package?
  8. Which menu option can be used to split windows into two?
  9. Which of the following is not a way to complete a cell entry?
  10. Which command will you choose to convert a column of data into row?
  11. A __________ is a grid with labeled columns and rows.
  12. Which key do you press to check spelling?
  13. You can use drag-and-drop to embed excel worksheet data in a word document
  14. How can you delete a record?
  15. Which elements of worksheet can be protected from accidental modification
  16. When a row of data is to be converted into columns
  17. A numeric value can be treated as a label value if it precedes with
  18. Rounding errors can occur
  19. The name box
  20. What will be the output if you format the cell containing 5436.8 as #,##0.00'?
  21. You want to set such that when you type Baishakh and drag the fill handle, Excel should produce Jestha,…
  22. Comments put in cells are called
  23. To delete an embedded objects, first
  24. Which of the following is not information you can specify using the solver?
  25. How do you delete a column?
  26. How can you update the values of formula cells if Auto Calculate mode of Excel is disabled?
  27. Where can you change automatic or manual calculation mode in Excel?
  28. An Excel Workbook is a collection of .......
  29. Which of the following formulas will Excel Not be able to calculate?
  30. To center worksheet titles across a range of cells, you must