TutorMe homepage
Subjects
PRICING
COURSES
SIGN IN
Start Free Trial
Nate P.
Accounting, Finance and Real Estate Student
Tutor Satisfaction Guarantee
Microsoft Excel
TutorMe
Question:

When would I use an Index/Match function rather than vlookup?

Nate P.
Answer:

The Index/Match function is the preferred way to look up a value in excel given it requires far less processing capability than vlookup. While vlookup uses the entire table array, index/match only considers the two columns you are both referencing and searching. This provides index/match users with a more versatile equation as the lookup function is not pertaining to a table at a whole and not compromised if for example, a column in the table must be deleted.

Pre-Calculus
TutorMe
Question:

What is the domain and range of y=x^2-7?

Nate P.
Answer:

First, let's start with the domain. The domain is defined as all x values which will yield a real y value. Since this is a quadratic function, x is being squared you must ask yourself, are there any values which if squared, will not produce a real number? Since the answer is no, the domain is (-∞,∞). Second, the range is defined as all possible values of y given the function of x. Since this is a quadratic equation, you must ask yourself, are there any values that x^2 cannot produce? Whether it be by looking at a graph, or simple guess and check, you will find that x^2 can never yield a negative number. Therefore, since the y intercept is -7, this will be the lowest possible y value, while the function will only continue to increase as the absolute value of x increases. Therefore the range is [-7,∞)

Algebra
TutorMe
Question:

How do I find the y intercept of an equation?

Nate P.
Answer:

Well if you picture a graph, the y-intercept is the value of y when the graph crosses the y axis. Further, the y axis represents x=0. So for example, lets say the given equation is y=5x^2+4. If we plug in 0 for x, we are left with 5(0)^2+4, which equals 4. Since y=4 when x=0, the y intercept is 4.

Send a message explaining your
needs and Nate will reply soon.
Contact Nate
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.