What is MS Excel?
MS Excel is a Microsoft Office application developed by
Microsoft. The Excel Spreadsheet Software supports multiple operating systems
such as Windows, Mac OS, Android, Ios, and iPad OS. It is used to perform
calculations and computations using various functions and formulas present in
Excel. Users can store and analyze the data whenever they needed.
What is a Cell?
A cell in Excel is defined as the intersection of rows and
columns. It is present in the form of a rectangular shape. The combination of
rows and columns forms a table.
Cell Address in Excel
As the name suggests, cell address is the name by which the Cell
is addressed. For example, A1 indicates the Cell in the first Row and column.
Features of MS Excel
Home: The Home option
consists of tabs such as Clipboard, Font, Alignment, Number, Styles, Cells, and
Editing.
Insert: The Insert tab
consists of Tables, Illustrations, Charts, Links, and Text.
Page Layout: Themes, Page
Setup, Page Background, Paragraph, and Arrange.
Formulas: The Formulas
consist of Function Library, Defined Names, Formula Auditing and Calculation
Data: The Data consists
of Get External Data, Connections, Sort &Filter, Data Tools, and Outline.
Review: The review tab
consists of Proofing, Comments, and Changes.
View: The View tab
consists of Workbook Views, Show/Hide, Zoom, Window, and Macros.
WPS PDF consists of
Create PDF, WPS PDF Tools, and Settings.
Usage of MS Excel
- Data
Entry
- Time
Management
- Accounting
- Financial
analysis
- Charting
and Graphing
- Financial
Modeling
- Programming
- Task
Management and Data Management
- Customer
Relationship Management(CRM)
- Mathematical
Calculations
- Human
Resource Management
Components Present in Excel
Components Present in Excel are defined as follows:
Cell: The intersection
of Row and column is called Cell
Cell reference: The cells are
referenced by the cell name. The respective Cell's horizontal Row and vertical
column numbers assign the cell name.
Active Cell: The current
selected Cell is called Active Cell
Workbook: The workbook
comprises one or more worksheets.
Worksheet: Multiple
worksheets are nested within a single workbook.
Worksheet tab: The worksheet tab
is presented at the bottom left of the spreadsheet.
Column and Row Heading: The column letter
and row number are outside the rows and columns. Selecting the Header will
select the entire Row and column.
Formula: Formulas in Excel
generate the accurate result for the given problem. It is entered in a
particular cell preceded by a "=" sign.
Formula bar: The formula bar
or input bar is at the top of the worksheet where the formulas or values are
entered.
Filter: The Filter option
is in the Sort & Filter tab in the top right of the Home bar. It displays
the user-specified data in the selected rows and columns.
Auto-fill: The auto-fill
option fills the required data in multiple cells. The data containing the
respective Cell is selected, and drag the bottom right corner to the specified
amount of Cell to auto-fills the data.
Auto Sum: The Auto Sum
feature is used to add the data present in the selected Cell. The Auto Sum
option is present in the top right of the home page in the "Sort and
Filter" tab.
Pivot Table: The Pivot table
automatically sorts and calculates the data for the selected data. It is
presently left to the Insert tab.
Pivot Chart: The Pivot Chart
represents the data in graph format. It is located in the middle of the Insert
Page next to Maps.
