Define names for the cells in the range D5:D7 based on the values in the range C5:C7.

New Perspectives on HTML5, CSS3, and JavaScript
6th Edition
ISBN:9781305503922
Author:Patrick M. Carey
Publisher:Patrick M. Carey
Chapter7: Designing A Web Form: Creating A Survey Form
Section: Chapter Questions
Problem 4CP4
icon
Related questions
Question
  1. Define names for the cells in the range D5:D7 based on the values in the range C5:C7.
File
IF
12
13
14
15
16
17
18
19
20
21
22
23
24
AutoSave
Edit
Paste
Home Insert Page Layout
X Cut
Copy
Format Painter
Clipboard
Off H
A
Date
4
Item
5 Price
$
6 Down Payment $
7 Loan Amount
$
8
9
10
Rate
3.500%
3.650%
7.150%
10.800%
17.950%
28.750%
46.700%
75.450%
122.150%
197.600%
319.750%
N
X ✓ fx
B I U
Circular References: H4
B
▼ SC_EX16_CS4-7a_Raven MarieJones_1 ✓
Formulas Data Review View Automate
Α' Α΄
Font
=TotalLoan
11
$
с
G
12-Sep-18 Rate
Nordic Inn Term (Years)
876,000.00 Monthly Payment
197,200.00 Total Interest
678,800.00 Total Cost
✓
Accessibility: Investigate
A
==
==
D
Varying Interest Rate Schedule
Total Cost
Monthly Payment Total Interest
$
5, 106.47
240,363.85
4,852.62
194,672.08
4,902.78
203,700.06
429,696.26
694,633.47
1,284,482.97
2,290,387.62
4,081,126.55
6,158.31
7,630.19
$ 1,116,363.85
1,070,672.08
1,079,700.06
1,305,696.26
1,570,633.47
2,160,482.97
3,166,387.62
4,957,126.55
7,879,650.43
11,758,513.33 12,634,513.33
10,907.13
16,495.49
26,444.04
42,680.28
69,096.19
111,775.73
7,003,650.43
19,440,832.00 20,316,832.00
180,871.92
31,878,145.00 32,754, 145.00
4.250%
15
$
5,106.47
$ 240,363.85
$1,116,363.85
E
Documentation Inn Mortgage Highland Hotel Adela Condos
Alignment
F
Help
ab Wrap Text
Search
Merge & Center
G
Year
I $
2 $
3 $
4 $
5 $
6 $
7 $
8 $
9 $
10 $
||$
12 $
13 $
14 $
15 $
✓
H
Fy
Pinehill Lodge
Accounting
$ % 9
Beginning Balance
Number
Ending Balance
$ 645,732.21 $
645,732.21 $ 611,231.34 $
611,231.34 $ 575,235.28 $
575,235.28 $ 537,679.23 $
537,679.23 $ 498,495.59 $
498,495.59 $ 457,613.82 $
457,613.82 $ 414,960.33 $
414,960.33 $ 370,458.33 $
370,458.33 $ 324,027.71 $
324,027.71 $ 275,584.90 $
275,584.90 $ 225,042.69 $
225,042.69 $ 172,310.10 $
172,310.10 $ 117,292.19 $
117,292.19 $ 59,889.94 $
59,889.94 $
I
Subtotal
Down Payment
Total Cost
All Locations
Cabir
I
Conditional Format as Cell
Formatting ✓ Table Styles
Styles
J
Paid on Principal
(645,732.21) $
34,500.87 $ 26,776.72
35.996.06 $ 25,281.53
37,556.05 $ 23,721.54
39,183.64 $ 22,093.95
40,881.77 $ 20,395.82
42,653.49 $ 18,624.10
44,502.00 $ 16,775.59
46,430.61 $ 14,846.98
48,442.81 $ 12,834.78
50,542.21 $ 10,735.38
52,732.59 $ 8,545.00
55,017.90 $
6,259.69
57,402.26 $ 3,875.33
$ 61,277.59
(59,889.94) $ 645,732.21
=TotalLoan
$ 585,842.27
$
+
⠀
K
Interest Paid
←
—
Insert Delete Format
L
Cells
M
Marie Jones MJ
> AutoSum
✔Fill
✓Clear ✓
N
V
Editing
O
B
27
Sort & Find &
Filter Select ✓
Comments
T
P
O X
Analyze
Data
Analysis
Q
Share
R
▶
100%
Transcribed Image Text:File IF 12 13 14 15 16 17 18 19 20 21 22 23 24 AutoSave Edit Paste Home Insert Page Layout X Cut Copy Format Painter Clipboard Off H A Date 4 Item 5 Price $ 6 Down Payment $ 7 Loan Amount $ 8 9 10 Rate 3.500% 3.650% 7.150% 10.800% 17.950% 28.750% 46.700% 75.450% 122.150% 197.600% 319.750% N X ✓ fx B I U Circular References: H4 B ▼ SC_EX16_CS4-7a_Raven MarieJones_1 ✓ Formulas Data Review View Automate Α' Α΄ Font =TotalLoan 11 $ с G 12-Sep-18 Rate Nordic Inn Term (Years) 876,000.00 Monthly Payment 197,200.00 Total Interest 678,800.00 Total Cost ✓ Accessibility: Investigate A == == D Varying Interest Rate Schedule Total Cost Monthly Payment Total Interest $ 5, 106.47 240,363.85 4,852.62 194,672.08 4,902.78 203,700.06 429,696.26 694,633.47 1,284,482.97 2,290,387.62 4,081,126.55 6,158.31 7,630.19 $ 1,116,363.85 1,070,672.08 1,079,700.06 1,305,696.26 1,570,633.47 2,160,482.97 3,166,387.62 4,957,126.55 7,879,650.43 11,758,513.33 12,634,513.33 10,907.13 16,495.49 26,444.04 42,680.28 69,096.19 111,775.73 7,003,650.43 19,440,832.00 20,316,832.00 180,871.92 31,878,145.00 32,754, 145.00 4.250% 15 $ 5,106.47 $ 240,363.85 $1,116,363.85 E Documentation Inn Mortgage Highland Hotel Adela Condos Alignment F Help ab Wrap Text Search Merge & Center G Year I $ 2 $ 3 $ 4 $ 5 $ 6 $ 7 $ 8 $ 9 $ 10 $ ||$ 12 $ 13 $ 14 $ 15 $ ✓ H Fy Pinehill Lodge Accounting $ % 9 Beginning Balance Number Ending Balance $ 645,732.21 $ 645,732.21 $ 611,231.34 $ 611,231.34 $ 575,235.28 $ 575,235.28 $ 537,679.23 $ 537,679.23 $ 498,495.59 $ 498,495.59 $ 457,613.82 $ 457,613.82 $ 414,960.33 $ 414,960.33 $ 370,458.33 $ 370,458.33 $ 324,027.71 $ 324,027.71 $ 275,584.90 $ 275,584.90 $ 225,042.69 $ 225,042.69 $ 172,310.10 $ 172,310.10 $ 117,292.19 $ 117,292.19 $ 59,889.94 $ 59,889.94 $ I Subtotal Down Payment Total Cost All Locations Cabir I Conditional Format as Cell Formatting ✓ Table Styles Styles J Paid on Principal (645,732.21) $ 34,500.87 $ 26,776.72 35.996.06 $ 25,281.53 37,556.05 $ 23,721.54 39,183.64 $ 22,093.95 40,881.77 $ 20,395.82 42,653.49 $ 18,624.10 44,502.00 $ 16,775.59 46,430.61 $ 14,846.98 48,442.81 $ 12,834.78 50,542.21 $ 10,735.38 52,732.59 $ 8,545.00 55,017.90 $ 6,259.69 57,402.26 $ 3,875.33 $ 61,277.59 (59,889.94) $ 645,732.21 =TotalLoan $ 585,842.27 $ + ⠀ K Interest Paid ← — Insert Delete Format L Cells M Marie Jones MJ > AutoSum ✔Fill ✓Clear ✓ N V Editing O B 27 Sort & Find & Filter Select ✓ Comments T P O X Analyze Data Analysis Q Share R ▶ 100%
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 7 images

Blurred answer
Knowledge Booster
ASCII Codes
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
New Perspectives on HTML5, CSS3, and JavaScript
New Perspectives on HTML5, CSS3, and JavaScript
Computer Science
ISBN:
9781305503922
Author:
Patrick M. Carey
Publisher:
Cengage Learning
Np Ms Office 365/Excel 2016 I Ntermed
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage