Chapter 4 : Spreadsheet (LibreOffice Calc) :-
4.0 Introduction
4.1 Objectives
4.2 Spreadsheet Basics
- 4.2.1 What is Spreadsheet
- 4.2.2 Features & Applications
- 4.2.3 Elements of Spreadsheet Window
4.3 Menus of LibreOffice Calc
- 4.3.1 File Menu
- 4.3.2 Edit Menu
- 4.3.3 View Menu
- 4.3.4 Insert Menu
- 4.3.5 Format Menu
- 4.3.6 Styles Menu
- 4.3.7 Sheet Menu
- 4.3.8 Data Menu
- 4.3.9 Tools Menu
- 4.3.10 Window Menu
- 4.3.11 Help Menu
4.4 Creating and Managing Spreadsheet
- Creating Spreadsheet
- Save, Save As
- Open & Close
4.5 Working with Cells
- Cell Address (Row & Column)
- Selecting Cells
- Entering Data (Text, Number, Date)
- Editing Cell Content
4.6 Formatting and Manipulation
- Font, Alignment & Style
- Cut, Copy, Paste & Paste Special
- Row Height & Column Width
- Insert/Delete Rows & Columns
- AutoFill
- Freeze Panes
4.7 Formulas and Functions
- Addition, Subtraction, Multiplication & Division
- AutoSum
- SUM, COUNT, MAX, MIN, AVERAGE
- DSUM, DMIN, DMAX, DCOUNT, DCOUNTA
- Other Important Formula
- Cell Reference
4.8 Data Analysis
- Sort
- Filter
- Advanced Filter
- What-if Analysis
- Pivot Table
- Data Validation
4.9 Charts
- Bar Chart
- Column Chart
- Pie Chart
- Line Chart
4.10 Page Setup and Printing
- Page Setup
- Print Preview
- Printing
4.12 Important Shortcut Keys