Page 22 - Viva ICSE Computer Studies 8 : E-book

2 Spreadsheet—Formulas

and Functions

Learning Outcomes
Let’s Learn About

Students will be able to • Introduc on • Types of Cell Referencing
• edit and format a worksheet. • Operators in Excel • Cell Reference to Another
• defi ne cell range and apply formulae. • Working with a Basic Worksheet
Formula • Error Result
• diff erentiate between diff erent types
• Using Compound Formula • Using Func ons
of cell referencing.
• Using Formula on Text • Func on Library
• edit a worksheet from Sheet tab.
• Range • Managing Worksheet
• formulate a function.

Activity Corner

1. Can you make use of an Excel worksheet to organise your daily tasks? Discuss how it can be done in class.

Yes No

2. Encircle ten terms that are used in Excel in the given grid.

D B V U A T W S V R U X
A X I J W Y R O W L M K

U E H F G J Y Z O N G M
T F C O L U M N R I O T
O W O R K B O O K P Q S

F M O M P H N F S A V E

I C N U Q O F R H H R J
L D P L B G L I E G I K
L K Y A N U M B E R S D

Q R C E L L B B T L F I
A S V W X E D O M E H G

T B U C Z A C N A Z C E

10