Chapter 30 - 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

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

View Full Document Right Arrow Icon
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
Background image of page 1

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

View Full DocumentRight Arrow Icon
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
Background image of page 2
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
Background image of page 3

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

View Full DocumentRight Arrow Icon
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
Background image of page 4
GREEK AND SYMBOLS IN CELLS Initial stock price 30 15% 20% 0.004 Mean, μ Standard deviation, σ Delta, t
Background image of page 5

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

View Full DocumentRight Arrow Icon
SUPERSCRIPTS/SUBSCRIPTS IN CELLS
Background image of page 6
Background image of page 7

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

View Full DocumentRight Arrow Icon
Background image of page 8
Background image of page 9
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

This note was uploaded on 02/02/2012 for the course BUSINESS 201 taught by Professor Acknan during the Spring '11 term at MIT.

Page1 / 9

Chapter 30 - 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

This preview shows document pages 1 - 9. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online