Monday, February 26, 2018

Excel Anatomy- Part03 Excel Interface and Ribbon

Excel  interface  and ribbon

Title bar

A title bar that shows the application name and the name of the open file.




Tool bar
Displays the buttons of the most frequently used functions. This tab contains undo, repeat, save keys.



 Menu bar
A menu bar that provides access to the various functions of the spreadsheet.                           
  


File

The File menu is the leftmost item in the Excel ribbon. The File ribbon items enable you to perform file management functions, including open, save, close, and print. You also use the File menu to import from external sources into Excel, along with options that allow you to tweak Excel itself.

Pro Tip: The File menu does not appear as a ribbon in Excel for Mac. Instead, the File menu appears in the Application menu bar.

Home tab

The Home menu is the second menu in the Excel menu bar. The Home ribbon items include options for formatting font, color, conditional formatting, filter, number type, and more. All these functions help one in performing various effective calculations.

Insert

As the name suggests, the Insert menu helps you insert various options and item into and Excel spreadsheet. You can insert a variety of things from pivot table to picture, clip art, shapes, screen shots, charts and graphs, text box, Header and Footer, symbols, equation and more.

Page layout

You’ll see many options for configuring pages for viewing and printing—including page size,margins, colors and fonts, and so forth. You can also customize cell height and width on the Page Layout menu.

Formulas

The Formulas menu is where you find all the number-crunching options. Excel comes with lots of formulas including financial, logical, text, date &time ,lookup & reference, and math &trigonometry.

Data

The Data menu also contains many important functions in Excel, including imports and connections with databases. You also access the sort, filter,remove duplicates, data validation,consolidation, group, ungroup, and subtotal functions on the Data menu.


Review

Earlier in this article, we mentioned Excel’s ability to collaborate on spreadsheets. The Review menu is where many of those tasks take place. You can make comments in cells for your colleagues, check spelling, track changes, and even restrict permission using items in the Review menu

View

On the View menu, you customize the way spreadsheets appear on your screen. Options include displaying grid lines between cells, toggling the formula bar and headings, and more.This menu also gives you options to view and record macros, as well—macros let you record common steps you perform so you don’t have to repeat the same things over and over again

Formula bar

This information that can be entered or edited through the formula bar includes formulas,which are combinations of letters, numbers and symbols that can help users perform calculation.If you want to hide or display the formula bar, you can do it in VIEW >> Show >> Formula Bar.


Click down arrow to see the used values , formulas etc.





Work sheet

Excel worksheet is a single spreadsheet that contains cells organized by rows and columns. A worksheet begins with row number one and column A Each cell can contain a number, text or formula. A cell can also reference another cell in the same worksheet, the same workbook or a different workbook. In Excel 2010, the maximum size of a worksheet is 1,048,576 rows by16,384 columns.





Workbook

A workbook is an Excel file that contains one or more worksheets.




Status bar

The status bar is located at the bottom of the screen, below the working area. It displays information about the current activities in the worksheet. Left side status bar (zoom bar) . The first thing that stands out when you look at the Status Bar is the word READY. It will be present for most of the time when you work with Excel.

As soon as you start typing in a cell, it will change to the ENTER. Double click the cell containing a value, and the text will change to EDIT.


No comments:

Post a Comment

Excel Anatomy Part04 - Home and Insert Ribbons

Home and Insert Ribbons Home Ribbon Home tab contains the most frequently used options such as cut-copy-paste, font formatting, alignme...