Microsoft Excel
Microsoft Office

What is Microsoft Excel

What is Microsoft Excel?

Microsoft Excel or MS Excel is a spreadsheet program. You can easily calculate, organize and format data without error. It is developed by Microsoft Company.

Spreadsheets display tables of values organized in rows and columns. It is usually operated mathematically using each basic and complex mathematics operations and functions. The actual number of rows and columns are 1,048,576 rows and 16,384 columns.

The three areas of the Ribbon are tabs, groups, and commands.

You can get 3 basic components to the Ribbon. It is great to understand what each are called so you learn how to utilize it.

Tabs: You can get seven fundamental ones over the top. Each one presents a task area.

Groups: Each one tab has many of groups which show related items together.

Commands: A command can be a button, a box to go in information, or a menu.

All the things on the tab have been properly selected based on user activities. As an example, Home tab contains all you use generally, such as the commands within the Font group for altering text font: Font, Font Size, Bold, Italic, etc.

Microsoft Excel consists of 7 tabs

  • Home
  • Insert
  • Page Layout
  • Formulas
  • Data
  • Review
  • View

Home tab consists of 7 groups

  • Clipboard
  • Font
  • Alignment
  • Number
  • Styles
  • Cells
  • Editing

Clipboard consists of 4 commands

  • Cut (Shortcuts Ctrl+X)
  • Copy (Shortcuts Ctrl+C)
  • Paste (Shortcuts Ctrl+V)
  • Format Pinter (Shortcuts Ctrl+Shift+X)

The way to Create and Format a Chat:

Column Chart

It is also called bar graphs. Column chart is used to show side by side comparisons between items of data. Every column on the chart shows a various data value from the worksheet.

Line Graph

Line graph is also called line charts. It is used to show trends over time. Every line in the graph shows the alterations in the value for one data value in the worksheet.

Pie Chart

Pie chart is used to show percentages. An individual data series is plotted and every slice of the pie represents an individual data value in the worksheet.

Related links