Q- Fx Guide

 

To use the MAX Function:
1.    Point and Click the cell in which you want the maximum (of a set of cells).
2.    Enter the formula:
	a.    Type:       =
	The equal sign – Indicates to Excel that you are entering a function
	b.   Type:       Max
	This is the name of the function term
	c.   Type:         (
	Open parenthesis – Indicates the start of the argument, (which cells to find maximum)
	d.    Input:  The Argument - The cells you would like to fin a MAXIMUM by either:
	¨        Clicking each individual cell desired (example: A1, B22, C12,D16), ¨        If the cells adjoin each other: Clicking the 1st cell of the row (or column) and dragging to last cell in row (or column) (example: A1 drag to A15, release),   Using the keyboard cursors (arrows) arrow to the top/left most cell.    Press and Hold the SHIFT key and arrow down to the bottom/right most cell and release the SHIFT key, ¨        Typing in the named cells – If you have already named the cell(s) - Must be separated by commas
	e.    Type:           )          Close parenthesis – Indicates the end of the MAXIMUM argument.
3. Press      <Enter>
4. Excel will automatically display the MAXIMUM value of the given set.