Page 8 - ModularV1.1 _c7_flipbook
P. 8
CONTENTS
01 Types of Software 7
q Software q System Software q Application Software
02 Advanced Features of Windows 7 14
q Understanding Windows Explorer q Different Views of Files and Folders
q Searching of Files or Folders q Control Panel
Periodic Assessment-1 22
è
03 Introduction to MS Excel 2010 23
q Starting MS Excel 2010 q Components of MS Excel 2010
q Creating a New Workbook q Entering Data in a Worksheet
q Types of Data in MS Excel
04 Editing in MS Excel 28
q Selecting Cells in a Worksheet q Copying/Moving Data q Using Undo and Redo Features
q Column Width and Row Height q Inserting Rows/Columns q Merging Cells
q Autofill q Customise Worksheet Tab
05 Formulas and Functions 35
q Using Formulas to Perform Calculation q Order of Operation
q Different Ways to Enter Formulas q Understanding Cell Range
q Cell Referencing in Formulas and Its Types q Functions
Periodic Assessment-2 47
è
Test Sheet-1 48
è
06 Excel as Database 50
q Form in Excel q Using Form in Excel q Sorting Data
q Filtering Data q Conditional Formatting q Using Data Validation
q Using Subtotal Command q Using Pivot Table
07 Charts in Excel 60
q Components of a Chart q Types of Charts in MS Excel q Creating a Chart
q Formatting a Chart
Periodic Assessment-3 67
è
08 Conditional and Looping Statements in BASIC-256 68
q Conditional Statements q Looping q For...Next Statement
q Sample Programs using For...Next Statement q While…END...WHILE Statement
q Sample Programs using While…END...WHILE Statement q Infinite Loop
09 Services on Internet 76
q Internet Services q Cyber Security q Cyber Crime
q Hacking and Cracking
Periodic Assessment-4 85
è
Test Sheet-2 86
è
Project Work 88
è
Explore More (Excel 2016) 91
è
OGO Cyber Sample Questions 93
è
Keyboard Shortcuts (MS Excel) 95
è
Glossary 96
è
(vi)

