시작하기무료로 시작하기

Exponents and parentheses

Formulas also support more complex operations, including exponentiation and parentheses. Exponentiation allows you to create formulas where one number is placed to the power of another number, and parentheses means you can control the order that operations are executed.

In formulas, operations are executed in the following order, from first to last:

  • Parentheses
  • Exponents
  • Multiplication and division
  • Addition and subtraction

In this exercise, you'll use your knowledge of formulas and order of operations to calculate the new prices for each item, which are calculated by adding 0.2 to the existing Price, then raising to the power of 2.

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

Google Sheets 입문

강의 보기

연습 안내

  • Calculate the New Price for each item in F2:F5 by adding 0.2 to Price, then raising to the power 2.

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

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

연습 시작