Question:
Know the syntax and use of MAX(), MIN(), COUNT(), and SUM().
Know the syntax and use of MAX(), MIN(), COUNT(), and SUM().
Show Hint
MAX = Highest value
MIN = Lowest value
COUNT = Number of numeric cells
SUM = Total of values
Updated On: Mar 2, 2026
Show Solution
Verified By Collegedunia
Solution and Explanation
Concept:
MAX(), MIN(), COUNT(), and SUM() are commonly used built-in functions in spreadsheet software like MS Excel. They help perform quick calculations on numerical data.
1. MAX() Function
Syntax:
\[
\text{=MAX(range)}
\]
Use:
Returns the largest value from a selected range of cells.
Example:
\[
\text{=MAX(A1:A10)}
\]
Finds the highest number in cells A1 to A10.
2. MIN() Function
Syntax:
\[
\text{=MIN(range)}
\]
Use:
Returns the smallest value from a range of cells.
Example:
\[
\text{=MIN(B1:B10)}
\]
Finds the lowest number in the given range.
3. COUNT() Function
Syntax:
\[
\text{=COUNT(range)}
\]
Use:
Counts the number of cells containing numeric values in a range.
Example:
\[
\text{=COUNT(A1:A10)}
\]
Counts how many cells contain numbers.
4. SUM() Function
Syntax:
\[
\text{=SUM(range)}
\]
Use:
Adds all the numbers in a selected range of cells.
Example:
\[
\text{=SUM(A1:A10)}
\]
Calculates the total of values in the range.
Conclusion:
These functions simplify calculations in spreadsheets: MAX finds the highest value, MIN finds the lowest, COUNT counts numeric entries, and SUM calculates the total.
Was this answer helpful?
0
0
Top CBSE CLASS XII Typography and Computer Applications Questions
- Differentiate between Indented, Fully Blocked, and Semi-Blocked letter styles.
- Define and list features of Office Orders, Office Memorandums, Demi-Official (D.O.) letters, and Office Notes.
- Identify common proofreading symbols, such as signs for NP (New Paragraph), transpose, or centralizing matter.
- Explain the importance of clarity, conciseness, and courtesy in business letters.
- Explain the difference between Relative and Absolute cell referencing.
View More Questions
Top CBSE CLASS XII Spreadsheet Questions
Top CBSE CLASS XII Questions
- 2, b, c are in A.P. and the range of determinant $\begin{vmatrix}1&1&1\\ 2&b&c\\ 4&b^{2}&c^{2}\end{vmatrix}$ is [2, 16]. Then find range of c is
- A boy of mass 50 kg is standing at one end of a, boat of length 9 m and mass 400 kg. He runs to the other, end. The distance through which the centre of mass of the boat boy system moves is
- A capillary tube of radius r is dipped inside a large vessel of water. The mass of water raised above water level is M. If the radius of capillary is doubled, the mass of water inside capillary will be
- A circular disc is rotating about its own axis. An external opposing torque 0.02 Nm is applied on the disc by which it comes rest in 5 seconds. The initial angular momentum of disc is
- A circular disc is rotating about its own axis at uniform angular velocity \(\omega.\) The disc is subjected to uniform angular retardation by which its angular velocity is decreased to \(\frac {\omega}{2}\) during 120 rotations. The number of rotations further made by it before coming to rest is
View More Questions