33.4 33.4 ABS(A1)-22 22 ABS(A2)

11 ABS(11)

Game 1 Game 2 Game 3Joe 145 121 190 FALSEBetty 208 119 170 FALSEJack 225 201 253 TRUEBrad 150 202 157 FALSE

Bowling scores

Scored over 200 in all games?

Student GradeJoe 90Jim 83Jenn 71Jill 88

83 AVERAGE(B2:B5)

1 Joe CHOOSE(1,"Joe","Jim","Tom")2 Jim CHOOSE(A2,"Joe","Jim","Tom")

Combined716 555 1234 716-555-1234 CONCATENATE(A2,"-",B2,"-",C2)716 555 1234 716-555-1234 A3&"-"&B3&"-"&C3

John Dale Smith John Dale Smith A4&" "&B4&" "&C4

Joe123

Excel11/16/2014

234.29(

3 COUNT(A1:A6)

Joe

Excel11/16/2014

234.29(

5 COUNTA(A1:A7)

Joe

Excel11/16/2014

234.29(

2 COUNTBLANK(A1:A7)

Student GradeJoe 78Jim 80Jill 95Jean 75Joe 61Julie 80Joe 57

5 COUNTIF(B2:B8,">65")

3 COUNTIF(A2:A8,"Joe")

How many scored over 65?

How many Students named Joe?

Student Class GradeJoe Science 78Jim Math 80Jill History 95Jean Math 75Joe Math 61Julie Gym 80Joe Math 57Julie Science 90Jim English 63

2 COUNTIFS(A2:A10,"Joe",B2:B10,"Math")Count of Joe and Math

joe joe TRUE

123.4 123 FALSE

Excel excel TRUE

Excel by Joe1 7

Excel by Joe 4

Excel by Joe #VALUE!

original new function14914.2158 14,914.2 FIXED(A2,1)14914.2158 14,914.22 FIXED(A3,2)14914.2158 14,914.216 FIXED(A4,3)14914.2158 14914.22 FIXED(A5,2,TRUE)14914.2158 14,914.22 FIXED(A6,2,FALSE)

Joe Tom Stef GinaMath 62 82 67 89English 57 53 56 52Science 86 88 81 70History 69 100 88 91

Find Joe's English Score: 57

Student Math Grade English GradeJoe 88 82 Math is higherSam 78 92 English is higherMike 90 64 Math is higher

3 10 3 INDEX(A1:B4,3,2)1 4 9 SUM(INDEX(A1:B4,3,0))6 37 8

Original After Function FunctionExcel by joe 0 ISBLANK(A2)Joe 0 ISBLANK(A3)

1 ISBLANK(A4)Macros 0 ISBLANK(A5)

Original After Function FunctionExcel 0 ISERROR(A2)Joe 0 ISERROR(A3)

#N/A 1 ISERROR(A4)#REF! 1 ISERROR(A5)

#VALUE! 1 ISERROR(A6)

Original After Function FunctionExcel 0 ISNA(A2)Joe 0 ISNA(A3)

#N/A 1 ISNA(A4)Excel by joe 0 ISNA(A5)

Student Test Score Test Score DateTim 77 77 3-Oct

Mike 90 90 10-OctShelly 80 80 15-AugJenn 83 83 7-OctTim 56 56 17-SepJohn 69 69 17-SepSally 98 98 5-SepMike 67 67 4-Apr

George 68 68 31-AugBarb 59 59 4-Sep

LARGE 83 90 3-OctFormula: LARGE(B2:B11,3) LARGE(C2:C11,2) LARGE(D2:D11,3)

Original Result FormulaExcel by Joe Exce LEFT(A2,4)515 Main Street 515 Ma LEFT(A3,6)24314 243 LEFT(A4,3)

Original After Function FunctionHow long is this phrase? 24 LEN(A2)

123456 6 LEN(A3)

Original After Function Function244 West Tupper BLVD. 244 west tupper blvd. LOWER(A2)

242 3 MATCH(24,A3:A10,0)301 4 MATCH("j*",A3:A11,0)24 7 MATCH(90,A3:A11,1)Joe #N/A MATCH(90,A3:A11,0)39

Tom88

299AJ

Student Test Score Date Test Score Test ScoreTim 77 3-Oct 77 77

Mike 90 3-Oct 90 90Shelly 80 6-Oct 80 80Jenn 83 17-Sep 83 83Tim 56 17-Sep 56 56John 69 17-Sep 69 69Sally 98 5-Sep 98 98Mike 67 4-Apr 67 67

George 68 4-Sep 68 68Barb 59 4-Sep 59 59MAX 98 6-Oct 98 110

MAX(B2:B11) MAX(C2:C11) MAX(D2:D11,80) MAX(E2:E11,110)

Original Result FormulaExcel by Joe by MID(A2,7,2)716-555-1234 555 MID(A3,5,3)

Student Test Score Date Test Score Test ScoreTim 77 3-Oct 77 77

Mike 90 3-Oct 90 90Shelly 80 6-Oct 80 80Jenn 83 17-Sep 83 83Tim 56 17-Sep 56 56John 69 17-Sep 69 69Sally 98 5-Sep 98 98Mike 67 4-Apr 67 67

George 68 4-Sep 68 68Barb 59 4-Sep 59 59MIN 56 4-Apr 56 40

Formula MIN(B2:B11) MIN(C2:C11) MiN(D2:D11,80) MiN(E2:E11,40)

4/22/2023 11:43 Now()

Jeffs Mon hours: 8 OFFSET(A3,2,1)Jeffs weekly hours: 24 SUM(OFFSET(A3,2,1,1,4))Names Mon Tues Wed ThursJoe 4 6 6 8Jeff 8 8 8 0Mike 8 4 8 8

Game 1 Game 2 Game 3Joe 145 121 190 FALSEBetty 208 119 170 TRUEJack 225 201 253 TRUEBrad 150 202 157 TRUE

Bowling scores

Scored over 200 in any game?