Please help! In this worksheet, you will type the function in coLUMN D$.$ All cells are locked except for the cells you enter your answer. Pay attention to spelling. You will also need to sometimes use $"($quotes with a space inside$)$ If you need space between words or $","$If you need a comma and a space, Think about your output result as you create your function logic.

Use This Data

$\backslash$table$[[$Product$,$Quantity$],[$Bicycle$,4],[$Basketball$,3],[$Solf Club,$7],[$Baseball$,8],[$Soccer Ball,$5],[$Tennis Racket,$3],[$Hockey Stick,$5],[$Bean Bag,$],[$Wiffle Ball,$],[$Paddle$,]]$

Navigation Instructions: $$ Use the numbers in column B for the below identified functions AVERAGE averages all numbers in a range. Use column is for the range to find the average quantity of all items MAX refers to largest numbers in a range of cells Use column $B$ for the range to find the max value MIN refers to smallest number in a range of cells. Use column B for the range to find the MIN value COUNT counts all numbers in a range of cells. Use column B for the range to count how many items COUNTA counts the number of cells in a range that are NOT empty. Use column B for the range to count how many items that are not blank. COUNTBLANK counts the number of EMPTY cells in a range of cells. Use column B for the range that are empty.

$\backslash$table$[[$NAVIGATION INSTRUCTIONS: USE REFERENCE COLUMNS FROM COLUMNS A and B ABOVE TO CREATE THE FUNCTIONS,TYPE THE ENTIRE FUNCTION INCUDING CEL ADDRESSES,Feedback:$],[$Use MID function to return only the ccin Soccer Ball,,Please Type$],[$Use LEN function to count the nunber of characters in Bean Bag,,Please Type$],[$Use LOWER function to to make Wiffle Ball all lower case,,Please Type$],[$Use UPPER function to moke hackey stick all capitals,,Please Type$],[\backslash$table$[[$Use If function to return a phrase of Ploy Ball or Strike depending on the logic test. If Baseball quantity $23$ return Play Ball, if not, then return Strike, Your$],[$result will be Play Ball.$]],,$Please Type$],[$Use RIGHT function to return anly Ball from cell A$17($Wiffle Ball$),,$Please Type$],[$Use LEFT function to refurn only Basket from cell A$10($Basketball$),,$Please Type$],[\backslash$table$[[$Use CONCAT function to return a value "I like Basketball and Dasebali". Use cells from column A$.$ You should have I like,space, cell ref, space, the word$],[$and$,$space, cell ref. Remember when to put strings in "quotations". These instruction tell you where to put the comma's; did you read carefully? Wotch your$],[$spaces; precisian matters! Thet means don't hit the space bar if not necessary. This one is sometimes challenging.$]],,$Please Type$],[\backslash$table$[[$Use TEXTJOIN function to Join all products in A$9$ through A$18.$ You need to separate each value by a comma and a space. The comma and space is contained$],[$in the first part of the function for the delimiter, If you define the delimiter as a comma and space, there will be a comma and space after each of the values.$],[$Make sure to ignore any empty spaces when constructing the formula $($hint: use TRUE in your formula string$).$ It will read as:$],[$Bicycle$,$ Basketball, Golf Club, Baseball, Soccer Ball, Tennis Racket, Hockey Stick, Bean Bag, Wiffle Ball, Paddle.$]],$v$,$Please Type$]]$

Number Correct