Comp Solution 1 Alt - ARE YOU READY FOR PART 1 OF MATHEMATICS FOR BUSEINSSS DECISIONS Here is an exercise that uses some of the basic computer

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

View Full Document Right Arrow Icon
a b n a b n x 3.71 5.24 3 3.71 5.24 3 0 0.1 ARE YOU READY FOR PART 1 OF MATHEMATICS FOR BUSEINSSS DECISI Here is an exercise that uses some of the basic computer skills which yo you start Part 1 of Mathematics for Business Decisions . Follow the direction most efficient methods to carry out each step . When you are done, return to Computer Skills Will You Need? in MBD Part 1.ppt . for information on how t your results and techniques. Let f ( x ) = ax n + bx where a is the number in Cell B43 , b is the number in and n is the integer in Cell D43 of this sheet. You are to find the values of f ( x numbers x ranging form 0 to 100, in tenths. These are given by x = 0, 0.1, 0.2 This is to be done in such a way that the values of the function will be recomp automatically whenever the values of a , b , and n are changed in Columns B, C DIRECTIONS 1. Enter the labels a , b , n , x , and f ( x ) in Cells F42 , G42 , H42 , J42 , and respectively. Format the text in italics. Define Cells F43 , G43 , and H43 to b Cells B43 , C43 , and D43 , respectively. Format Cells F42:K42 and F43:H43 entries are centered in the cells. 2. Enter 0 in Cell J43 and 0.1 in Cell J44 . Drag these cells down to au enter the numbers 0, 0.1, 0.2, 0.3, . .. , 100 in Cells J43:J1043 . 3. Enter a formula for f (0) in Cell K43 , using a relative cell address for absolute cell addresses in Columns F, G, and H for the values of a , b , and n . will begin with the expression =$F$43*J43^$H$43, and then continue as need formula down to automatically fill Cells K43:K1043 . Format Columns F , G , with width 5, and Column K with width 16. Format the entries in Cells K43:K numbers with 4 decimal places displayed. 4. Enter 3.71, 5.24, and 3 in Cells B43 , C43 , and D43 , respectively. Re entire sheet, so that the values of f ( x ) are changed. 5. Place borders around all cells in the block F42:K53 . Use Copy and P the entire block of cells into the Word document Report 1.doc , as a table. Sav Computation 1.xls . Go to the file Report 1.doc and follow the directions that there.
Background image of page 1

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

View Full DocumentRight Arrow Icon
0.2 0.3 0.4 0.5 0.6 0.7 0.8 0.9 1 1.1 1.2 1.3 1.4 1.5 1.6 1.7 1.8 1.9 2 2.1 2.2 2.3 2.4 2.5 2.6 2.7 2.8 2.9 3 3.1 3.2 3.3 3.4 3.5 3.6 3.7 3.8 3.9 4 4.1 4.2 4.3 4.4 4.5 Point 1 . Cell F43 must be defined in terms of Cell B43 , not copied or typed in. The same applies to Cells G43 and H43 . Point 2 . All formatting of fonts, alignment, column width, and numbers must be as specified. Point 3 . The numbers in Column J must have been entered by dragging down the first few cells, not by typing individual numbers. Point 4 . The formulas in Column K must have been entered with absolute addresses ($'s) for the constants and relative addresses for the variable. Point
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.

This note was uploaded on 04/02/2008 for the course MATH 115a taught by Professor Ekstrom during the Spring '08 term at University of Arizona- Tucson.

Page1 / 48

Comp Solution 1 Alt - ARE YOU READY FOR PART 1 OF MATHEMATICS FOR BUSEINSSS DECISIONS Here is an exercise that uses some of the basic computer

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