11
SENIOR HIGH SCHOOL
Quarter 1 Module 5
Cordova National High School
Technical-Vocational Livelihood (TVL)
Information and Communications Technology
Computer Systems Servicing NC II Quarter 1 Module 5
PERFORMING COMPUTER OPERATIONS /
Software System (Electronic Spreadsheet using MS Excel 2016)
SELF – CHECK
I. True or False
Read each statement carefully and determine if it is true or false. Write T if true otherwise
write F if false.
_______1. MS Excel is an electronic spreadsheet used to organize data into rows and columns.
_______2. The worksheet in Excel is consists of 1,480,576 rows.
_______3. The worksheet in Excel is consists of 116,385 columns.
_______4. MS Excel is a spreadsheet program that has an ability to calculate numerical data.
_______5. The Ribbon is designed to help quickly find the commands needed to complete a
task.
_______6. Spreadsheet is useful in making large calculations.
_______7. A worksheet is made up of columns and rows.
_______8. Rows are labeled with numbers.
_______9. The cell address of the cell at the intersection of column A and row 1 is 1A.
_______10. Columns are labeled with letters.
II DECODING
Find each letter by using its cell address to decode the secret words. Write the secret word on the space
provided.
A B C D E
1 A B C D E
2 F G H I J
3 K L M N O
4 P Q R S T
5 U V W X Y
6 Z
_____________________1. D4 + A4 + C4 + E1 + A1 + D1 + D4 + C2 + E1 + E1 + E4
_____________________2. C4 + A1 + D3 + B2 + E1
_____________________3. C3 + A1 + E4 + C2 + E1 + C3 + A1 + E4 + D2 + C1 + D4
_____________________4. A2 + A5 + D3 + C1 + E4 + D2 + E3 + D3 + D4
_____________________5. C5 + E3 + C4 + A3 + D4 + C2 + E1 + E1 + E4
_____________________6. C3 + D2 + C1 + C4 + E3 + D4 + E3 + A2 + E4
_____________________7. C1 + E3 + B3 + A5 + C3 + D3
_____________________8. E1 + D5 + C1 + E1 + B3
_____________________9. A2 + E3 + C4 + C3 + A5 + B3 + A1
_____________________10. C1 + E3 + C3 + A4 + A5 + E4 + E1 + C4