MAT 144 Grand Canyon University Mathematics Question

Description

Complete Technology Assignment 1 in Lesson 2-5 in the textbook. Use the template that is provided in the online resources this lesson. The hin3 postsUSE THE TEMPLATE ATTACHED TO THIS POST RATHER THAN THE TEMPLATE IN ALEKS. THE TEMPLATE INCLUDES INSTRUCTIONS FOR COMPLETING THE DQ.For this DQ, you’ll complete a modified version of Technology Assignment 1 in Lesson 2-5 of the textbook in ALEKS, for which you’ll look at percentage (exponential) versus linear decreases in account balances.Download the attached template (“QR 2-5 Tech Template MODIFIED.xlsx”) and follow the instructions in the text box to complete the Excel. In this case, the ALEKS videos may not provide that much help.Here is a video I made to help: https://youtu.be/lhnwJCrnMGUt is provided in the video called “Tech Hints QR 2-5.

2 attachmentsSlide 1 of 2attachment_1attachment_1attachment_2attachment_2

Unformatted Attachment Preview

Months
2% decrease per $20 decrease per
month
month
0
Enter your name Enter your name
in cell F4
in cell F4
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
First month at or
below $1,000.00 in
column B
First month at or
below $20.00 in
column C
Your name:
Follow these instructions:
1. Enter your name in cell F4.
2. Write a formula in cell B3 that reduces the amount in cell B2 by 2%
Then use the fill-down feature to complete column B until the balanc
$1,000.00.
3. In cell C3, write a formula that reduces the balance in C2 by $20.00
feature again to complete column C until the balance drops to at or b
4. In cell E2, enter the number of months at which the value in colum
$1,000.00. In cell F2, enter the number of months at which the value
below $20.00. In cell G2, enter the final balance at or below $20.00.
5. Format cells E2 and F2 as Number with 0 decimal places and cell G
decimal places.
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
Final payment in
column C
ces the amount in cell B2 by 2%.
plete column B until the balance drops to at or below
ces the balance in C2 by $20.00. Now use the fill-down
ntil the balance drops to at or below $20.00.
ths at which the value in column B is first at or below
er of months at which the value in column C is first at or
nal balance at or below $20.00.
with 0 decimal places and cell G2 as Currency with 2
9:07 9
АА
A studypool.com
First month at or below First month at or below
$1,000.00 in column B $20.00 in column C
Final payment in
column C
Your name:

Purchase answer to see full
attachment

Tags:
technology

mathematics

Final balance

format cell G2

decrease per month

User generated content is uploaded by users for the purposes of learning and should be used following Studypool’s honor code & terms of service.