**CSC102B/MATH298B - Waiver
Test**

If you think that you do not need to take CSC102B or MAT298B as a
co-requisite with MAT116, then please read this page carefully. CSC102B/MATH298B covers features of Excel and Word
that are not normally covered in an introductory course. If
you can accomplish the following tasks (at least 8 out of 10) with little or no problem, then you are __probably__
okay to skip CSC102B. However, if you choose to do so, you take
full responsibility for knowing the material needed to complete the projects in 116/148. The instructors will not
be covering this stuff in 116 or 148, so your decision to skip CSC102B/298B is a significant one. Be aware that
starting in Fall 2009, 116 and 148 require permission to enroll. Part of this permission process is first enrilling
in CSC102B or MATH298B. Students who can demonstrated mastery of the following skills to the instructor (in person)
may (upon the sole discretion of the instructor) receive permission to enroll in 116 or 148 without enrilling in
CSC102B or MATH298B.

1.) Use the Equation Editor in Microsoft Word to type in the following equation into a Word document:

2.) Download the file called waiver.xls (use the right-mouse
button and choose "Save Target As..."). In the sheet called **S&P500** you will find a list of stock prices. Use this data and Excel's histogram
tool to create a histogram of this data. Your graph should include 10 bars. Don't know what a histogram is? Move
on the next question.

3.) In the file called waiver.xls, open the sheet called **Random**. In cell M1, enter a single Excel formula that will count the number of cells
that have numbers in them that are strictly greater than 0.85.

4.) In the file called waiver.xls, open the sheet called **Chrysler.
**Without sorting the data,
enter a single formula in cell H2 that will count the number of Pacifica's priced between $18,000 and $22,000 that
were sold by Juan.

5.) In the file called waiver.xls, open the sheet called **Graph.
**In the columns labeled x and y, use formulas to give a list
of x and y values that can be used to graph the function . Your graph and table should go from x = 1 to x = 10 and have 40 points of data on it.

6.) In the file called waiver.xls, open the sheet called **Measurement.
**There you will find a series of data that relates a person's
waist size to their height. Use this data to plot the points on a graph

7.) In the file called waiver.xls, open the sheet called **Measurement.
**There you will find a series of data that relates a person's
waist size to their height. Use this data to plot the points on a graph and then find the best-fitting linear trendline
that matches this data. Don't know what a trendline is? Move on the next question.

8.) In the file called waiver.xls, open the sheet called **Cars.
**This sheet contains data on hypothetical invoice numbers and
the amount of money per invoice. Without sorting the
data, enter a single formula in cell E2 that will automatically
report the corresponding amount of sales for any invoice number entered into cell D2.

9.) In the file called waiver.xls, open the sheet called **Random2.
**In cell B2, enter a single formula that will generate a random
integer between 12 and 20 if cell A2 is a 0, and a random number between 0 and 1 if cell A2 is not a 0.

10.) Use the pictures below to recreate the following file, including all equation, header and footer bars, bullet
items, and font styles. Click
here to view the file (required Adobe Acrobat Reader.)