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 ( )

Correct Answer : C.


Download Objective type questions of Microsoft Excel PDF

Visit our PDF store

Get all objective type questions of Microsoft Excel MCQ

You can do it
  1. Without using the mouse or the arrow keys, what is the fastest way of getting to cell A1 in a spreadsheet?
  2. How can you show or hide the gridlines in Excel Worksheet?
  3. In Excel, a Data Series is defined as what?
  4. When a range is selected, how can you activate the previous cell?
  5. You can select a single range of cells by
  6. You cannot link excel worksheet data to a word document
  7. The numbers in our worksheet look like this: You want them to look like this: $1,000.How can you accomplish…
  8. You can check the conditions against __________ when applying conditional formatting
  9. What symbol is used before a number to make it a label?
  10. Comments can be added to cells using ......
  11. You can use the horizontal and vertical scroll bars to
  12. How do you wrap the text in a cell?
  13. Which of the following is not a basic step in creating a worksheet?
  14. How do you rearrange the data in ascending or descending order?
  15. Which button do you click to add up a series of numbers?
  16. How do you display current date and time in MS Excel?
  17. When all the numbers between 0 and 100 in a range should be displayed in Red Color, apply
  18. The short cut key Ctrl + R is used in Excel to
  19. Data can be arranged in a worksheet in a easy to understand manner using
  20. Which of the following formulas is not entered correctly?
  21. Comments put in cells are called
  22. How do you select an entire column?
  23. You can use the format painter multiple times before you turn it off by
  24. What will be the output if you format the cell containing 5436.8 as #,##0.00'?
  25. Which would you choose to create a bar diagram?
  26. It is acceptable to let long text flow into adjacent cells on a worksheet when
  27. When the formula bar is active, you can see
  28. You can activate a cell by
  29. To return the remainder after a number is divided by a divisor in EXCEL we use the function?
  30. To record a sequence of keystrokes and mouse actions to play back later we use: