Excel for Marketing Managers

Math Exercise Sheets

Math
Exercise
Sheets

2. From the Tools menu, select Add-Ins. When the dialog box opens, click on
   the boxes next to Analysis ToolPak and Analysis ToolPak – VBA. Click OK
   to exit.

Once you have enabled the Analysis ToolPak, you will be able to use any of

the 150 extra functions on that computer.

Basic Math Facts: Adding Two Terms with an Answer Under 10................................

Say that you want to create a worksheet of addition problems. You want the

problems to appear in a large font so that your first graders will have space to

write the answer. You would like perhaps 15 different problems on the paper.

You will use the RANDBETWEEN function. To use this function, specify two

numbers as arguments in the function and separate the two arguments with a

comma. For example, =RANDBETWEEN(1,20) would return a random whole

number between 1 and 20, inclusive.

1. Enter the following formula in cell B2: =RANDBETWEEN(1,8)


2. In cell B3, you want to find a random number such that the answer will not
   exceed 9 – actually, a random number between 0 and (9-B2). Luckily, either

Figure 83

Finding a random number from 1-8

Figure 82

Selecting Analysis ToolPak

from the Add-Ins list