A function is given as: f(x) = e(²-2) Enter the correct Excel formula for reproducing the results in Cell C4 using absolute referencing in your solution. 1 2 3 4 S A A 1 2 Income 3 4 5 X Expenses Enter the correct Excel formula for cell H12 to reproduce the output in the spreadsheet below: B Rent Phone Car Food Leisure e(x-2) 1.5 0.606531 B Jan 1,100 380 40 95 80 80 C 6 7 8 9 10 Total Expenses 675 11 12 Balance 425 C Feb 1,100 380 38 110 85 90 703 397 D Mar 1,100 380 37 105 90 85 697 403 E Apr 1,100 380 36 100 94 70 680 420 F May 1,100 380 41 90 90 85 686 414 G Jun 1,100 380 39 115 88 75 697 403 H Total 6,600 2,280 231 615 527 485 4,138 2,462

Advanced Engineering Mathematics
10th Edition
ISBN:9780470458365
Author:Erwin Kreyszig
Publisher:Erwin Kreyszig
Chapter2: Second-order Linear Odes
Section: Chapter Questions
Problem 1RQ
icon
Related questions
Question
please answer both thank you
A function is given as:
f(x) = e(x-2)
Enter the correct Excel formula for reproducing the results in Cell C4 using absolute referencing in your
solution.
1
2
3
4
5
A
6
1
2 Income
3 Expenses
4
78
A
X
Enter the correct Excel formula for cell H12 to reproduce the output in the spreadsheet below:
B
Rent
Phone
Car
Food
Leisure
e(x-2)
1.5 0.606531
B
Jan
1,100
380
40
95
80
80
C
9
10 Total Expenses 675
11
12 Balance
425
C
Feb
1,100
380
38
110
85
90
703
397
D
Mar
1,100
380
37
105
90
85
697
403
E
Apr
1,100
380
36
100
94
70
680
420
F
May
1,100
380
41
90
90
85
686
414
G
Jun
1,100
380
39
115
88
75
697
403
H
Total
6,600
2,280
231
615
527
485
4,138
2,462
Transcribed Image Text:please answer both thank you A function is given as: f(x) = e(x-2) Enter the correct Excel formula for reproducing the results in Cell C4 using absolute referencing in your solution. 1 2 3 4 5 A 6 1 2 Income 3 Expenses 4 78 A X Enter the correct Excel formula for cell H12 to reproduce the output in the spreadsheet below: B Rent Phone Car Food Leisure e(x-2) 1.5 0.606531 B Jan 1,100 380 40 95 80 80 C 9 10 Total Expenses 675 11 12 Balance 425 C Feb 1,100 380 38 110 85 90 703 397 D Mar 1,100 380 37 105 90 85 697 403 E Apr 1,100 380 36 100 94 70 680 420 F May 1,100 380 41 90 90 85 686 414 G Jun 1,100 380 39 115 88 75 697 403 H Total 6,600 2,280 231 615 527 485 4,138 2,462
Expert Solution
steps

Step by step

Solved in 2 steps with 2 images

Blurred answer
Similar questions
Recommended textbooks for you
Advanced Engineering Mathematics
Advanced Engineering Mathematics
Advanced Math
ISBN:
9780470458365
Author:
Erwin Kreyszig
Publisher:
Wiley, John & Sons, Incorporated
Numerical Methods for Engineers
Numerical Methods for Engineers
Advanced Math
ISBN:
9780073397924
Author:
Steven C. Chapra Dr., Raymond P. Canale
Publisher:
McGraw-Hill Education
Introductory Mathematics for Engineering Applicat…
Introductory Mathematics for Engineering Applicat…
Advanced Math
ISBN:
9781118141809
Author:
Nathan Klingbeil
Publisher:
WILEY
Mathematics For Machine Technology
Mathematics For Machine Technology
Advanced Math
ISBN:
9781337798310
Author:
Peterson, John.
Publisher:
Cengage Learning,
Basic Technical Mathematics
Basic Technical Mathematics
Advanced Math
ISBN:
9780134437705
Author:
Washington
Publisher:
PEARSON
Topology
Topology
Advanced Math
ISBN:
9780134689517
Author:
Munkres, James R.
Publisher:
Pearson,