What are the parts of MS Excel 2010?

Explore Window in Excel 2010

  • File Tab. The File tab replaces the Office button from Excel 2007.
  • Quick Access Toolbar.
  • Ribbon.
  • Title Bar.
  • Help.
  • Zoom Control.
  • View Buttons.
  • Sheet Area.

What do you understand by Microsoft Excel 2010?

Microsoft Excel Starter 2010 is a spreadsheet program designed for everyday tasks such as setting up a budget, maintaining an address list, or keeping track of a list of to-do items. Excel Starter 2010 is very similar to Microsoft Excel 2010 in appearance.

What are 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.

What are the tools of MS Excel?

Five Excel tools you should use

  • Flash fill. Excel’s Flash Fill feature makes it easy to fill data in an Excel worksheet based on adjacent data patterns.
  • Filter and calculate with tables.
  • Dropdown lists.
  • Isolate variable data in a data area.
  • Exception reporting with conditional formatting.

How can I add a PDF to excel?

Insert PDF File in Excel Sheet. Go to the ‘Insert’ tab and under ‘Text’ group click on ‘Object’. You will see an ‘Object’ dialog box being opened. In the ‘Object’ dialog box, under ‘Create New’ tab select Adobe Acrobat Document from ‘Object type’ dropdown.

How can I learn excel?

The best way to learn Excel is to break it down into bite-size components. Here’s how: 1. Practice Simple Math Problems in Excel. When it comes to Excel, it’s easiest to start with basic math. That way, you can get a handle on typing into Excel and get comfortable with its abilities before jumping into more complex tasks, such as learning functions and types of formatting.

What is the function of Microsoft Excel?

Microsoft Excel is a spreadsheet application designed to perform basic and complex mathematical computations and functions. In addition to performing arithmetic operations, Excel allows users to create graphical displays of data, forms and pivot tables.

How do I create a Microsoft Excel spreadsheet?

Steps Open Excel. Notice there are rows and columns. Each column has a capital letter on the top to show what column it is. Click cell A1 and type: Item. Click cell B1 and type: Cost. Click cell A2 and type: Printing. Click in cell B2 and type 80.00. After you click outside of cell B2, 80 will show in cell B2. Click cell A3 and type: Postage.

https://www.youtube.com/watch?v=eI_7oc-E3h0