開始使用免費開始

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 試算表的條件格式

檢視課程

練習說明

  • 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.

動手互動練習

將理論付諸實踐,立即體驗我們的互動練習

開始練習