Here is a worksheet containing the common core courses a student has taken. My CC Courses...

Transcribed Image Text:

Here is a worksheet containing the common core courses a student has taken. My CC Courses 3 Course Code Title 4 HUMA1660 Introduction to Chinese Art s HLTH1010 6 ISOM1500 Insightful Decisions 7 ENGG1200 Engineering Team Design Experience: Airship S&T Area Credits C-Comm 3. Healthy Lifestyle HLTH QR 9 Area Done? 10 C-Comm Yes 11 E-Comm No 12 HLTH Yes 13 QR Yes 14 S&T Yes 15 SA No To check if he/she has taken a specificarea of common core courses, a formula is written in cell B10 and then copied and pasted to cell B11:B15. The formula is shown below. =IF(ISNA(VLOOKUP (A1e, scs4:SCS7,1, FALSE)), Text 1 Text 2 ) You need to fill in the two blanks so that the formula displays the information as shown above. You need to write the answers clearly in the boxes below. You only need to write a string in each answer. There is no space anywhere in the result. You need to write the correct big/small letters in the string. Text 1 is Text 2 is Here is a worksheet containing the common core courses a student has taken. My CC Courses 3 Course Code Title 4 HUMA1660 Introduction to Chinese Art s HLTH1010 6 ISOM1500 Insightful Decisions 7 ENGG1200 Engineering Team Design Experience: Airship S&T Area Credits C-Comm 3. Healthy Lifestyle HLTH QR 9 Area Done? 10 C-Comm Yes 11 E-Comm No 12 HLTH Yes 13 QR Yes 14 S&T Yes 15 SA No To check if he/she has taken a specificarea of common core courses, a formula is written in cell B10 and then copied and pasted to cell B11:B15. The formula is shown below. =IF(ISNA(VLOOKUP (A1e, scs4:SCS7,1, FALSE)), Text 1 Text 2 ) You need to fill in the two blanks so that the formula displays the information as shown above. You need to write the answers clearly in the boxes below. You only need to write a string in each answer. There is no space anywhere in the result. You need to write the correct big/small letters in the string. Text 1 is Text 2 is

Answer rating: 100% (QA)

Text 1 is No Text ... View the full answer