A Barbara Rudolph 10 Comments Share Conditional Format as Cell Formatting Table Styles Insert Delete Format...

Transcribed Image Text:

A Barbara Rudolph 10 Comments Share Conditional Format as Cell Formatting Table Styles Insert Delete Format Sort & Find & Filter Sensitivity Add-ins Select Analyze Data F Styles Cells Editing Sensitivity Add-ins AutoSave Off Final Exam Problem #2 Template Public Saved to this PC Search File Home Insert Page Layout Formulas Data Review View Automate Help Century 14 = ab Wrap Text General Paste BIU v v A Merge & Center $ % 5000 Alignment Number E11 Clipboard fx Font K L M A B C D 1 2 F H Year Cost 3 2018 4 Straight-Line Depreciation Schedule Cost - Residual Depreciation Expense Accumulated Depreciation Book Value 8,500 300 410 410 8,090 2019 8,500 300 1,640 2,050 6,450 5 2020 8,500 300 1,640 3,690 4,810 6 2021 8,500 300 1,640 5,330 3,170 7 2022 8,500 300 1,640 6,970 1,530 8 8,500 300 1,230 8,200 300 2023 9 10 11 12 17 Straight-Line Units of Production Declining Balance + Ready Public Accessibility: Good to go Type here to search E (4)) 6:36 PM 12/6/2023 100% A Barbara Rudolph 10 Comments Share Conditional Format as Cell Formatting Table Styles Insert Delete Format Sort & Find & Filter Sensitivity Add-ins Select Analyze Data F Styles Cells Editing Sensitivity Add-ins AutoSave Off Final Exam Problem #2 Template Public Saved to this PC Search File Home Insert Page Layout Formulas Data Review View Automate Help Century 14 = ab Wrap Text General Paste BIU v v A Merge & Center $ % 5000 Alignment Number E11 Clipboard fx Font K L M A B C D 1 2 F H Year Cost 3 2018 4 Straight-Line Depreciation Schedule Cost - Residual Depreciation Expense Accumulated Depreciation Book Value 8,500 300 410 410 8,090 2019 8,500 300 1,640 2,050 6,450 5 2020 8,500 300 1,640 3,690 4,810 6 2021 8,500 300 1,640 5,330 3,170 7 2022 8,500 300 1,640 6,970 1,530 8 8,500 300 1,230 8,200 300 2023 9 10 11 12 17 Straight-Line Units of Production Declining Balance + Ready Public Accessibility: Good to go Type here to search E (4)) 6:36 PM 12/6/2023 100%