Question: Solve this Putting the FUN in FUNctions...Notice below that there are 4 worksheets in this file. You must successfully complete all 4. In this worksheet,

Solve this

Putting the FUN in FUNctions...Notice below that there are 4 worksheets in this file. You must successfully complete all 4. In this worksheet, you will type the function in COLUMN D. Alll 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 lyour function logi Use This Data Product Quantit|Navigation Instructions: 3 return Play Ball. if not, then return Strike. Your See Bas needed. iresult will be Play Ball Please Type Function 7 Use RIGHT function to return only Ball from cell A17 (Wiffle Ball) Please Type Function Use LEFT function to return only Basket from cell A10 (Basketball) Please Type Function (Use CONCAT function to return a value "I like Basketball and Baseball\". Use cells from column A. You should have I like, space,cell ref, space, the word land, space,cell ref. Remember when to put strings in \"quotations\". Watch your spaces; precision matters! That means don't hit the space bar if not Inecessary. This one is sometimes challenging. Please Type Function Use TEXTIOIN function to Join all products in A9 through A18. You need to separate each value by a comma and a space. The comma and space is contained lin 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. Please Type Function

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!