Here you will find the basic commands such as open, save, print, etc.

  • The Ribbon. File Menu.
  • Quick Access Toolbar. Formula Bar.
  • Expand Formula Bar Button. Insert Worksheet Button.
  • Worksheet Navigation Tabs. Normal.
  • View. Page.
  • Layout. View.
  • Page. Break.
  • Preview. Vertical Scroll.

What are the parts of MS Excel 2010 interface?

Let us now understand the various important parts of this window.

  • 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 are the components of MS Excel 2010 window?

Quick Access Toolbar. Formula Bar. Expand Formula Bar Button. Worksheet Navigation Tabs.

What are the parts and functions of MS Excel?

Also called a spreadsheet, the workbook is a unique file created by Excel XP.

  • Title bar. The title bar displays both the name of the application and the name of the spreadsheet.
  • Menu bar.
  • Column headings.
  • Row headings.
  • Name box.
  • Formula bar.
  • Cell.
  • Navigation buttons and sheet tabs.

What are the main components of MS Excel?

Various components of MS Excel are – File Menu, Quick Access Toolbar, Title bar, Rows headings, Columns headings, Active cell(The one on which we put cursor), fill handle (it’s a plus symbol on an active cell to drag items), Address bar, Formula bar, Worksheet tab, Status bar(bottom-most bar in the window having zoom …

What are the parts of Excel spreadsheet?

There are three basic parts of an Excel Spreadsheet:

  • Column – The vertical segments that you see on the spreadsheet are called columns.
  • Row – The horizontal segments are referred to as rows.
  • Cell – Each box that is created from a row and column intersecting is referred to as a cell.

What is the parts of Microsoft Excel?

An Excel worksheet is made up of columns and rows. Its name is comprised of two parts: the column letter and the row number. In the following picture, the cell C3—formed by the intersection of column C and row 3—contains the dark border. It is the active cell.

What happened to the function names in Excel 2010?

In Excel 2010 or later, these functions were replaced with new functions that provide improved accuracy and have names that better reflect their usage. You can still use them for compatibility with earlier versions of Excel, but if backward compatibility isn’t required, you should start using the new functions instead.

How do I use the insert function command in Excel?

The Insert Function command allows you to easily search for a command by entering a description of what you are looking for. Select the cell where the answer will appear ( I6, for example). From the Function Library group, select the function category you want. In this example, we’ll choose Date & Time.

What are the different types of functions in Excel?

A great place to explore functions is in the Function Library on the Formulas tab. Here, you can search and select Excel functions based on categories such as Financial, Logical, Text, and Date & Time. Click the buttons in the interactive below to learn more.