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

Algebra & Trigonometry with Analytic Geometry
13th Edition
ISBN:9781133382119
Author:Swokowski
Publisher:Swokowski
Chapter5: Inverse, Exponential, And Logarithmic Functions
Section5.3: The Natural Exponential Function
Problem 51E
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
Recommended textbooks for you
Algebra & Trigonometry with Analytic Geometry
Algebra & Trigonometry with Analytic Geometry
Algebra
ISBN:
9781133382119
Author:
Swokowski
Publisher:
Cengage
Glencoe Algebra 1, Student Edition, 9780079039897…
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill
Elementary Linear Algebra (MindTap Course List)
Elementary Linear Algebra (MindTap Course List)
Algebra
ISBN:
9781305658004
Author:
Ron Larson
Publisher:
Cengage Learning
College Algebra
College Algebra
Algebra
ISBN:
9781938168383
Author:
Jay Abramson
Publisher:
OpenStax
Big Ideas Math A Bridge To Success Algebra 1: Stu…
Big Ideas Math A Bridge To Success Algebra 1: Stu…
Algebra
ISBN:
9781680331141
Author:
HOUGHTON MIFFLIN HARCOURT
Publisher:
Houghton Mifflin Harcourt