From the course: Excel Weekly Challenge

Unlock this course with a free trial

Join today to access over 22,600 courses taught by industry experts.

Apply a spin button

Apply a spin button - Microsoft Excel Tutorial

From the course: Excel Weekly Challenge

Start my 1-month free trial Buy for my team

Apply a spin button

“

- [Instructor] Let's take this slow, because the challenge is to add a spin button. Here we are comparing ten products. The criteria are ease of use, price, maintenance, features and then an overall score is being tallied, but that score is being weighted, and those weights are what we find in the importance role on a scale of one to ten, this user is saying that ease of use ranks a nine, which is highly important, whereas maintenance only gets a two, not so important. As things are right now, product H ranks the highest with a score of 91, but what if ease of use was not so important because we're experts, so let's drag that down. Making ease of use a two, now product B is the highest with a score of 69. Your help is needed because we only have three of the four spin buttons, so please add and configure a spin button for the features category. Link that button to cell F4 and have the minimum be zero, maximum ten.…

Contents