TutorMe homepage
Subjects
PRICING
COURSES
Start Free Trial
Zeba H.
Strategy and Analytics Consultant
Tutor Satisfaction Guarantee
Microsoft Suite
TutorMe
Question:

I have a watermark in my PowerPoint slides from a previous project that I need to get rid of. i can't click it and delete it on any of my slides. How can I get rid of this?

Zeba H.

This is definitely an annoying problem I've had in the past, and I spent way too long attempting to figure it out without researching or reaching out to others, so I'm glad you came to me. In PowerPoint, if you go to the tab 'View' on the ribbon and click 'Slide Master', you'll see a batch of template slides that pop up. This is where the actual background of your slides as a template are determined. You will be able to see your watermark that is posing an issue to you in this view and also click/delete that watermark. Once you do that, you can click back to Normal view and that watermark will be gone.

Microsoft Excel
TutorMe
Question:

I'm trying to find all instances of "banana" in my database of grocery sales and sum the number of bananas we have in stock from another column.

Zeba H.

To sum the inventory of bananas from let's say Column B, with Column A having the product name in it, we can do a simple SumIf function. To perform a SumIf function, we'll need to follow this syntax. =SUMIF(range, criteria, sum_range). So for this situation, our range will be Column A since that is where our product name (ie banana) is. Our criteria will be "banana" (you need to keep it in quotes since that is text you are searching for). Our sum_range will be Column B since that is where the inventory amount is. =SUMIF(\$A:\$A,"banana",\$B:\$B). The \$ signs lock the column name so that there is no shifting around and improper calculations done.

Pre-Algebra
TutorMe
Question:

5(-3x - 2) - (x - 3) = -4(4x + 5) + 13

Zeba H.

In order to solve this equation, we need to understand the order of operations here. If you can remember the acronym, PEMDAS, you'll pick this up quickly. PEMDAS stands for: Parenthesis, Exponents, Multiplication/Division, Addition/Subtraction. That's the order you'll want to perform all of the complicated looking calculations in this equation. Let's start with the left side of the equation. Using PEMDAS, we know that we have to pay attention to the Parenthesis first. So, on the left side of the equation we'll look inside the first parenthesis (-3x-2). Well, we can't really calculate anything there since it's a variable minus 2. Let's see if we can do anything with the next parenthesis (x-3). Nope, doesn't look like we can. So let's move onto the E in PEMDAS, exponents. Doesn't look like we have any exponents here. So let's continue to the M/D in PEMDAS, Multiplication and Division. Now this is where we start having some work to do. Using the distributive property, we know that we multiply the outside number by the numbers inside the parenthesis. Starting from the left we'll multiply 5 by -3x = -15x. Then we'll multiply 5 by -2 = -10. So on the left side of the equation, we're left with -15x-10. Now, let's do the same thing on the right side of the equation. -4 x 4x = -16x and -4 x 5 = -20. So on the right side we have -16x - 20 + 13. Well, we can combine the -20 and +13 since they're both integers. So, on the right side we're left with -16x - 7. On the left side we have -15x - 10. It's easier to see what needs to be done next if you write out the new and improved equation. We now have: -15x - 10 = -16x - 7 . Now we can do some combining. We need to put all of our 'x' on one side and the integers on another side. Let's move -16x from the right to the left by adding 16x to both sides. We now have 1x - 10 = -7. Now, let's move the -10 from the left side to the right side by adding 10 to both sides. We now have 1x = 3 --> x =3. And there's your solution.

Send a message explaining your
needs and Zeba will reply soon.
Contact Zeba