Excel for Marketing Managers

Homework Checker

Homework
Checker

Note that these formulas only work if cell C3 contains a three-digit number.

1. Enter the following formula in cell C4: =C2*RIGHT(C3,1)
   This formula multiplies 789 by the rightmost digit in C3.


2. Enter the following formula in cell C5: =C2 MID(C3,2,1)10
   This formula uses the MID function. MID(C3,2,1) starts at the second posi-
   tion in C3 for a length of one character. This will multiply the 5 in 654 by
   789. You have to multiply this result by 10 to properly line up the answer
   with C5.


3. Enter the following formula in cell C6: =C2LEFT(C3,1)100
   This formula uses the LEFT function to take the first character from the
   left of the 654. It multiplies the 6 in 684 by 789 and then multiplies that
   product by 100.


4. Enter the following formula in cell C7: =SUM(C4:C6)
   This formula sums the results of the formulas in C4 through C6.

The trick will be to make sure that your students complete the work first

before they use the homework checker! This last version has the added

benefit of letting them figure out where they went wrong.

The homework checker can be adapted to check addition, subtraction, and

various other problems.