Page 52 - Ones and Zeros 5 (Student Book)

Spreadsheets

Learning Objectives

Explain how to change the appearance of your
worksheets.
Explain how to display specific data by filtering it.

Illustrate what the logical formula is and how to
use it.

Did You Know?

Spreadsheet apps offer us the option of changing the
appearance of specific cells, or even the whole worksheet.
There are many styles and borders you can use to do this.

Another function available in spreadsheet apps is ‘Data
Filtering’. This lets you examine specific data and is
especially useful when there is a lot of information on a
worksheet and it’s difficult to find what we want.
A logical formula is a function which examines two possible
outcomes. Depending on the possible result, this formula
will give us a specific reaction.

Fun Fact!

Logical formulas are a part of our lives! Every choice we
make will lead to a specific result. Logical testing is based
on this fact.

Let’s play!
Sorry Pip! I have to finish
my homework first!

If you don’t?

If I don’t finish it,
then we won’t play.

49