시작하기무료로 시작하기

Amount variance

Eddy's Dog Hotel is planning to expand their operations so the bank wants the hotel to get an audit.

Eddy has asked you to perform an audit of the hotel's financial statements. As part of your planning process, you want to look for accounts that increased more than $1,000 since the prior year.

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

Google Sheets에서 조건부 서식

강의 보기

연습 안내

  • Select the data in the $ Change column by highlighting the range D8:D20.

  • Add a conditional formatting rule using the "Custom formula is" option and write a formula that highlights amounts over $1,000 with the Default green background.

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

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

연습 시작