From the course: Excel Weekly Challenge

Unlock this course with a free trial

Join today to access over 24,700 courses taught by industry experts.

Determine the new player lineup

Determine the new player lineup - Microsoft Excel Tutorial

From the course: Excel Weekly Challenge

Start my 1-month free trial Buy for my team

Determine the new player lineup

“

- [Narrator] The Choppers just competed against the Roosters, and going into their next competition, the Choppers want to make some changes in their lineup, and that's where your help is needed. They've decided they want their strongest player in round 10, the second strongest player in round 9, and the third strongest player in round 1. How do you calculate this? Add up all four points. So for Bernard, let's look at this. I'm going to highlight here. Bernard gets 36. However, where a person scored 15, they get an additional 3 points for each 15. So let's look at Amy. Amy scores 33, but because she has a 15, she gets an additional 3 for her total to be 36. All right? So now is that time where you pause the video. Figure out how to change this lineup for the first player and the last two players. All right? Now it's your turn. (upbeat music) Let's add this up and see what's what. Go here and do this first,…

Contents