EAS102 MIDTERM EXAM SPRING 2005

EAS102 MIDTERM EXAM SPRING 2005 - EAS102 MIDTERM EXAM...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
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?
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
3. (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
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 6

EAS102 MIDTERM EXAM SPRING 2005 - EAS102 MIDTERM EXAM...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online