Skills CBD - ARE YOU READY FOR CALCULUS FOR BUSINESSS...

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
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

Skills CBD - ARE YOU READY FOR CALCULUS FOR BUSINESSS...

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