Excel 2019 Lesson 5.6

Function used to find the largest number in the cell range B4 through J4.

• =MAX(B4:J4)

• =LARGEST(B4:J4)

• =MAX(B4-J4)

• @MAX(B4:J4)

Function used to find the smallest number in the cell range B2 through H4

• =MIN(B2:H4)

• @MIN(B2:H4)

• =SMALLEST(B2:H4)

• =MIN(B2-H4)

Function used to find the average of the cell range H2 through J2.

• @AVE(H2:J2)

• =AVE(H2:J2)

• =AVERAGE(H2:J2)

• =AVERAGE(H2+J2)

Function to find the middle number in the cell range F8 through Z8.

• =MIDDLE(F8:Z8)

• =MEDIAN(F8:Z8)

• IF(F8+Z8=MIDDLE,F8,Z8)

• =MID(F8:Z8)

Function to get the last 4 digits in cell G2 that contains 78536214.

• =LAST(G2,4)

• =RIGHT(G2,4)

• =CONCAT(G2,4)

• =LEFT(G2,5,4)

Function to get the first 4 digits in cell G2 that contains 78536214.

• =LAST(G2,4)

• =FIRST(G2,4)

• =CONCAT(G2,4)

• =LEFT(G2,4)

Function to determine the length of cell E4 which contains "Smith".

• =LENGTH(E4)

• =LEN(E4)

• =LENGTH("SMITH")

• =CONTENT(E4)

Function used to count how many non-blank cells are in C4 through G4.

• =COUNTA(C4:G4)

• =NOTBLANK(C4:G4)

• =COUNT(C4:G4=BLANK)

• =COUNTBLANK(C4:G4)

Function used to count how many BLANK cells are in C4 through G4.

• =COUNTA(C4:G4)

• =BLANK(C4:G4)

• =COUNT(C4:G4=BLANK)

• =COUNTBLANK(C4:G4)

Function(s) to use to combine A1 (John), A2 (Smith) cells to look like "John Smith" in A3.

• =TEXTJOIN(" ",1,A1,A2)

• CONCAT(A1," ",A2)

• CONCAT(A1,A2)

• COMBINE(A1,A2)