This preview shows pages 1–2. Sign up to view the full content.
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
This preview has intentionally blurred sections. Sign up to view the full version.
View Full Document
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.
 Spring '08
 Strickland

Click to edit the document details