Learn Practical Use of MAX Function and MIN Function in Excel Worksheets

What is MAX Function?

The MAX function is used to get the maximum number from different given numbers in Excel Worksheet.

Syntax of MAX Function in Excel

MAX(number1,number2,number3,...numberN)
For example the function MAX(5,100,35) will return 100, since 100 is largest number of all 5, 100 and 35.

Syntax of MAX Function using Cell References

MAX(CellRef1:CellRef2)
Where CellRef1 is the cell reference of the first cell and CellRef2 is the cell reference of the last cell in the given cell range in Excel Worksheet.

What is MIN Function?

use of Min Function Microsoft Excel Formulas and Functions

The MIN function is used to get the minimum number from different given numbers in Excel Worksheet.

Syntax of MIN Function in Excel

MIN(number1,number2,number3,...numberN)
For example the function MIN(5,100,35) will return 5, since 5 is the smallest number of all 5, 100 and 35.

Syntax of MIN Function using Cell References

MIN(CellRef1:CellRef2)
Where CellRef1 is the cell reference of the first cell and CellRef2 is the cell reference of the last cell in the given cell range in Excel Worksheet.

How To Implement MAX Function in Excel

First of all place the cursor in an empty cell to enter the function.

Type =
Type the function name MAX
Type the left parenthesis (
Select the cell range A2 to E2 with the help of mouse so that the arguments A2:E2 will be automatically entered in the MAX function.
Note: that you may type A2:E2 by keyboard also.
Press Enter key (You need not to enter right parenthesis, it will be automatically included)
The result 50 will be displayed in the cell.

How To Implement MIN Function in Excel

First of all place the cursor in an empty cell to enter the function.

Type =
Type the function name MIN
Type the left parenthesis (
Select the cell range A2 to E2 with the help of mouse so that the arguments A2:E2 will be automatically entered in the MIN function.
Note: that you may type A2:E2 by keyboard also.
Press Enter key (You need not to enter right parenthesis, it will be automatically included)
The result 5 will be displayed in the cell.

Example Worksheet Picture For MAX and MIN Functions

Practical Use of Max Function and MIN Min Function in Excel Worksheet

Comments

Explain Different Types Of Data

DATA Data is the collection of raw facts and figures. It is without any proper meaning. Data may be collection of words, numbers, graphics or sounds. What is data? Explain different types of data Examples of Data 1) Student Data on Admission Forms When students get admission in a college. They fill admission form. This form contains raw facts (data of student) like name, father’s name, address of student etc. 2) Data of Citizens During census, data of all citizens is collected. 3) Survey Data Different companies collect data by survey to know the opinion of people about their product. 4) Students Examination data In examination data about obtained marks of different subjects for all students is collected. Different Types Of Data There are following main types of Data. 1) NUMERIC DATA Numeric data consists of 0 to 9 digits, + and – sign and dec...

What are Dual Devices or Both Input/ Output Devices

The devices that can be used to perform both functions -input and output- are called Dual Devices. These devices are also called Dual Purpose Devices or Both Input/Output Devices. With the help of a dual purpose device, we can enter data into computer as well as we can output data from the computer to outside world. For example, Dual devices include: Touch Screen Monitor, Modem, Network Interface Card, Sound card, Hard disk drive, Floppy disk Drive, Magnetic Tape Drive CD-Writer and DVD-Writer etc. These are also called Input/output devices, because they perform both functions. Touch Screen Monitor Dual Devices or Both Input / Output Devices - Touch screens Touch Screen Monitor is an input/output device. It uses a special touch sensitive screen. The User can enter data by touching icons or menus on the screen. As soon as the user selects a command from menu, output is displayed on screen. Commonly touch screen monitors use sensors to detect touch of finger. ...

Advantages and Disadvantages of Tree Topology

Tree Topology Actually, a Tree topology is the combination of two topologies: bus topology and star topology . A tree topology combines the characteristics of bus and star topologies. It consists of groups of computer connected as star topology. These groups are then connected to a central communication medium (bus cable). Advantages and Disadvantages of Tree Network Topology Advantages of Tree Network Topology 1. Many software and hardware vendors support tree topology . 2. It provides point-to-point wiring for individual groups. Disadvantages of Tree Network Topology 1. If the main backbone line breaks, the entire tree network goes down . 2. A tree network is more difficult to configure and maintain. 3. If any hub fails, related segment will be removed from the network. Read More on Networking and Networks 1 Explain Advantages Of Networks 2 Types Of Computer Networks...

Perfect Computer Notes

Search This Blog