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.

Calculate your out-of-pocket expense

Calculate your out-of-pocket expense - Microsoft Excel Tutorial

From the course: Excel Weekly Challenge

Start my 1-month free trial Buy for my team

Calculate your out-of-pocket expense

“

- [Instructor] You really got to put your thinking cap on for this one, so if you don't have it you might want to pause the video and go get it, okay? Okay. You're back. Ooh, look at that thinking cap you got on now. All right. You are interested in a digital mixer. It costs $1,930 and you want a microphone and the max you want to pay for that microphone is $275. And you are part of a program that gives you a pretty good discount. And in the first three rows of this worksheet, you can see the retail price of various items and the price that you paid. You bought that camera lens for $375 and paid $166.50. Based on that data, get some idea about how much you would pay for that digital mixer. And when you go looking for the microphone, approximately what price range should you be looking at given that you only want to pay up to 275. And I say approximate because you're not going to get this down to the penny. So, get get…

Contents