PC World - USA (2020-04)

APRIL 2020 PCWorld 127

changed, you’d have to re-sort. And, if
you’re sorting multiple columns/fields with a
lot of records/rows, the sort option could
get cumbersome.
The MIN/MAX functions remain the
same regardless of the changes in the data,
even if you add more rows (as long as you
add the rows using the Insert > Row feature
within the existing range—that is, above the
cell that contains the formula).
Enter some numbers in column A4:A11,
then enter this formula in A13:
=MIN(A4:A11) and this formula in A14:
=MAX(A4:A11).
NOTE: The MIN/MAX functions
disregard empty cells, TRUE/FALSE answers,
text, text impersonating numbers, symbols,
and punctuation.

7. CONCAT/
   CO N C ATE N ATE
   The functions CONCAT and
   CONCATENATE do the same thing:
   They both combine multiple cells,
   ranges, or strings of data into one
   cell. The most common use of this
   function is to combine first and last
   name into one cell or join the city,
   state, and ZIP code into one cell.
   NOTE: CONCAT replaced
   CONCATENATE in Excel 2016, but
   both functions are still available.
   Note that CONCAT appears only
   under Formulas > Text And
   Formulas > Insert Function >
   Category > Text, but both CONCAT and
   CONCATENATE appear under Formulas >
   Insert Function > Category > All.
   Enter some first names in column A and
   last names in column B. Enter the following

The AVERAGE function.

The MIN

& MAX

function.