Answered: se the fill handle to create two lists…

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

Related questions

Question

1. Use the fill handle to create two lists of percentages: (a) 4.00% through 13.00% in increments of 0.50% in the range I5:I23 and (b) 4.00% through 11.00% in increments of 1.00% in the range J4:Q4.

2. Use the Data Table button in the What-If Analysis gallery (Data tab | Forecast group) to define the range I4:Q23 as a two-input data table. Enter C8 in the ‘Row input cell’ box and C5 in the ‘Column input cell’ box (Data Table dialog box). Click OK to populate the table.

3. Format the two-input data table using a White, Background 1 font color and the fill color used in cells B3:G12. Bold ranges I4:Q4 and I5:I23. Format cells J5:Q23 to match the number format used in cells F5:G12. Place a light style border around the range I3:Q23, light style borders between columns in that same range, and a light style bottom border on the range I4:Q4.

4. Protect the worksheet so that the user can select only unlocked cells (C3:C6 and C8:C9).

*Complete the following using Excel based off the document provided* Be sure to show me how each step is to be completed!

Thanks!

: x v fx =C14
14
G
Q
S
т
CE
F
H
K
M
R
403B Planning Sheet
Impact of Varying Annual Return and Employee Percent Invested
1
Future
Employee
Jacob O'Mara
Years
Annual Return in Left Column and Employee Percent Invested in Top Row
3
Name
Value
Investment
4 Annual Income
5 Employee Percent Invested
Employer Match
Total Percent Invested
$125,215.00
$173,901.17
97,115.47
234,788.82
$80,137.60
$173,901.17
8.00%
50,086.00
6
5.00%
10
100,172.00
7
13.00%
15
429,958.03
150,258.00
8
Expected Annual Return
7.00%
706,634.84
1,098,858.88
1,654,885.57
2,443,123.06
3,560,548.44
8
20
200,344.00
9 Years Employed
10 Monthly Contribution
Employee
Employer
8.
25
250,430.00
300,516.00
350,602.00
400,688.00
30
$834.77
$521.73
$1,356.50
$173,901.17
11
35
12
40
13
Total
14
Future Value
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 3 steps with 4 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

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