Homework Help is Here – Start Your Trial Now!
Engineering
Computer Science
Define names for the cells in the range D5:D7 based on the values in the range C5:C7.

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

Database System Concepts
Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
See similar textbooks
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

SEE SOLUTIONCheck out a sample Q&A here
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.
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education
SEE MORE TEXTBOOKS