Microsoft Excel

Microsoft Excel is a helpful and powerful program for data analysis and documentation. It is a spreadsheet program, which contains a number of columns and rows, where each intersection of a column and a row is a “cell.” Each cell contains one point of data or one piece of information.

Microsoft Excel is a spreadsheet developed by Microsoft for Windows, macOS, Android and iOS. It features calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications.

MS Excel is a software program from Microsoft that is part of the MS Office Suit of software program. Excel is capable of creating and editing spared sheet.

General Use of Excel include cell-based calculation, pivot-table and various graphic tools. For instance with an excel spared sheet you could create a monthly budget, track business expenses or short or organized large amount of data.

How to open Excel:
Window + R --> excel --> Enter

Default Font Size : 11 point  and Font Calibri
File Extensities : .xls and .xlsx
Default Name : Book1

A worksheet is a grid of cells made up of horizontal row and vertical columns.

Three type of data can be entered in a worksheet.
- Number
- Text
- Formulas

Cell can be referenced in three ways
- Relative
- Absolute
-Mixed

Max Row = 1,048,576
Max Columns = 16,384

Worksheet : Worksheet is also called spreadsheet. It is made up of rows, columns and cells.
Rows : Rows run horizontally across the worksheet and ranges from 1 to 1048576.
Columns : Columns run vertically downward across the worksheet and ranges from A to XFD - 1 to 16384.
Cells : Cells are small boxes in the worksheet where we enter data. A cell is the intersection of a row and column. It is identified by row number and column header such as A1, A2.

Question