Page 216 - DCAP101_BASIC_COMPUTER_SKILLS
P. 216
Pawan Kumar, Lovely Professional University Unit 11: Operations of MS Excel
Notes
Unit 11: Operations of MS Excel
CONTENTS
Objectives
Introduction
11.1 Features
11.1.1 Excel Parts
11.2 Formulae
11.2.1 Tips for Working with Formulae
11.2.2 Linking Workbooks
11.2.3 Need to Link Workbooks
11.2.4 Creating External Reference Formula
11.3 Graph and Chart
11.3.1 Understanding Charts in PowerPoint
11.3.2 Adding a Chart
11.3.3 Modifying Your Chart
11.3.4 Selecting a Chart Type
11.3.5 Entering Data in the Datasheet
11.3.6 Inserting and Deleting Datasheet Rows and Columns
11.3.7 Formatting Datasheet Column Width
11.3.8 Formatting Datasheet Numbers
11.3.9 Including and Excluding Rows and Columns
11.3.10 Returning to the Presentation from the Datasheet
11.4 Design Corner: Using Chart Formatting Options
11.5 Printing
11.5.1 Change Header and Footer Information on Slides
11.5.2 Change Header and Footer Information on your Notes and Handouts
11.5.3 Delete Header and Footer Information from your Slides
11.5.4 Delete Header and Footer Information from your Notes and Handouts
11.6 Summary
11.7 Keywords
11.8 Self-Assessment Questions
11.9 Review Questions
11.10 Further Readings
LOVELY PROFESSIONAL UNIVERSITY 209
