开始使用免费开始使用

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.

动手互动练习

通过我们的互动练习之一,将理论转化为实践

开始练习