Subjects
PRICING
COURSES
SIGN IN
Start Free Trial
Sean B.
Performance Analyst at a Digital Marketing Company
Tutor Satisfaction Guarantee
Microsoft Excel
TutorMe
Question:

How do you perform the VLOOKUP function in Microsoft Excel? Please provide an example.

Sean B.
Answer:

You start by clicking on the cell you want the return value to be entered. Then up top in the functions bar you type, "=VLOOKUP(" The first element you are going to add to the function is the value you want to look up. After that, add a comma and input the range where you want to lookup the value. Add another comma and put in the column number in the range containing the return value. Lastly, determine whether you want the function to look up only an Exact Match or an Approximate Match, you select this by indicating 0 or FALSE for an Exact Match and 1 or TRUE for an Approximate Match. Then once you close the parentheses and hit enter you have successfully performed the VLOOKUP function. A successful VLOOKUP function would look like this: =VLOOKUP(B4,GradeList,2,TRUE)

Personal Finance
TutorMe
Question:

What factors determine your credit score? Please include the percentage that each factor has on your credit score.

Sean B.
Answer:

Your credit score is determined based on the following factors: - 35% payment history - 30% amount owe and available credit - 15% length of credit history - 10% types of credit used - 10% new credit

Marketing
TutorMe
Question:

Explain the difference between Market Segmentation and Target Marketing?

Sean B.
Answer:

Target marketing is the term used for directing your marketing efforts toward a general group of people. You are evaluating each markets attractiveness and selecting 1 or more markets to enter. Market segmentation is dividing a market into distinct buyer groups, with different needs, characteristics and behaviors. It divides broad markets--such as gender, age, geographic location and income--into smaller segments in which people are grouped by shared characteristics.

Send a message explaining your
needs and Sean will reply soon.
Contact Sean
Ready now? Request a lesson.
Start Session
FAQs
What is a lesson?
A lesson is virtual lesson space on our platform where you and a tutor can communicate. You'll have the option to communicate using video/audio as well as text chat. You can also upload documents, edit papers in real time and use our cutting-edge virtual whiteboard.
How do I begin a lesson?
If the tutor is currently online, you can click the "Start Session" button above. If they are offline, you can always send them a message to schedule a lesson.
Who are TutorMe tutors?
Many of our tutors are current college students or recent graduates of top-tier universities like MIT, Harvard and USC. TutorMe has thousands of top-quality tutors available to work with you.