Homework Help is Here – Start Your Trial Now!
Engineering
Computer Engineering
Using the “Green Savings” worksheet, provide the formulas to calculate the savings for each computer type usage, and corresponding totals.   Using the auto-format feature format range A3:D12 in the “Green Savings” worksheet. note that values are to be formatted with the thousands separator, ZERO decimal places with “$” signs on the final values.

Using the “Green Savings” worksheet, provide the formulas to calculate the savings for each computer type usage, and corresponding totals.   Using the auto-format feature format range A3:D12 in the “Green Savings” worksheet. note that values are to be formatted with the thousands separator, ZERO decimal places with “$” signs on the final values.

Computer Networking: A Top-Down Approach (7th Edition)
Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
See similar textbooks
icon
Related questions
Question

Using the “Green Savings” worksheet, provide the formulas to calculate the savings for each computer type usage, and corresponding totals.

 

Using the auto-format feature format range A3:D12 in the “Green Savings” worksheet. note that values are to be formatted with the thousands separator, ZERO decimal places with “$” signs on the final values.

ASSGT- INTRO TO COMPUTER - Excel (Product Activation Failed) File Home Insert Page Layout Formulas Data Review View Foxit PDF O Tell me what you want to do.. 2 Share X Cut AutoSum - A. Arial - 10 - A A E Wrap Text Custom EE Copy - V Fill - Paste B I U - A- E Merge & Center - Conditional Format as Cell Insert Delete Format Sort & Find & Format Painter Formatting Table Styles Clear Filter- Select - Clipboard Font Alignment Number Styles Cells Editing D6 fe =B6-C6 A C E F G H. General Green Computer Computer Use (2018) Use (2019) 4 Computer type Savings 9500 $ 7,990 12500 $ 8,500 21200 $ 13,300 21450 $ 20,550 16550 $ 8,450 12450 $ 17,550 8500 $ 10,000 $ 188,490 $102,150 $ 86,340 5 Notebook Dual Core 17490 6 Notebook Quad Core 21000 7 PC Dual Core 34500 8 PC Core Duo 42000 9 Servers Core Duo 25000 10 Servers 4 Core Duo 30000 11 Servers Xeon Quad Core 18500 12 Total 13 14 Green Savings Quarterly Revenue - 2018 Statement of Income Aggregates ... Ready 190 % 8:11 pm O Type here to search 27°C 23/06/2021 WE 近
Transcribed Image Text:ASSGT- INTRO TO COMPUTER - Excel (Product Activation Failed) File Home Insert Page Layout Formulas Data Review View Foxit PDF O Tell me what you want to do.. 2 Share X Cut AutoSum - A. Arial - 10 - A A E Wrap Text Custom EE Copy - V Fill - Paste B I U - A- E Merge & Center - Conditional Format as Cell Insert Delete Format Sort & Find & Format Painter Formatting Table Styles Clear Filter- Select - Clipboard Font Alignment Number Styles Cells Editing D6 fe =B6-C6 A C E F G H. General Green Computer Computer Use (2018) Use (2019) 4 Computer type Savings 9500 $ 7,990 12500 $ 8,500 21200 $ 13,300 21450 $ 20,550 16550 $ 8,450 12450 $ 17,550 8500 $ 10,000 $ 188,490 $102,150 $ 86,340 5 Notebook Dual Core 17490 6 Notebook Quad Core 21000 7 PC Dual Core 34500 8 PC Core Duo 42000 9 Servers Core Duo 25000 10 Servers 4 Core Duo 30000 11 Servers Xeon Quad Core 18500 12 Total 13 14 Green Savings Quarterly Revenue - 2018 Statement of Income Aggregates ... Ready 190 % 8:11 pm O Type here to search 27°C 23/06/2021 WE 近
ASSGT- INTRO TO COMPUTER - Excel (Product Activation Failed) File Home Insert Page Layout Formulas Data Review View Foxit PDF O Tell me what you want to do.. 2 Share X Cut AutoSum - A. Arial - 10 - A A E Wrap Text General EE Copy - V Fill - Paste BIU - A- E Merge & Center - $ - % , Conditional Format as Cell Insert Delete Format Sort & Find & Format Painter Formatting- Table Styles - Clear Filter- Select - Clipboard Font Alignment Number Styles Cells Editing J11 fe A B C D E F G H J K L 4 2018 2019 5 Revenues and gains *Sales revenue 1,420,000 511,500 7 *Interest revenue 8 *Investment Income 52,500 89,500 2,073,500 *Other revenue 10 Total revenue and gains (A) 11 12 Expenses and losses **Cost of goods sold **Selling and admin administrative ***Computer (operating) **Depreciation 17 13 460,000 14 195,000 15 16 55,000 **Interest expense 25,200 18 Total expenses and losses (B) 735,200 19 Income before taxes (A-B) 20 Income tax expense (30%) 1,338,300 (401,490) 21 Not lncome a36 010 ... Quarterly Revenue - 2018 Statement of Income Aggregates Ready 145 % 7:49 pm O Type here to search 27°C 23/06/2021
Transcribed Image Text:ASSGT- INTRO TO COMPUTER - Excel (Product Activation Failed) File Home Insert Page Layout Formulas Data Review View Foxit PDF O Tell me what you want to do.. 2 Share X Cut AutoSum - A. Arial - 10 - A A E Wrap Text General EE Copy - V Fill - Paste BIU - A- E Merge & Center - $ - % , Conditional Format as Cell Insert Delete Format Sort & Find & Format Painter Formatting- Table Styles - Clear Filter- Select - Clipboard Font Alignment Number Styles Cells Editing J11 fe A B C D E F G H J K L 4 2018 2019 5 Revenues and gains *Sales revenue 1,420,000 511,500 7 *Interest revenue 8 *Investment Income 52,500 89,500 2,073,500 *Other revenue 10 Total revenue and gains (A) 11 12 Expenses and losses **Cost of goods sold **Selling and admin administrative ***Computer (operating) **Depreciation 17 13 460,000 14 195,000 15 16 55,000 **Interest expense 25,200 18 Total expenses and losses (B) 735,200 19 Income before taxes (A-B) 20 Income tax expense (30%) 1,338,300 (401,490) 21 Not lncome a36 010 ... Quarterly Revenue - 2018 Statement of Income Aggregates Ready 145 % 7:49 pm O Type here to search 27°C 23/06/2021
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 5 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY
SEE MORE TEXTBOOKS