b. Write down the formula to find
HIGHEST and LOWEST marks in the
subsequent columns wherever
applied (write down the formula).
its computer plzzz send the answer fast i will make you brainlist
Answers
Explanation:
How to make a MAX formula in Excel
To create a MAX formula in its simplest from, you can type numbers directly in the list of arguments, like this:
=MAX(1, 2, 3)
In practice, it's quite a rare case when numbers are "hardcoded". For the most part, you will deal with ranges and cells.
The fastest way to build a Max formula that finds the highest value in a range is this:
In a cell, type =MAX(
Select a range of numbers using the mouse.
Type the closing parenthesis.
Press the Enter key to complete your formula.
For example, to work out the largest value in the range A1:A6, the formula would go as follows:
=MAX(A1:A6)

If your numbers are in a contiguous row or column (like in this example), you can get Excel to make a Max formula for you automatically. Here's how:
Select the cells with your numbers.
On the Home tab, in the Formats group, click AutoSum and pick Max from the drop-down list. (Or click AutoSum > Max on the Formulas tab in the Function Library group.)
This will insert a ready-to-use formula in a cell below the selected range, so please make sure there is at least one blank cell underneath the list of numbers that you've selected:

5 things to know about MAX function
To successfully use Max formulas your worksheets, please remember these simple facts:
In the current versions of Excel, a MAX formula can accept up to 255 arguments.
If the arguments do not contain a single number, the MAX function returns zero.
If the arguments contain one or more error values, an error is returned.
Empty cells are ignored.
Logical values and text representations of numbers supplied directly in the list of arguments are processed (TRUE evaluates as 1, FALSE evaluates as 0). In references, logical and text values are ignored.
How to use MAX function in Excel – formula examples
Below you will find a few typical uses of the Excel MAX function. In many cases, there are a few different solutions for the same task, so I encourage you to test all the formulas to choose the one best suited for your data type.
How to find max value in a group
To extract the largest number in a group of numbers, supply that group to the MAX function as a range reference. A range can contain as many rows and columns as you desire. For example, to get the highest value in the range C2:E7, use this simple formula:
=MAX(C2:E7)

Excel MAX IF formula
If you a looking for a formula that works in all versions of Excel 2000 through Excel 2019, use the IF function to test the condition, and then pass the resulting array to the MAX function:
=MAX(IF(B2:B15=F1, C2:C15))
For the formula to work, it must press Ctrl + Shift + Enter simultaneously to enter it as an array formula. If all done correctly, Excel will enclose your formula in {curly braces}, which is a visual indication of an array formula.
It is also possible to evaluate several conditions in a single formula, and the following tutorial shows how: MAX IF with multiple conditions.
MAX IF
Be sure to press Ctrl + Shift + Enter to correctly complete this array formula:
=MAX(IF(C2:C7<>0, C2:C7))
MAX formula returns zero
If a normal MAX formula returns 0 even though there are higher numbers in the specified range, chances are those numbers are formatted as text. It's especially the case when you run the MAX function on data driven by other formulas. You can check this by using the ISNUMBER function, for example:
=ISNUMBER(A1)
If the above formula returns FALSE, the value in A1 is not numeric. Meaning, you should troubleshoot the original data, not a MAX formula.
MAX formula returns #N/A, #VALUE or other error