What are the Excel terminologies?

What are the Excel terminologies?

Excel Terminology

• A cell is the basic building block of a worksheet.
• A range is simply any collection of cells.
• A workbook is simply another name for your Excel file.
• A worksheet is where Excel stores all your text, numbers and formulas.
• The ribbon is Excels graphical menu interface for commands you can perform.

What are the parts of Microsoft Excel 2013?

Here are some pertinent Excel features:

• Title Bar. Ribbon. File Tab.
• Cell. Cell Range. Formula Bar.
• Worksheet. New Sheet. Status Bar.
• View Options. Name Box. Quick Access Toolbar.

What are the terminologies of spreadsheet?

Spreadsheet Terminologies

• Row: The horizontal line in a worksheet.
• Column: The vertical line in a worksheet.
• Cell: The intersection of row and column.
• Worksheet: A page in an Excel workbook.
• Workbook: A spreadsheet document containing more than one worksheet.
• Chart: A graphical representation of data.

What is the top section of Excel called?

Microsoft Excel ribbon
Microsoft Excel ribbon is the row of tabs and icons at the top of the Excel window that allows you to quickly find, understand and use commands for completing a certain task. It looks like a kind of complex toolbar, which it actually is.

How cells are named in MS Excel *?

Each cell in the spreadsheet has a corresponding name, which is identified by its column letter and row number. For instance, the cell under column A that belongs to row 1 has the default name A1. You will see this in the name box, which is located on the upper left side of the spreadsheet, next to the formula bar.

What are the parts of 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 components of Excel?

The following are the basic parts of the Microsoft Excel Window:

• Quick Access Toolbar.
• File Tab.
• Title Bar.
• Control Buttons.
• Menu Bar.
• Ribbon/Toolbar.
• Dialog Box Launcher.
• Name Box.

How do you show cell names in Excel?

Select Formulas > Create from Selection. In the Create Names from Selection dialog box, designate the location that contains the labels by selecting the Top row,Left column, Bottom row, or Right column check box. Select OK. Excel names the cells based on the labels in the range you designated.

What are the 4 features of spreadsheet?

Features of spreadsheet software

• Rows and columns. Through a spreadsheet’s grid system of rows and columns, all of your information is neatly organized in one easy-to-read space.
• Formulas and functions.
• Data filtering and visualization.
• Custom formatting.
• Accounting.
• Analytics.
• Presentations.
• Project management.