MS Excel Tabs and Ribbon

Ribbon is an area in a spreadsheet which has many useful commands. First there are many TABS; tabs have GROUPS, and Groups have the COMMANDS.

Little description about the TABS is given below.


File: It creates a new workbook, opens an existing one, saves, prints, and shares books and sheets.




Home: It has groups like clipboard, font, alignment, numbers, style, cells, and editing.




Insert: It has groups like Tables, illustrations, charts, spark lines, filters, and links, Text, symbols.




Page Layout: Groups are spreadsheet theme, page setup, scale-to-fit, and sheet options, arrange.




Formulas: Groups are Function Library, Defined Name, Formula Auditing, calculation.




Data: Groups are Connections, Sort & Filter, Data Tools, and Outline.




Review: It has Groups like Proofreading, Language, Comments, Change and Share.





View: Groups are Workbook Views, Show, Zoom, Window and Macros.




Developer: Groups are Code, Add-Ins, Controls, XML, and Modify.










No comments:

Post a Comment

MS Excel Logical Functions

Logical functions in Excel are powerful tools that help you make decisions based on conditions. Whether you're comparing values or testi...

Post Count

Loading...