Microsoft 77-420 - Excel 2013 Exam
Page: 3 / 6
Total 30 questions
Question #11 (Topic: Topic 1)
Crop the picture.
[1]
Crop to Shape Snip Same Side Corner Rectangle.
[1]
Crop to Shape Snip Same Side Corner Rectangle.
Answer: Use the following steps to complete this task in explanation:
Question #12 (Topic: Topic 1)
Insert the instructor's name for column B.
Cell B5.
Use Function RIGHT
Text: B2
Absolute reference
Num_chars: "16"
Cell B5.
Use Function RIGHT
Text: B2
Absolute reference
Num_chars: "16"
Answer: Use the following steps to complete this task in explanation:
Question #13 (Topic: Topic 1)
Formula. Find the average of each student's homework scores.
Cell range C7:C29
Use Function AVERAGE
Number 1: all homework for each student on "Section 3" worksheet "22-Aug 12-Dec"
Cell range C7:C29
Use Function AVERAGE
Number 1: all homework for each student on "Section 3" worksheet "22-Aug 12-Dec"
Answer: Use the following steps to complete this task in explanation:
Question #14 (Topic: Topic 1)
Create a new named range.
Cell range C7:C29.
Name: "Homework"
Cell range C7:C29.
Name: "Homework"
Answer: Use the following steps to complete this task in explanation:
Question #15 (Topic: Topic 1)
Formula.
Find the minimum homework score for each student.
Cell range D7:D29
Number 1: minimum homework score for each student on "Section 3" worksheet.
Find the minimum homework score for each student.
Cell range D7:D29
Number 1: minimum homework score for each student on "Section 3" worksheet.
Answer: Answer:
