시작하기무료로 시작하기

Find minimum and maximum prices

Your goal now is to extract some relevant information from the time series to better understand the price dynamics during the period under analysis.

To that purpose, the first thing is to identify the extremes: what are the minimum and maximum prices reached by ABC during this period? Use the functions MIN() and MAX() to answer these questions.

Recall that these functions work the same way: they receive as the main argument the range of cells from which you want to extract information and return respectively the minimum and maximum values in the range of cells.

이 연습은 강의의 일부입니다

Google Sheets로 하는 금융 분석

강의 보기

연습 안내

  • In F3, use the function MIN() to find the minimum value reached by ABC during the historical period.

  • In F5, use the function MAX() to find the maximum value reached by ABC during the same period.

실습형 인터랙티브 연습문제

이론을 실습으로 바꾸는 인터랙티브 연습 중 하나를 만나보세요

연습 시작