Dumps4cert.com : Latest Dumps with PDF and VCE Files
2018 Aug Cisco Official New Released 400-101
100% Free Download! 100% Pass Guaranteed!
Excel 2013
Question No: 1 CORRECT TEXT
Add a header and the date for each of the columns (assignments) in the range. Cell B2.
Text quot;Datequot;.
Cell Range C2: S2
Text: quot;22-Aug, 29-Aug,…12-Decquot;
Answer: Use the following steps to complete this task in explanation:
Explanation:
Step 1:Click Cell B2. Type the text: Date Step 2: Click cell C2. Type the text: 22-Aug Step 3: Click cell D2. Type the text: 29-Aug Step 3:Click cell C2, then shift-click cell D2.
Step 4:Copy until cell S2(by dragging from cell D2 to cell S2).
Question No: 2 CORRECT TEXT
Formula. Find the average of each student#39;s homework scores. Cell range C7:C29
Use Function AVERAGE
Number 1: all homework for each student on quot;Section 3quot; worksheet quot;22-Aug 12-Decquot;
Answer: Use the following steps to complete this task in explanation:
Explanation:
Step 1:Click cell C7, and the click the Insert Function Button.
Step 2:In the Insert Function dialog box select Category Statistical, select function AVERAGE, and click OK.
The function Arguments Dialog box appears:
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. Then click the OK button.
Step 5:Copy cell C7 downwards until cell C29.
Result will be like:
Question No: 3 CORRECT TEXT
Insert the instructor#39;s name for column B. Cell B5.
Use Function RIGHT Text: B2
Absolute reference Num_chars: quot;16quot;
Answer: Use the following steps to complete this task in explanation:
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 No: 4 CORRECT TEXT
Formula.
Find themaximum homework score for each student. Cell rangeE7:E29
Use Function MAX
Number 1: maximum homework score for each student on quot;Section 3quot; worksheet.
Answer: Use the following steps to complete this task in explanation:
Explanation:
Step 1: Click cellE7, and the click the Insert Function Button.
Step 2: In the Insert Function dialog box select Category Statistical, select function MAX, and click OK.
The function Arguments Dialog box appears:
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. Then click the OK button.
Step 5: Copy cellE7 downwards until cellE29.
Result will be like:
Question No: 5 CORRECT TEXT
Rename a table. Cell range B6:F29 Name: quot;Overviewquot;
Answer: Use the following steps to complete this task in explanation:
Explanation:
Step 1:Click cell B6, and shift-click cell F29.
Step 2: Click the Name box at the left end of the formula bar. Step 3: Type: Overview. Press ENTER.
Question No: 6 CORRECT TEXT
Modify the text in the title. Cell A1.
Text quot;Math 1080 – Section 3 Assignmentsquot;
Answer: Use the following steps to complete this task in explanation:
Explanation:
Step 1:Click cell A1
Step 2:Change the text by typing to: Math 1080 – Section 3 Assignments
Question No: 7 CORRECT TEXT
Crop the picture.
Books.jpg
Crop to Shape Snip Same Side Corner Rectangle.
Answer: Use the following steps to complete this task in explanation:
Explanation:
Step 1:Click on the picture.
Step 2:In the Format menu (which is displayedautomatically) click the Crop Command, select Crop to Shape, and click Snip Same Side Corner Rectangle.
Question No: 8 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 quot;Section 3quot; worksheet. Criteria: 0
Answer: Use the following steps to complete this task in explanation:
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:
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:
Question No: 9 CORRECT TEXT
Change the color theme.
MathTracker.xlsx Slipstream
Answer: Use the following steps to complete this task in explanation:
Explanation:
Step 1:Click the PAGE LAYOUT tab, click Colors, scroll down and select Slipstream.
Question No: 10 CORRECT TEXT
Formula.
Find the minimum homework score for each student. Cell range D7:D29
Number 1: minimum homework score for each student on quot;Section 3quot; worksheet.
Answer: Use the following steps to complete this task in explanation:
Explanation:
Step 1: Click cell D7, and the click the Insert Function Button.
Step 2: In the Insert Function dialog box select Category Statistical, select function MAX, and click OK.
Formula.
Find the minimum homework score for each student.
Answer:
Step 1: Click cell D7, and the click the Insert Function Button.
Step 2: In the Insert Function dialog box select Category Statistical, select function MIN, and click OK.
The function Arguments Dialog box appears:
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. Then click the OK button.
Step 5: Copy cell D7 downwards until cell D29.
Result will be like:
100% Dumps4cert Free Download!
–400-101 PDF
100% Dumps4cert Pass Guaranteed!
–400-101 Dumps
Dumps4cert | ExamCollection | Testking | |
---|---|---|---|
Lowest Price Guarantee | Yes | No | No |
Up-to-Dated | Yes | No | No |
Real Questions | Yes | No | No |
Explanation | Yes | No | No |
PDF VCE | Yes | No | No |
Free VCE Simulator | Yes | No | No |
Instant Download | Yes | No | No |