TutorMe homepage

SIGN IN

Start Free Trial

Vicki G.

IT Financial Analyst Lead at Boeing

Tutor Satisfaction Guarantee

Microsoft Excel

TutorMe

Question:

What is a vlookup and how do you use it?

Vicki G.

Answer:

The vlookup is to look for a value (numbers or text) in a column. Once it finds a match, the vlookup will return that value from a cell in the same row as the match. For example, you have two separate tables on two separate tabs of an excel workbook that contain at least one column of matching data. On the second tab (with the second table) say you want to pull values from a specific column on the first tab/table. What you can do is this, in the last column of tab 2 add a vlookup formula =vlookup (lookup_value, table_array, col_index_num, [range_lookup]) Basically this means the following: lookup_value is what you are trying to find or match to - this is usually referencing a specific cell table_array is where we are telling the vlookup to look for that value - this is usually a range of columns and the vlookup will look for a match in the first column within the range. col_index_num is which column in the table_array we want the vlookup to pull from once it finds its match - this is usually a number like "4" which tells the vlookup we want to pull the value from the 4th column of the table_array (search range) range_lookup is the closest match argument. Here you'll enter either "True" or "False". True will bring back results with an approximate match if there is no exact match. False will only bring back results with an exact match. You will drag this formula down for each row on tab 2 that you want to do this same lookup function for.

Pre-Algebra

TutorMe

Question:

Proportions: Solve for X. (15/75) = (X/225)

Vicki G.

Answer:

This math problem is a proportions calculation. This means we are solving for X, and X should make up proportionally the same percentage of 225 as 15 does of 75. There are multiple ways we can solve for X. First method: Isolate X by multiplying both sides of the equation by 225. So in step by step form, it'll look like this: (15/75) * (225/1) = (X/225) *(225/1), on the right side the 225s cancel each other out and cleaned up more is as follows (15*225)/75 = X, 3,375/75 = X, 45 = X Second method: find the percentage of 15 out of 75 and apply that percentage to 225 to get X: 15/75 = 0.2 or 20% 0.2 * 225 = 45 = X

Finance

TutorMe

Question:

What are Financial Statements and what do they tell us about a company?

Vicki G.

Answer:

Financial Statements tell us what a company’s financial position and performance is and has been, over a period of time. They provide us with detailed financial information about the company that existing and potential investors, creditors and lenders find useful when making decisions that involve whether they should invest in some way or not. There are three statements in the financial packet: Income Statement, Balance Sheet, and Cash Flow Statement The Income Statement shows the performance of the company over their accounting period, and displayed in the terms of revenues and expenses that are generated through operating and non-operating activities. The Balance Sheet shows the position of the company at a specific point in time, and displayed in the terms of assets, liabilities, and owner's equity. The Cash Flow Statement shows the cash inflow and outflow and how current year has changed from previous year.

Send a message explaining your

needs and Vicki will reply soon.

needs and Vicki will reply soon.

Contact Vicki

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.

Made in California

© 2019 TutorMe.com, Inc.