Microsoft
77-420 · Question #24
Formula. Insert text using a formula Cell K2 Use Function CONCATENATE Text1: "Students with no " Text2: Header of column F Absolute Reference
Step 1: Click K2 and Click on the insert function button. Step 2: Select Category: Text, the CONCATENATE function, and click OK. Step 3: In the Function Arguments dialog box in the Text1 box type: Students with no , and then click the Text2 reference button, and click on the…
Perform Operations with Formulas and Functions
Question
Formula.
Insert text using a formula
Cell K2
Use Function CONCATENATE
Text1: "Students with no "
Text2: Header of column F
Absolute Reference
Explanation
Step 1: Click K2 and Click on the insert function button. Step 2: Select Category: Text, the CONCATENATE function, and click OK. Step 3: In the Function Arguments dialog box in the Text1 box type: Students with no , and then click the Text2 reference button, and click on the header of column F in the worksheet, press the enter Key Step 4: Press the OK button in the Function Arguments dialog box.
Topics
#CONCATENATE function#absolute reference#text formula#cell reference
Community Discussion
No community discussion yet for this question.