CORRECT TEXT Insert the instructor's name for column B. Cell B5. Use Function RIGHT Text: B2 Absolute reference Num_chars: "16"
Correct Answer:
Use the following steps to complete this task in 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.
Question 2
CORRECT TEXT Insert data from a text file. Cell A1. File source Autumn.txt Tab-delimited
Correct Answer:
Use the following steps to complete this task in Explanation: Step 1:Click cell A1. Step 2:Click the Data tab, and click the From Text button. The Text Import Wizard starts. Step 3:Make sure Delimited is select, and click Next. Step 4:Make sure Delimiters: Tab is selected. Then click Next. Step 5:Finish the wizard by click the Finish Button. Step 6: Confirm with OK in the Import Data dialog box.
Question 3
CORRECT TEXT Create a hyperlink to another worksheet. Cell A2. Cell reference "A3" Sheet reference "Section 3" worksheet.
Correct Answer:
Use the following steps to complete this task in Explanation: Step 1:Click cell A2. Step 2:On the Insert tab, in the Links group, click Hyperlink. Step 3:In the Insert Hyperlink dialog box, in the Type the cell reference: type A3, select Cell Reference 'Section 3', and click OK.
Question 4
CORRECT TEXT Formula. Count the number of 0 homework scores for each student. Cell range F7:F29 Use function COUNTIF Range: all possible homework scores for each student on "Section 3" worksheet. Criteria: 0
Correct Answer:
Use the following steps to complete this task in Explanation: Step 1: Click cell F7, and the click the Insert Function Button. Step 2: In the Insert Function dialog box select Category Statistical, select function COUNTIF, and click OK. The function Arguments Dialog box appears: Microsoft 77-420 : Practice Test Step 3: Click on the Section 3 tab (left bottom part of the window). Step 4: Locate the data for the first student. This well be cell range C2 to N2. Click C2 and then Shift-click cell N2.Press Enter. Step 5:In the Function Arguments Dialog box, in the Criteria field type: 0. Then click the OK button. Step6: Copy cellF7 downwards until cellF29. Result will be like:
