The Complete Excel Guide: Beginners to Advanced - Stock Charts

The Complete Excel Guide: Beginners to Advanced - Stock Charts

Assessment

Interactive Video

Information Technology (IT), Architecture, Business

University

Hard

Created by

Quizizz Content

FREE Resource

The video tutorial covers the basics of stock charts, focusing on key elements like opening, high, low, and closing prices, as well as the adjusted close. It explains the impact of dividends and stock splits on pricing. The tutorial guides viewers on downloading stock data and creating various stock charts in Excel, including candlestick and volume charts, with tips on formatting and adjusting axes for better visualization.

Read more

3 questions

Show all answers

1.

OPEN ENDED QUESTION

3 mins • 1 pt

How does a stock split affect the value of existing shares?

Evaluate responses using AI:

OFF

2.

OPEN ENDED QUESTION

3 mins • 1 pt

What adjustments are made to high and low prices when calculating adjusted close?

Evaluate responses using AI:

OFF

3.

OPEN ENDED QUESTION

3 mins • 1 pt

What steps are involved in creating a stock chart in Excel?

Evaluate responses using AI:

OFF