nerdexam
Microsoft

77-420 · Question #20

Insert the instructor's name for column B. Cell B5. Use Function RIGHT Text: B2 Absolute reference Num_chars: "16"

Step 1: Open the correct worksheet (Summary Worksheet). Step 2: Click in cell B5. Step 3: Click on the insert function button. Step 4: In the Insert Function Dialog box select the Category Text, scroll down and click on the function RIGHT, and click OK. Step 5: In the Function Ar

Perform Operations with Formulas and Functions

Question

Insert the instructor's name for column B. Cell B5. Use Function RIGHT Text: B2 Absolute reference Num_chars: "16"

Explanation

Step 1: Open the correct worksheet (Summary Worksheet). Step 2: Click in cell B5. Step 3: Click on the insert function button. Step 4: In the Insert Function Dialog box select the Category Text, scroll down and click on the function RIGHT, and click OK. Step 5: In the Function Arguments Dialog box in the Text box type B2, in the Num_chars type 16, and click OK.

Topics

#RIGHT function#absolute reference#text function#cell reference

Community Discussion

No community discussion yet for this question.

Full 77-420 Practice