Massive Summer Special Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: netdisc

Microsoft 77-420 Excel 2013 Exam Practice Test

Demo: 4 questions
Total 30 questions

Excel 2013 Questions and Answers

Question 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"

Options:

Question 2

Formula.

Find the maximum homework score for each student.

Cell range E7:E29

Use Function MAX

Number 1: maximum homework score for each student on "Section 3" worksheet.

Options:

Question 3

Create a chart.

To the right of the data

Chart 3-D Clustered Column

Exclude all filtered rows

Horizontal Axis Labels: "IDs" column in table

Series 1: "Zero Scores" column in table.

Options:

Question 4

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

Options:

Demo: 4 questions
Total 30 questions