Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The attached Excel files ask you to write simple formulas in cells: In StockWatcher create formulas in cells F4 to F9 that calculate percentage gains

The attached Excel files ask you to write simple formulas in cells:

In StockWatcher create formulas in cells F4 to F9 that calculate percentage gains based on purchase price in C column cells and current sales prices from the D column. Remember that (last price - current price divided by last price) is the algebraic formula. Which stock had the highest gain?

In MusicPlayerz, write formulas in Gross Sales and Profit cells. Gross Sales is (Price multiplied by Projected Sales). Profit is (Actual Sales multiplied by the difference between Price and Cost). The % of Sales should calculate and tell you which is your top profit maker. Which is?

In TotalMischief, I want a graph that shows Regional Sales by Quarter. Hint: highlight the cells A3:E7 and then select Insert followed by the appropriate one from Recommended Charts.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Handbook Of Heavy Tailed Distributions In Finance

Authors: S.T Rachev

1st Edition

0444508961, 9780444508966

More Books

Students also viewed these Finance questions

Question

3. How has e-commerce transformed marketing?

Answered: 1 week ago