This preview shows pages 1–3. Sign up to view the full content.
EAS102
MIDTERM EXAM
SPRING 2005
NAME._____________________________
Read each problem carefully.
Show all your work.
1.
(10 points) For the following give an appropriate answer
a.
3.41 m+5.430m =
b.
(2.3x10
5
) 3.54(6.14x10
6
)=
c.
200.00/3.00=
d.
Convert 2002 mph (miles per hour) to feet/min. [5280 ft= 1 mile]
2.
(15 points)
Give the answers to the following excel formula statements.
a.
=10/2*3+2
b.
=if(A1>B1, A1/B1, B1/A1), where A1=2, B1=row()
c.
=average(10,11,12)
d.
The formula in cell B1 is =$A$1+A1 where A1=1.
This formula is dragged to
fill multiple rows and cells.
What is the value in cell C1?
This preview has intentionally blurred sections. Sign up to view the full version.
View Full Document3.
(25 points) Say you are given the task to create an Excel spreadsheet that would
simulate the roll of a pair of dice.
The chance of getting a 1, 2, 3, 4, 5, or 6 with one
die is the same.
A user would “roll” the dice by carrying out some requested step.
Then the roll of die 1 and die 2 would be shown in two different cells.
You want the
sheet to look like the following:
A
B
C
1
Roll the die by
……
2
Die 1
Die 2
Sum of dice
3
3
6
9
4
5
a.
Decide on a trigger mechanism and finish the sentence in cell A1.
b.
Decide on a way to do simulate the roll of the dice.
Write formula(s) for cells A3
and/or A4, A5 … that can be used to produce the number resulting from the roll of
the die 1 in cell A3.
Write the formula(s) so that it/they can be easily dragged to
This is the end of the preview. Sign up
to
access the rest of the document.
 Spring '09
 Coffin

Click to edit the document details