Spreadsheet

Punjab Board > Class 11 > Computer Science (Total Videos: 241)

Show Content

Select a chapter above and press 'Show Content'. Click a video topic below to view.

Chapter 9: Spreadsheet (15 videos)   (Practice Test)
9.1: Overview
  1. Basics of Spreadsheet
9.2: Features of Spreadsheet Software
  1. Microsoft Excel terminology
9.3: The Spreadsheet's Interface  (Practice Test)
  1. Excel window
  2. Creating workbook, naming and working with cells and sheets
9.4: Entering Data in a Worksheet
  1. Paste cell content
9.5: Basics of Worksheet  (Practice Test)
  1. Addressing cells
  2. Manipulate data: Filtering cells
  3. Named Ranges in MS Excel
9.6: Working with Formulas  (Practice Test)
  1. Working with formulas
  2. Linking WorkSheets in MS Excel
9.7: Functions  (Practice Test)
  1. Working with functions
  2. Manipulate data: Data validation
9.8: Formatting and Customizing Data
  1. Format data: Conditional formatting
9.9: Introducing Charts
  1. Representing data graphically
9.10: Printing Worksheets and Charts
  1. Printing Worksheets and Charts