PDF chapter test TRY NOW

1. What is the use of MAX () and MIN () functions?
 
MAX Function:

It a given set of values.
 
Syntax:
 
 
Example:
 
To determine the  of the four fields \(C2\) to \(C5\) using the MAX function is,
 
 
 
MIN Function:

It  a given set of values.
 
Syntax:
 
 
Example:
 
To determine the  of the four fields \(C2\) to \(C5\) using the MIN function,
 
  
2. What is cell address?
 
The intersection of a row and a column is known as . Each cell is identified by its address. The cell address is a . The name box displays the address of the .