Tutor profile: Bradley F.
Subject: Microsoft Excel
You have a listing of sales agents, with each column representing the months of the year and their total sales by month. You want to identify the sales for the month of March, April, and July, for 3 sales agent, Mark, Tom, and Sarah. How would you quickly pull the data?
Using a vlookup function, you can identify the sales by agent. You'd identify the sales' agent name as the lookup value, then reference the table where the sales by month is included, and then for each formula use the column number for each month to quickly extract the sales amounts for each of these sales agents for the specified months.
Subject: Personal Finance
What is the time value of money?
The time value of money considers the value of taking a sum of money now, as compared to taking an identical sum of money later.
What is gross margin?
Gross margin is a calculation of the margin retained after taking out the direct cost to produce the goods sold.
needs and Bradley will reply soon.