Do You Need Excel Training?
slajs da sdka skda sdka sdk a
Quiz Summary
0 of 10 questions completed
Questions:
Information
You have already completed the quiz before. Hence you can not start it again.
Quiz is loading…
You must sign in or sign up to start the quiz.
You must first complete the following:
Results
Results
Your time:
Time has elapsed
You have reached 0 of 0 point(s), (0)
Earned Point(s): 0 of 0, (0)
0 Essay(s) Pending (Possible Point(s): 0)
Categories
 Not categorized 0%
 1
 2
 3
 4
 5
 6
 7
 8
 9
 10
 Current
 Review
 Answered
 Correct
 Incorrect

Question 1 of 10
1. Question
1 point(s)What is the Total (Sum) of the Runs per Over

Question 2 of 10
2. Question
1 point(s)What is the average of Boundaries

Question 3 of 10
3. Question
1 point(s)Using Tab 2 – What is the maximum number of dot balls in the data set.

Question 4 of 10
4. Question
1 point(s)Copy and paste the formula used to find the max number of boundaries.

Question 5 of 10
5. Question
1 point(s)Using the Sumif formula. How many goals did we score when the opposition was Wasps?

Question 6 of 10
6. Question
1 point(s)How many goals did we score when the opponent was Bulldogs

Question 7 of 10
7. Question
2 point(s)The Sum of all goals scored this season is 71. But using the Sumif formula what is the sum of goals in the games we won.

Question 8 of 10
8. Question
4 point(s)How many goals did we score in games we won in 2016.

Question 9 of 10
9. Question
1 point(s)The manager would like to know; how many games did we Win and score over 75 points in our rating and have a pass % above 80. What item is missing from the following formula.
=COUNTIFS(E5:E54,”Win”,F5:F54,”>75″,H5:H54,

Question 10 of 10
10. Question
2 point(s)Rank the batsmen in descending order. Which batsman is 12th.