Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Below is the closing value of the Toronto Stock Exchange (TSX) for June 2023. Using EXCEL functions, please calculate the: (i) Value difference +/- (ii)

Below is the closing value of the Toronto Stock Exchange (TSX) for June 2023. Using EXCEL functions, please calculate the: (i) Value difference +/- (ii) % difference +/- (iii) Using a conditional IF function, indicate whether the % difference is "Y" for positive, or "N" for negative (iv) Insert a 13.55cm x 14cm color trendline line chart displaying the day & closing value Make sure that all the negative results are in a red font. 31-May-23 19,572.24 Day TSX Close 01-Jun-23 19,672.25 02-Jun-23 20,024.63 05-Jun-23 19,931.62 06-Jun-23 20,055.60 07-Jun-23 19,983.69 08-Jun-23 19,942.70 09-Jun-23 19,892.06 12-Jun-23 19,921.31 13-Jun-23 19,990.40 14-Jun-23 20,015.09 15-Jun-23 20,027.35 16-Jun-23 19,975.37 19-Jun-23 19,934.21 20-Jun-23 19,754.14 21-Jun-23 19,705.95 22-Jun-23 19,580.90 23-Jun-23 19,418.23 26-Jun-23 19,587.32 27-Jun-23 19,733.09 28-Jun-23 19,818.85 29-Jun-23 19,913.17 30-Jun-23 20,155.29 Difference +/-

% +/- Positive "Y" Negative "N"

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

Step: 3

blur-text-image

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

More Books

Students also viewed these Accounting questions