{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

Chapter 30

# Chapter 30 - x 2 x 2 i Cannot put superscript and subscript...

This preview shows pages 1–9. Sign up to view the full content.

AUTO FILL/COPY 1 2 2 5 <-- B3+3 3 4 5 6 7 8 Double-clicking on the "fill handle" of a cell will fill in the rest of the column provided there's a filled cell next to it. A B C D E F G 1 2 3 4 5 6 7 8 9 10 11 12 13

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
PUTTING LINE BREAKS IN CELLS This is a multi-line cell. The break was entered by inserting [Alt]+[Enter] at the desired break points. A 1 2 3
TEXT FUNCTIONS Income 15,000 Tax rate 35% Taxes owed 5,250 <-- =B4*B3 Tax rate as text 35.00% <-- =TEXT(B4,"0.00%") 0.4 <-- =TEXT(B4,"0.0") Income as date Jan. 24, 1941 <-- =TEXT(B3,"mmm. dd, yyyy") A B C D E 1 2 3 4 5 6 7 8 9 10 11

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
GRAPH TITLES THAT UPDATE AUTOMATICALLY Growth 15% Year Cash flow 1 100.00 2 115.00 <-- B6*(1+\$B\$3) 3 132.25 4 152.09 5 174.90 6 201.14 7 231.31 (this creates the little box you see in cell D21) Cash Flow Graph When Growth = 15.0% Hint : To put in a new line, use [Alt]+[Enter] 1 2 3 4 5 6 7 0 50 100 150 200 250 Cash Flow Graph When Growth = 15.0% Year Cash flow A B C D E F G H I 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24
GREEK AND SYMBOLS IN CELLS Initial stock price 30 15% 20% 0.004 Mean, μ Standard deviation, σ Delta, t

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
SUPERSCRIPTS/SUBSCRIPTS IN CELLS

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: x 2 x 2 i Cannot put superscript and subscript in same column. A B C D 1 2 3 4 5 NAMED CELLS Income 15,000 Tax rate 33% Tax paid 4,950 <-- =tax*B3 Sales Margin Profit 1000 20% 200 <-- =Sales*Margin 5000 30% 1500 <-- =Sales*Margin A B C D E 1 2 3 4 5 6 7 8 9 10 HIDING CELLS Payment 100 Number of payments 15 Discount rate 15% Present value \$584.74 <-- =PV(B5,B4,-B3) Data table <-- Data table header, =B6 0% \$1,500.00 3% \$1,193.79 6% \$971.22 9% \$806.07 12% \$681.09 15% \$584.74 18% \$509.16 21% \$448.90 PV of payments a 33 b 8 c bbb <-- =IF(B4+B3<15,"aaa","bbb") Cell to be hidden --> <-- =B5 To hide a cell containing a reference to another cell which Eng of Neptune Orient Lines (Singapore) for pointing this out to me. HIDING A CELL WHICH REFERS TO A FORMULA contains a formula, you need three semicolons! I thank Peng A B C 1 2 3 4 5 6 7 8 9 10 11 12...
View Full Document

{[ snackBarMessage ]}