Tutor profile: Ethan T.
Subject: Microsoft Excel
If you have two different tables with a matching column, what function(s) could you use to quickly pull data from one table to another?
There are two answers: the VLOOKUP function and the combination of the INDEX and MATCH functions. The VLOOKUP function is ideal for situations when the matching column is the far left column in the table you are retrieving data from. The INDEX/MATCH combo is ideal for situations when the matching column is not the far left column in the table you are retrieving data from.
Subject: Professional Development
During a job interview, how should the interviewee structure their answers to behavioral questions?
I would recommend the time-tested STAR method: Situation, Task, Action, Result. Explain the situation you were in, clearly state the task at hand, thoroughly describe your actions to complete the task, and reflect on the results after completion of the task.
Would an increase in a company's liabilities lead to an increase or decrease in the company's assets?
It would lead to an increase in the company's assets. For example, if a company takes out a loan for $5,000, they are simultaneously incurring a liability and increasing their cash (asset).
needs and Ethan will reply soon.