Using Google Sheets for storing and working with test cases

There are a lot of software solutions designed to work with checklists. But some people don't use the specialised software for this task. With a little bit of skill, you can successfully use, for example, Google Sheets getting advantages of their flexibility, performance and scalability. 

I would like to share my experience and talk about peculiarities of working with Google Sheets, show the general scheme of work with a simple example and demonstrate ready-made formulas and scripts that automate and significantly simplify the execution of tasks.