DBB1117: Office Automation Tools
Unit: 5 - Microsoft Excel 1
BACHELOR OF BUSINESS ADMINISTRATION
SEMESTER 1
DBB1117
OFFICE AUTOMATION TOOLS
DBB1117: Office Automation Tools
Unit: 5 - Microsoft Excel 2
Unit - 5
Microsoft Excel
DBB1117: Office Automation Tools
Unit: 5 - Microsoft Excel 3
TABLE OF CONTENTS
SL
No
Topic
Fig No / Table
/ Graph
SAQ /
Activity
Page No
1
Introduction
-
-
6 - 7
1.1
Objectives
-
-
2
Creation Of Spreadsheet And Usage Of Excel
-
-
8 - 10
2.1
How to create a spreadsheet
1
-
2.2
Usage of Excel in Different industries
and Domains
-
-
3
Formatting And Editing In The Worksheet
2, 3, 4, 5, 6, 7,
8, 9
-
11 - 16
4
Visibility: Row, Column, Sheet, Security
-
17 - 26
4.1
Row & Column
10, 11, 12, 13,
14, 15, 16, 17,
18, 19, 20
-
4.2
Columns in Excel
-
-
4.3
Sheet
21
-
4.4
Security
22
5
Searching In Excel Sheets
23, 24, 25
-
27 - 30
6
Basic Mathematical And Statistical Functions
Using Formula
26, 27, 28,
29 ,30, 31, 32,
33, 34, 35, 36,
37, 38, 39
-
31 - 40
7
Referencing Worksheets
40, 41
-
41 - 42
8
Workbook
42, 43, 44, 45,
46
-
43 - 47
9
Sorting
47, 48, 49, 50,
51
-
48 - 50
End of Document
288
Figures
