Excel for Marketing Managers

Math Exercise Sheets

Math
Exercise
Sheets

This worksheet accepts 10 possible first numbers and 10 possible second

numbers. Formulas down column C and D build all possible pairs of these

numbers. The RAND function in A assigns random numbers to the 100 possible

problems. The RANK function in B finds the top 15 problems. Then,

VLOOKUP formulas in the printable area of the worksheet pull out the

numbers for the top 15 problems.

Figure 100 No Duplication worksheet