始める無料で始める

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.

実践的なインタラクティブ演習

理論を実践に変える、インタラクティブな演習のひとつをお試しください

演習を開始する