Home

To return the remainder after a number is divided by a divisor in EXCEL we use the function?

A. ROUND ( )

B. FACT ( )

C. MOD ( )

D. DIV ( )

You can do it
  1. You want to set such that when you type Baishakh and drag the fill handle, Excel should produce Jestha,…
  2. To create a formula, you can use:
  3. Which of the following is not the correct method of editing the cell content?
  4. You can use the formula pallette to
  5. Which setting you must modify to print a worksheet using letterhead?
  6. You can use the format painter multiple times before you turn it off by
  7. A typical worksheet has . Number of columns
  8. You can check the conditions against __________ when applying conditional formatting
  9. In help menu of Excel, which of the following tabs are found?
  10. Right clicking something in Excel:
  11. How can you delete a record?
  12. Documentation should include
  13. To view a cell comment
  14. Microsoft Excel is a powerful ...........
  15. Which area in an excel window allows entering values and formulas
  16. Which of the following methods cannot be used to enter data in a cell
  17. Which function is not available in the Consolidate dialog box?
  18. Which of the following is not a valid data type in Excel?
  19. By default Excel provides 3 worksheets. You need only two of them, how will you delete the third one?
  20. Which of the following is the latest version of Excel
  21. MS-EXCEL is based on .........?
  22. A __________ is a grid with labeled columns and rows.
  23. Which of the following formulas will Excel Not be able to calculate?
  24. Ctrl + D shortcut key in Excel will
  25. To remove the content of selected cells you must issue ______ command
  26. Which of the following Excel screen components can NOT be turned on or off?
  27. Which of the following is not a way to complete a cell entry?
  28. How do you wrap the text in a cell?
  29. How can you update the values of formula cells if Auto Calculate mode of Excel is disabled?
  30. Which function is used to calculate depreciation, rates of return, future values and loan payment amounts?