Computation Sol CBD - ARE YOU READY FOR CALCULUS FOR...

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

View Full Document Right Arrow Icon
ARE YOU READY FOR CALCULUS FOR BUSINESSS DECISIONS? This exercise uses some of the computer skills that you should have before beginning Calculus for Business Decisions . Follow the directions, using the most efficient methods carry out each step . When you are done, return to What Computer Skills Will You Need? in CBD.pptm for information on how to evaluate your results and techniques. PART 1 (i) Save this file as Computation.xlsx and continue saving all of the work that you do workbook (ii) This workbook is now set for Manual Calculation . Reset it for Automatic Calculation . PART 2 Let f ( x ) = ax2 + b where a is the number in Cell B51 . You are to make an array of va for f ( x ), computed for different values of x and b . (i) Merge Cells B48:J48 and format the merged cell with light grey fill and a black bo Enter the formula f ( x ) = ax 2 + b in the merged cell as bold face text . Be sure that italics and superscript are exactly as shown in this sentence. (ii) Enter -0.5 in Cell D51 and -0.4 in Cell D52 . Drag these down to display the numb -0.5, -0.4, -0.3, -0.2, -0.1, 0, 0.1, 0.2, 0.3, 0.4, and 0.5 in Cells D51:D61 . (iii) Enter a formula in Cell E51 that will compute the value of f ( x ) = ax 2 + b for the v of a in Cell B51 , the value of x in Cell D51 , and the value of b in Cell E50 . Absolute and re cell addresses must be made so that the value used for a does not change when Cell E51 is dragged in any direction, the value used for x changes only when the cell is dragged vertical and the value used for b changes only when the cell is dragged horizontally. (iv) Drag Cell E51 to the right to fill Cells E51:J51 , then drag Cells E51:J51 , as a gro down to fill Cells B51:J61 . (v) Enter the value 3.2 in Cell B51 and recalculate the sheet to generate new values in E51:J61 . (vi) Use
Background image of page 1

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

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 10/27/2010 for the course ECE 220 taught by Professor Strickland during the Spring '08 term at University of Arizona- Tucson.

Page1 / 28

Computation Sol CBD - ARE YOU READY FOR CALCULUS FOR...

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

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