“MOD” function in Excel is used for-
“MOD” function in Excel is used for-
एक्सेल में ”MOD” फंक्शन (फलन)………….. के लिए प्रयोग किया जाता है-
Detailed Solution & Logic
Correct Answer:
Returning remainder from division/भाग से प्राप्त शेषफल
The MOD() function in Excel returns the remainder after a number is divided by another number.
Syntax:
=MOD(number, divisor)
Example:
=MOD(10, 3) → Result = 1 (because 10 ÷ 3 = 3 remainder 1)
So, MOD is used to find the remainder, not the quotient or modulus conversion.
Similar Practice Questions
If you use the Fill Handle to drag the cell containing ‘Q1’ in MS Excel,
If you use the Fill Handle to drag the cell containing ‘Q1’ in MS Excel,...
What is the difference between dragging
What is the difference between dragging text with the mouse (left-click) and Ctrl + dragging...
Which of the following file management tools allows users to browse and manage files in Windows OS?
Which of the following file management tools allows users to browse and manage files in...
When using the ‘Replace’ function (Ctrl + H)
When using the ‘Replace’ function (Ctrl + H) in MS PowerPoint, which of the following...
Which of the following methods is the
Which of the following methods is the quickest way to open an existing MS Excel...
In MS Excel 365 which of the following
In MS Excel 365 which of the following shortcut keys is used to select entire...
The “Connections” command in Microsoft Excel is found under which tab ?
The “Connections” command in Microsoft Excel is found under which tab ? माइक्रोसॉफ्ट एक्सेल में...