Tutor profile: Vicki G.
Subject: Microsoft Excel
What is a vlookup and how do you use it?
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.
Proportions: Solve for X. (15/75) = (X/225)
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
What are Financial Statements and what do they tell us about a company?
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.
needs and Vicki will reply soon.