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.

Insert a happy or sad face

Insert a happy or sad face - Microsoft Excel Tutorial

From the course: Excel Weekly Challenge

Start my 1-month free trial Buy for my team

Insert a happy or sad face

“

in another spreadsheet and now they're asking us to do it for them. This person would like to have a happy face show up in the Yes/No column wherever the score is greater than the score in F1. And if not, then put a sad face. In OneNote, you're going to have to use the Wingdings font for this. And then finally, we want to have two decimal places for everything in the score column. All right, when you're ready, pause the video, get the exercise file, and start compiling those happy faces. When you're ready, come on back and we'll go through the solution. Let's handle these decimal places. Let's highlight this column. And then we're going to use increased decimal places and then decrease it. So now everything does have two decimal places. Now the Yes/No. First of all, we've got to find out about the world of Wingdings because there is no happy face key on the keyboard. So let's go over here. Going to go to…

Contents