Mini Challenge: Text Functions
Use Text Functions to write statements
Instructions
In this challenge we will use text f
Ishan's Brainwave 10/24/2015 given. The sentences need to be c
using text functions.
Construct the sentence using the "
Construct the same sentence usin
Ishan had the brainwave on 24 October 2015. Using & 1. "Ishan had the brainwave on 2
Ishan had the brainwave on 24 October 2015 Using CONCATENATE - In Cell A5 - Use the & function an
above.
- In Cell A6 - Use the CONCATENAT
Alia's First Day 4/2/2018 *Text functions should be used to
2. "Alia joined Food2Go on..."
- In Cell A11 - Use the & function t
- In Cell A12 - Repeat using the CO
Alia joined Food2Go on 02 April 2018 Using & *Text functions should be used to
Alia joined Food2Go on 02 Apr 2018. Using CONCATENATE 3. "Ishan's flight duration was...h
- In Cell A16 - Use the & function t
- In Cell A17 - Repeat using the CO
Flight Duration 5:24 *Text functions should be used to
4. "The new user interface was te
- In Cell A22 - Use the & function t
Using & - In Cell A23 - Repeat using the CO
*Text functions should be used to
5. When you are done, check you
worksheet.
4. "The new user interface was te
- In Cell A22 - Use the & function t
- In Cell A23 - Repeat using the CO
Using CONCATENATE *Text functions should be used to
5. When you are done, check you
worksheet.
Total Testing hours 5:33
Ishan's flight duration was 5 hours and 24 minutes. Using &
The new user interface was tested for 5 hours and 33
minutes on Monday. Using CONCATENATE
allenge: Text Functions
tions
hallenge we will use text functions to return the sentence structures
he sentences need to be completed by converting cells in blue to text
xt functions.
ct the sentence using the "&" symbol in the yellow cells.
ct the same sentence using CONCATENATE in the orange cells.
n had the brainwave on 24 October 2015."
A5 - Use the & function and a text function to return the sentence
A6 - Use the CONCATENATE function
unctions should be used to convert the date in cell B3 to text format.
joined Food2Go on..."
A11 - Use the & function to complete the sentence.
A12 - Repeat using the CONCATENATE function
unctions should be used to convert the date in cell B8 to text format.
n's flight duration was...hours and... minutes."
A16 - Use the & function to complete the sentence.
A17 - Repeat using the CONCATENATE function
unctions should be used to convert the date in cell B14 to text format.
new user interface was tested for...hours and... minutes on Monday."
A22 - Use the & function to complete the sentence.
A23 - Repeat using the CONCATENATE function
unctions should be used to convert the date in cell B20 to text format.
n you are done, check your worksheet against the Solution
eet.
new user interface was tested for...hours and... minutes on Monday."
A22 - Use the & function to complete the sentence.
A23 - Repeat using the CONCATENATE function
unctions should be used to convert the date in cell B20 to text format.
n you are done, check your worksheet against the Solution
eet.
Use Text Functions to write statements
Ishan's Brainwave 10/24/2015 Mini Challenge: Text Functions
Solution - Click on the yellow and
syntax.
Ishan had the brainwave on 24 October 2015. Using & 1. "Ishan had the brainwave on 24
Ishan had the brainwave on 24 October 2015 Using CONCATENATE *You can play around - "DD MMM
and "DD MMM YY" will return 24
2. "Alia joined Food2Go on 02 Ap
Alia's First Day 4/2/2018
3. "Ishan's flight duration was 5 h
4. "The new user interface was te
Monday."
Alia joined Food2Go on 02 Apr 2018. Using &
Text arguments must be entered i
Alia joined Food2Go on 02 Apr 2018. Using CONCATENATE before/after words if you want sp
when the sentence is formed.
Flight Duration 5:24
Ishan's flight duration was 5 hours and 24 minutes. Using &
Ishan's flight duration was 5 hours and 24 minutes. Using CONCATENATE
Total Testing hours 5:33
The new user interface was tested for 5 hours and 33
Using &
minutes on Monday.
The new user interface was tested for 5 hours and 33
minutes on Monday. Using CONCATENATE
allenge: Text Functions
n - Click on the yellow and orange cells to review the function
n had the brainwave on 24 October 2015."
n play around - "DD MMMM YYYY" will return 24 October 2015
D MMM YY" will return 24 October 15.
joined Food2Go on 02 April 2018."
n's flight duration was 5 hours and 24 minutes."
new user interface was tested for 5 hours and 33 minutes on
y."
guments must be entered in " ". You must enter a space
after words if you want spaces to appear between arguments
he sentence is formed.
