Introduction to Excel
1. Part of MS Office Package and windows based application software.
2. Excel is the Excellent version of Lotus Software.
3. The working area of Excel is known as Spreadsheet/Worksheet.
4. The files of Excel is called Workbook.
5. A workbook contains maximum 255 worksheets.
6. The extension of Excel's file is .xlsx and saved in My Document folder by
default.
7. The actual place where you write data is called Cell.
8. A sheet contains 16384 columns and 1048576 rows.
9. With the help of Excel, we can enter data and also used to visualize data with
the help of pivot chart and pivot table.
10. In Excel we can perform mathematical and logical operations on Data with using
Functions.
11. The latest version of MS Office is "MS Office 2021, which was released in
October 2021.
12. Excel is also known as Electronic Spreadsheet.
Elements of Excel window-
1. Title bar
2. Tab
3. Ribbon
4. File menu
5. Name box
6. Formula bar
7. Spreadsheet/worksheet
8. Sheet tab
9. Horizontal & Vertical scroll bar
10. Status bar
Functions-Predefine formula is called function
Formulas- Mathematical expression is called formula.
Shortcut Keys
Keys Purpose
Ctrl+Down Arrow Last Row
Ctrl+Up Arrow First Row
Ctrl+Right Arrow Last Column
Ctrl+Left Arrow First Column
Shift+F11 Insert Sheet
Ctrl+PageDown Next Sheet
Ctrl+PageUp Previous Sheet
F11 Insert Chart
Ctrl+; Current Date
Ctrl+: Current Time
Ctrl+Spacebar Select Column
Ctrl+Shift++ Insert Column/Row
Shift+Spacebar Select Row
Ctrl+- Remove Column/Row
Ctrl++ Add column/row
Ctrl+D Down Fill
Ctrl+R Right Fill
Shift+F3 Function Dialog
Sort-Sort is use to arrange records in any order or sequence such as ascending or
descending.
1. One column sort
2. Sort multiple columns(Custom sort)
3. Sort by cell color
4. Sort by font color
5. Sort by icon
6. Sort by custom list
Filter- Filter is use to filter records accoding to specified condition or
criteria.
1. Autofilter(Ctrl+Shift+L)
2. Filter by cell color
3. Filter by font color
4. Filter by icon
5. Advance filter
6. Custom filter
Cell Referencing-
1. Relative Cell Reference(By Default)- A5
2. Mixed Cell Reference- $A5, A$5
3. Absolute Cell Reference- $A$5
