From the course: Excel Power User Challenge

Unlock this course with a free trial

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

Which room is bigger?

Which room is bigger? - Microsoft Excel Tutorial

From the course: Excel Power User Challenge

Start my 1-month free trial Buy for my team

Which room is bigger?

“

- [Instructor] Well, well, well. We have these numbers telling us how big each room is. Room number D is nine feet by eight and a half feet. Hmm. But how does nine by eight and a half compare to 13 and 1/4 by 9 and 1/3? Don't know. That's the goal here. Figure out how big each room is in square feet and then use conditional formatting to highlight the two largest rooms. Time to pause the video, work on a solution, come back and I will show you which two rooms are the largest. (upbeat music) Let's get started. My cursor is in the dataset and I'm going to put this into a table. I'm in the Home tab of the ribbon, go to Format As Table. Let's grab the black header. Table does have headers, yes. I'm going to get rid of the filter button. Okay, and watch. Total. Enter. Good. Now, we've got to deal with how these numbers are connected with that X in the middle. Here's what I'm going to do. Equals…

Contents