Explain m-s excel tools bars in details
Answers
Answered by
0
These include:
File
Home
Insert
Page Layout
Formulas
Data
Review
View
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
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.
Pro Tip: Try the Format Painter. It allows you to copy the formatting from one cell to another, which can be a great time saver.
Insert
As the name suggests, the Insert menu helps you insert various options and items into an Excel spreadsheet. You can insert a variety of things ranging from pivot table to picture, clip art, shapes, screen shots, charts and graphs, text box, header and footer, symbols, equation, and more.
Pro Tip: You can also insert hyperlinks and even maps using the Insert menu.
Page Layout
Again, the name suggests the collection of functions on the Page Layout menu. 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.
Pro Tip: You can add a background to a collection of cells—or even your entire spreadsheet. Just click Background and select the image you want to use.
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.
Pro Tip: You can name cells or ranges of cells—this can make it easier to customize your formulas.
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.
Pro Tip: Use the Data Validation function to ensure consistency in cells.
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.
Pro Tip: Use the Share Workbook link to share with your coworkers!
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!
Pro Tip: Use the Freeze Top Row or Freeze First Column, and they will stay put while you scroll through pages and pages of numbers.
File
Home
Insert
Page Layout
Formulas
Data
Review
View
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
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.
Pro Tip: Try the Format Painter. It allows you to copy the formatting from one cell to another, which can be a great time saver.
Insert
As the name suggests, the Insert menu helps you insert various options and items into an Excel spreadsheet. You can insert a variety of things ranging from pivot table to picture, clip art, shapes, screen shots, charts and graphs, text box, header and footer, symbols, equation, and more.
Pro Tip: You can also insert hyperlinks and even maps using the Insert menu.
Page Layout
Again, the name suggests the collection of functions on the Page Layout menu. 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.
Pro Tip: You can add a background to a collection of cells—or even your entire spreadsheet. Just click Background and select the image you want to use.
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.
Pro Tip: You can name cells or ranges of cells—this can make it easier to customize your formulas.
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.
Pro Tip: Use the Data Validation function to ensure consistency in cells.
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.
Pro Tip: Use the Share Workbook link to share with your coworkers!
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!
Pro Tip: Use the Freeze Top Row or Freeze First Column, and they will stay put while you scroll through pages and pages of numbers.
Answered by
0
Toolbars can contain buttons, menus, or a combination of both. A toolbar is just a collection of icons that provides a shortcut to using a drop-down menu. Toolbars offer quick shortcuts to commonly used commands and can be moved and repositioned.
Similar questions