Home

Multiple calculations can be made in a single formula using .......

A. Standard Formulas

B. Array Formula

C. Complex Formulas

D. Smart Formula

You can do it
  1. Which of the cell pointer indicates you that you can make selection?
  2. The short cut key Ctrl + R is used in Excel to
  3. Which area in an Excel window allows entering values and formulas?
  4. Which is not the function of Edit, Clear command?
  5. How do you display current date only in MS Excel?
  6. The spelling dialog box can be involved by choosing spelling from ________ menu.
  7. To hold row and column titles in place so that they do not scroll when you scroll a worksheet click…
  8. Paste Special allows some operation while you paste to new cell. Which of the following operation is…
  9. How do you delete a column?
  10. Which of the following is a correct order of precedence in formula calculation?
  11. Each excel file is called a workbook because
  12. What will be the output if you format the cell containing 5436.8 as #,##0.00'?
  13. Which of the following is not a worksheet design criterion?
  14. Which language is used to create macros in Excel?
  15. To view a cell comment
  16. When you copy a formula
  17. When you want to insert a blank imbedded excel object in a word document you can
  18. Multiple calculations can be made in a single formula using
  19. Which of the following options is not located in the Page Setup dialog box?
  20. Microsoft Excel is a powerful ...........
  21. What is the short cut key to highlight the entire column?
  22. If you begin typing an entry into a cell and then realize that you dont want your entry placed into…
  23. Getting data from a cell located in a different sheet is called ......
  24. When a label is too long to fit within a worksheet cell, you typically must
  25. Which of the following is a popular DOS based spreadsheet package?
  26. To create a formula, you can use:
  27. You can use the format painter multiple times before you turn it off by
  28. What is the correct way to refer the cell A10 on sheet3 from sheet1?
  29. How can you delete a record?
  30. Which would you choose to create a bar diagram?