Page 73 - gyamfi series vol. 2

INFORMATION AND COMUNICATION TECHNOLOGY GYAMFI SERIES
Task pane; it is a window that appears automatically the right hand side on the office
window. It is used to perform tasks such as creating a new document, printing and for
searching.
Note;
- Worksheet is the single document of spreadsheet made up of little boxes
arranged in rows and columns.
- Workbook is the collection of two or more worksheets. Or workbook is a
file containing worksheets.
- A letter representing column and a number representing row and combine
to form a new cell. E.g. cell A1, B4, and H10.
- Range; is a spreadsheet formula which select a block of cells for equal
similar treatment. A range of cells can extend across a row, down a
column, or over a combination of the two, but all cells in the range must be
contiguous, sharing at least one common border.
- Graph: a graph is a visual or pictorial representation of data. It can also be
defined as a chart that represents a data.

ENTERING DATA IN A WORKSHEET
You can enter four types of data on in a worksheet cells.
1. LABELS: it is text or numbers not used in calculation.
2. VALUES: these are numbers that can be used in calculation.
3. DATES: a necessary part of most worksheets which helps to identify the time
Program was created.
4. Formula: these are commands to perform calculation numbers or formula.

Use excel functions to create formula for finding total of,
I. Cell E2 = (B2+C2+D2)
OR
=Sum ( B2, C2, D2)
OR
=Sum (B2:D2)
2. Cell E3
= (B3+C3+D4)
OR

=Sum (B3,C3,D3)
OR
=sum (B3:D4)
4. Cell B11
= (B2+B3+B4+B5+B6+B7+B8+B9+B10)
OR
=Sum (B2,B3,B4,B5,B6, B7,B8,B9,B10)
OR
=Sum (B2:B10)
5. Cell C11
= (C2+C3+C4+C5+C6+C7+C8+C9+C10)

Page 73 of 90
ALL SAINTS SCHOOL. Santasi-Apire HANDOUT