is functions help

profilemsconqider331
cis26_practiceizziesandembeddingfunctions.xlsx
Home>Computer Science homework help>is functions help

Izzies

IS Functions
ISBLANK NOT IS BLANK embedded function within an if function isnontext NOT nontext embedded function within an if function isNumber Not isNumber embedded function within an if function isText Not isText embedded function within an if function
abcdef
123456
xyz123
&*(
xyzlmn
(cis)
2345
3456
45678
6789
99999
xyz
123
Purpose:
Practice embedding izzie functions within an if (remember the izzie functions return a value of True or False, which you can use as a criteria in an If function) Explore the results when the izzie function is combined with the NOT() function
Instructions:
In this worksheet you will use one these functions: Isblank(), isnontext(), isnumber(), istext(), Not(), and if()
Data is in A5:A25
For each row 5 through 25:
Determine if the value in column A is blank
1. In B5:B25 enter an ISBLANK() function
2. In C5:C25 combine the NOT() function with the ISBLANK() function
3. In D5:D25 embed the ISBLANK() function within an IF function and return an appropriate response. (Experiment using either the ISBLANK() or the NOT(ISBLANK()) functions -- make sure your your response is appropriate for the one you use!).
THINK: Are these the responses you were expecting?
Determine if the value in column A is anything other than text
4. In E5:E25 enter an ISNONTEXT() function
5. In F5:F25 combine the NOT() function with the ISNONTEXT() function
6. In G5:G25 embed either of the functions used in 4 and 5 within an IF function and return an appropriate response.
Determine if the value in Column A is a number
7. In H5:H25 enter an ISNUMBER() function
8. In I5:I25 combine the NOT() function with the function used in Step 7.
9. In J5:J25 embed either of the functions used in 7 and 8 within an IF function and return an appropriate response.
Determine if the value in Column A is text
10. In K5:K25 enter an ISTEXT() function
11. In L5:L25 combine the NOT() function with the ISTEXT() function
12. In M5:M25 embed either of the functions used in 10 and 11 within an IF function and return an appropriate response.

TEXT Functions

Text Functions Practice
Data First 3 characters Are the first 3 characters text? Are the first 3 characters a number? do the first three characters equal "abc" use if() Exactly equal First 3 characters using UPPER function First 3 characters using LOWER function Blank space in Data the chacter in the 4th position EXACT match of 4th character in data with " " Length of data in Column A Data with any extra blank spaces removed EXACT match of 4th character in data with " "
ABC 123
123 ABC
Abc 123
aBC 123
XYZ 345
345 XYZ
xYz 345
abc 123
123456
789
ab
abc
15678
abcdefg
ABC 1234
ABCD 1234
abcd1234
Purpose:
Practice embedding text functions within another function (to eventually end up with a value that you can use as a criteria in an If function) In other words: In Every function here, ONLY refer to the data column!
Use: LEFT(), RIGHT(), MID(), LEN(), ISTEXT(), ISNUMBER(), UPPER(), LOWER(), EXACT(), FIND(), TRIM(),
For each row 4 through 20:
Column B: return the the first three characters of the value of column A (Use: Left() )
Column C: determine if these three characters are text (use: Istext() and Left() )
Column D: determine if the first three characters in string is a number (use: ISNUMBER(), LEFT() )
THINK: some of the values in column A are numbers, so what happens when you use the left() function?
Column E: determine if the first three characters in column A equal "abc" (use: if()function and comparison operator, giving appropriate response if true/false; LEFT() function)
Column F: determine if they are EXACTLY equal (when case senstivity is important) (USE: EXACT(), LEFT() )
THINK: If combined with a VLOOKUP function, do you need an EXACT match?
Column G: return the uppercase representation of first three characters of the value of column A using an UPPER() function
Column H: return the lowercase representation of the first three characters of the value of column A. Use: LOWER(), LEFT()
Column I: determine if you have a blank space in your text string in Column A (use FIND());
THINK: The find function did not work when the value in column A did not include a blank space or the value was a number
Column J: determine what character you have in the fourth position of your text string in column A (USE: Mid() )
Column K: knowing that you should have a space in the 4th position of your data for some rows, determine if you do (Use: EXACT(), MID() )
THINK: The data in A14 does not "look" like it has a blank in the fourth position of the text string.
Column L: Determine the length of the text string in Column A. Use: LEN()
NOTE that the computer says the length of your data in A14 is 12 characters
Column M: Use the Trim() function to remove any extra blank spaces at the end of your text string
Column N: Now determine whether you have an blank in the 4th position of your data in column A ( USE: EXACT(), MID(), TRIM() )