What is MS Excel, Extensions of Excel,sheet/worksheet/spreadsheet,Workbook,What is a column,Row & Cell in Excel?,Exploring Alignment Options,Wrap Text,Merge and Unmerge ,Format Cells,What is Conditional Formatting?,Sort,Filters,Chart,Pivot Tables, Relative and Absolute Cell Referneces,Formulas and Types of Formulas.

MS Excel?

1.      MS Excel is a spreadsheet program where one can record data in the form of tables.

2.     This gives the user a more systematic display of data.

Extensions of Excel

Excel is one the tool which has a variety of extension in which we can save the file. A commonly used extension in Excel is .xlsx, which is used for storing a simple type of data. 

• XLS – Excel file extension

1.   This extension is the most common and default type in the spreadsheet generated by Microsoft office. Prior to Excel 2007, the file extension was XLS. 

2.   The XLS is the default file type for Excel version 2.0 to Excel 2003.

• XLSX – Excel file extension

1.     This extension is used by the spreadsheet files generated with the Excel version 2007 onwards. For an Excel file, the current default file extension is XLSX.

2.       The XLSX file extension is associated with files saved with Microsoft Excel (2007/2010), one of the most popular and powerful tools you can use to create and format spreadsheets, graphs and much more.

3.       The .xlsx files are used in Microsoft Excel (2007/2010) for Workbooks, spreadsheet, and document files.

sheet/worksheet/spreadsheet

·         A spreadsheet or worksheet is a file made of rows and columns that help sort, organize, and arrange data efficiently, and calculate numerical data

Workbook

·         In Microsoft Excel, a workbook is a collection of one or more spreadsheets, also called worksheets, in a single file. Below is an example of a spreadsheet called "Sheet1" in an Excel workbook file called "Book1."

What is a column in Excel?

·         Columns are denoted and identified by a unique alphabetical header letter, which is located at the top of the worksheet.

·         Column headers range from A-XFD, as Excel spreadsheets can have 16,384 columns in total.

·         Columns run vertically in the worksheet, and the data goes from up to down.

What is a row in Excel?

·         Each row is denoted and identified by a unique numeric value that you'll see on the left hand side.

·         The row numbers are arranged vertically on the worksheet, ranging from 1-1,048,576 (you can have a total of 1,048,576 rows in Excel).

·         The rows themselves run horizontally on a worksheet.

What is a cell in Excel?

·         A cell is the intersection of a row and a column. A row and a column adjoined make up a cell.

·         You can define a cell by the combination of a row number and a column header.

Exploring Alignment Options

1. Horizontal Alignment − You can set horizontal alignment to Left, Centre, Right, etc.

·         Left − Aligns the cell contents to the left side of the cell.

·         Center − Centers the cell contents in the cell.

·         Right − Aligns the cell contents to the right side of the cell.

·         Fill − Repeats the contents of the cell until the cell’s width is filled.

·         Justify − Justifies the text to the left and right of the cell. This option is applicable only if the cell is formatted as wrapped text and uses more than one line.

2. Vertical Alignment − You can set Vertical alignment to top, Middle, bottom, etc.

·         Top Aligns the cell contents to the top of the cell.

·         Center Centers the cell contents vertically in the cell.

·         Bottom Aligns the cell contents to the bottom of the cell.

·         Justify Justifies the text vertically in the cell; this option is applicable only if the cell is formatted as wrapped text and uses more than one line.

Wrap Text

• 1.     Wrap text in Excel if you want to display long text on multiple lines in a single cell. Wrap text automatically or enter a manual line break.
• 2.     Make the all contain visible with the cell
  
  

Merge and Unmerge 

·         Merging cells in Excel allows you to create a larger cell that can be seen across multiple rows and columns.

·         This function is very useful when you need to create a text box or a larger area for presenting your data.

Format Cells

When we format cells in Excel, we change the appearance of a number without changing the number itself. We can apply a number format (0.8, $0.80, 80%, etc) or other formatting (alignment, font, border, etc).

What is Conditional Formatting?

Conditional formatting is a feature in Microsoft Excel that allows you to apply specific formatting to your cells according to certain criteria. It enables you to make sense of your data and spot significant trends.

·         Highlight Cell Rules

·         Top/Bottom Rules

·         Data Bar

·         Color Scales

·         Icon Sets 

Sort

As you add more content to a worksheet, organizing this information becomes especially important. You can quickly reorganize a worksheet by sorting your data. For example, you could organize a list of contact information by last name. Content can be sorted alphabetically, numerically, and in many other ways.

 You can sort your Excel data on one column or multiple columns. You can sort in ascending or descending order.

·         One Column 

·         Multiple Columns

Filters

If your worksheet contains a lot of content, it can be difficult to find information quickly. Filters can be used to narrow down the data in your worksheet, allowing you to view only the information you need.

chart

A chart is a tool you can use in Excel to communicate data graphically. Charts allow your audience to see the meaning behind the numbers, and they make showing comparisons and trends much easier. In this lesson, you'll learn how to insert charts and modify them so they communicate information effectively.

• ·         Colum Chart
• ·         Pie Chart
• ·         Line chart. ...
• ·         Bar chart. ...
• ·         Area chart. ...
• ·         Stock chart. ...
• ·         Surface chart. ...
• ·         Radar charts. ..
• 
  
          

Pivot Tables

·          Pivot tables are one of Excel's most powerful features. A pivot table allows you to extract the significance from a large, detailed data set.

·         Our data set consists of 213 records and 6 fields. Order ID, Product, Category, Amount, Date and Country.

Relative and Absolute Cell References

There are two types of cell references: relative and absolute. Relative and absolute references behave differently when copied and filled to other cells. Relative references change when a formula is copied to another cell. Absolute references, on the other hand, remain constant no matter where they are copied.

Formulas

A formula in Excel is used to do mathematical calculations. Formulas always start with the equal sign (=) typed in the cell, followed by your calculation.

Formulas can be used for calculations such as:

• =1+1
• =2*2
• =4/2=2

Type of Formula

1.     Text

2.     Date & Time

3.     Maths

4.     Lookup & Reference

5.     Logical

6.     Etc.

Q 1. What is the definition of MS Excel?

Ans. MS Excel is a spreadsheet program where one can record data in the form of tables. This gives the user a more systematic display of data.

Q 2. What are the main features of Microsoft Excel?

Ans. The main features of MS Excel include inserting a pivot table, sorting of tabulated data, adding formulas to the sheet, and calculating large data.

Q 3. What are the common MS Excel formulas?

Ans. Given below are the common calculations which can be done using MS Excel:

• Addition
• Subtraction
• Average
• Maximum and Minimum
• Concatenate
• Count

Q 4. What is a cell in Microsoft Excel?

Ans. MS Excel comprises a spreadsheet is in the form of a table comprising rows and columns. The rectangular box at the intersection point between rows and columns forms a cell.

Q 5. Can multiple sheets be added to a single spreadsheet?

Ans. Yes, MS Excel gives an option to add multiple worksheets to a single spreadsheet. The user can rename each of these worksheets as per their requirements.