Hide all of the dependency tracer arrows at once. Salaries - Excel File Home Insert Page Layout Formulas Data Review Cut > Arial - A A -10 Auto View Tell me what you want to do.. Wrap Text Custom Merge & Center - $ % H HH EL Copy H Fill Paste BIU. >-A- 40 .00 .00 0 Insert Delete Format Format Painter y Clear Conditional Format Cell Formatting as Table Styles - Styles Clipboard Font Alignment Number Cells C2 f =B2+($B$2*B9) A B D E F G H 1 J K L M 1 . 2 Sue Chur 3 Anne Coll 4 Ben Delbow 5 Dr. Patella 6 John Patterson 7 Total Gross Salaries Year 1 $ $ $ $ $ $ Year 2 50,000 $ 45,000 $ 65,000 $ 115,000 $ $ 108,000 $ 280,000 $ Year 3 52,000 1$ + 46,800 $ 67,600 $ 119,600 $ 109,200 $ 286,000 $ Year 4 54,080 $ 48,672 $ 70,304 $ 124,384 $ 113,568 $ 411,008 $ 56,243 50,619 73,116 129,359 118,111 427,448 4% Computer Expense Software Computer Expense Software Office Expenses Coffee Travel & Entertainmeutel How many expenses are billable? How many expenses are not billable? $ $ $ $ 210 40 57 121 Total number of expense line items X 8 9 COLA 10 11 10/17/2016 12 10/23/2016 13 10/25/2016 14 10/28/2016 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 20 Year1 Salaries Hide all of the dependency tracer arrows at once. Salaries - Excel File Home Insert Page Layout Formulas Data Review Cut > Arial - A A -10 Auto View Tell me what you want to do.. Wrap Text Custom Merge & Center - $ % H HH EL Copy H Fill Paste BIU. >-A- 40 .00 .00 0 Insert Delete Format Format Painter y Clear Conditional Format Cell Formatting as Table Styles - Styles Clipboard Font Alignment Number Cells C2 f =B2+($B$2*B9) A B D E F G H 1 J K L M 1 . 2 Sue Chur 3 Anne Coll 4 Ben Delbow 5 Dr. Patella 6 John Patterson 7 Total Gross Salaries Year 1 $ $ $ $ $ $ Year 2 50,000 $ 45,000 $ 65,000 $ 115,000 $ $ 108,000 $ 280,000 $ Year 3 52,000 1$ + 46,800 $ 67,600 $ 119,600 $ 109,200 $ 286,000 $ Year 4 54,080 $ 48,672 $ 70,304 $ 124,384 $ 113,568 $ 411,008 $ 56,243 50,619 73,116 129,359 118,111 427,448 4% Computer Expense Software Computer Expense Software Office Expenses Coffee Travel & Entertainmeutel How many expenses are billable? How many expenses are not billable? $ $ $ $ 210 40 57 121 Total number of expense line items X 8 9 COLA 10 11 10/17/2016 12 10/23/2016 13 10/25/2016 14 10/28/2016 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 20 Year1 Salaries