Subjects
PRICING
COURSES
SIGN IN
Start Free Trial
Lindsey C.
Information Technology Major at Virginia Tech
Tutor Satisfaction Guarantee
Microsoft Excel
TutorMe
Question:

What function would one use to vertically look up data in a big data spreadsheet if both data sets have a matching component?

Lindsey C.
Answer:

Vlookup. This formula find a portion of the data that one is looking for by matching it to that piece of data in the other sheet. It may then output a separate column. Hlookup is similar, but is oriented for horizontal searching.

Linear Programming
TutorMe
Question:

How would you set up the following LP problem? A company sells two types of chairs, stained and unstained. The stained chairs require 4 units of wood and the unstained require 2. The stained chairs also require an extra hour of preparation where the unstained need only 1. Stained are sold for $50 and unstained $33.The company has 500 units of wood availiable and 1200 hrs to work on the chairs. Set up the problem

Lindsey C.
Answer:

Stained = x1, Unstained = x2 Objective Function: 50x1 + 33x2 Decision Variables: Amount of stained to make, Amount of Unstained to Make Constraints: x1 * 4 + x2 * 2 <= 500 units Wood Constraint x1 * 2 + x2 <= 1200 hrs Time Constraint x1, x2 >= 0 Can not make negative chairs

Java Programming
TutorMe
Question:

How would you reverse a String?

Lindsey C.
Answer:

An efficient way to reverse a String is to do so recursively. I would make a class using string.length() and string.substring() to continually narrow the string and the base case, or the way the code would stop performing the reverse, would be when the length of the string equals 1. At each occurrence of the class an empty string would have the new letter from the end of the old string concatenated to it. Also if the length equals one the string is already reversed technically.

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