{"id":110174,"date":"2021-02-24T16:09:07","date_gmt":"2021-02-24T10:39:07","guid":{"rendered":"https:\/\/www.vskills.in\/certification\/tutorial\/?page_id=110174"},"modified":"2024-04-12T14:30:55","modified_gmt":"2024-04-12T09:00:55","slug":"menus-and-toolbars-2","status":"publish","type":"page","link":"https:\/\/www.vskills.in\/certification\/tutorial\/menus-and-toolbars-2\/","title":{"rendered":"Menus and Toolbars"},"content":{"rendered":"\n

Menus and Toolbars<\/strong><\/h4>\n\n\n\n

Menus and toolbars provide ways to give Microsoft Excel instructions about what we want to do.<\/p>\n\n\n\n

A menu displays a list of commands. Some of these commands have images next to them, so we can quickly associate the command with the image. Most menus are located on the menu bar, which is usually at the top of the screen.<\/p>\n\n\n\n

A toolbar can contain buttons with images (the same image we see next to a menu command), menus, or a combination of both. Excel includes many built-in toolbars that we can show and hide as needed. By default, the Standard and Formatting built-in toolbars are docked side by side below the menu.<\/p>\n\n\n\n

The menu of MS-EXCEL is given in the figure below.<\/p>\n\n\n

\n
\"Menus<\/figure>\n<\/div>\n\n\n

Toolbars<\/strong><\/p>\n\n\n\n

Toolbars have buttons or tool buttons, which perform specific function and hence performing an action through various menus or remembering various shortcuts, user just clicks the specific button.<\/p>\n\n\n\n

Standard Toolbar<\/em><\/p>\n\n\n\n

It has buttons to perform standard functions like open, save etc. As shown in the figure below<\/p>\n\n\n

\n
\"Menus<\/figure>\n<\/div>\n\n\n
    \n
  1. To create a new blank workbook<\/li>\n\n\n\n
  2. To open a workbook<\/li>\n\n\n\n
  3. To save a workbook<\/li>\n\n\n\n
  4. To print a workbook.<\/li>\n<\/ol>\n\n\n\n

    Formatting Toolbar<\/em><\/p>\n\n\n\n

    It has buttons to perform general formatting functions like font size, type, color etc. As shown in the figure below<\/p>\n\n\n

    \n
    \"Menus<\/figure>\n<\/div>\n\n\n
      \n
    1. To change font style and size<\/li>\n\n\n\n
    2. Aligning text<\/li>\n<\/ol>\n\n\n\n

      Menus<\/strong><\/p>\n\n\n\n

      MS \u2013EXCEL provides various menus for specific tasks. For example all file related activities are present in the File menu. For using a menu, Alt and the specific character, which is underlined for a specific menu, is pressed and than the menu opens up, it is known as shortcut menu. For example for opening Format menu Alt and \u2018o\u2019 character is pressed.<\/p>\n\n\n\n

      Keyboard Shortcuts<\/strong><\/p>\n\n\n\n

      Tasks that we perform repeatedly can also be done from specific key combination. For example the shortcut key for printing a workbook is Control and \u2018p\u2019 (Control + P).<\/p>\n\n\n\n

      Apply for Data Entry Operator Certification Now!!<\/h3>\n\n\n\n

      https:\/\/www.vskills.in\/certification\/certified-data-entry-operator<\/a><\/p>\n\n\n\n

      Back to Tutorial<\/a><\/strong><\/h4>\n","protected":false},"excerpt":{"rendered":"

      Menus and Toolbars Menus and toolbars provide ways to give Microsoft Excel instructions about what we want to do. A menu displays a list of commands. Some of these commands have images next to them, so we can quickly associate the command with the image. Most menus are located on the menu bar, which is…<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"categories":[113],"tags":[],"class_list":["post-110174","page","type-page","status-publish","hentry","category-data-entry-operator"],"acf":[],"yoast_head":"\nMenus and Toolbars - Tutorial<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.vskills.in\/certification\/tutorial\/menus-and-toolbars-2\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Menus and Toolbars - Tutorial\" \/>\n<meta property=\"og:description\" content=\"Menus and Toolbars Menus and toolbars provide ways to give Microsoft Excel instructions about what we want to do. A menu displays a list of commands. Some of these commands have images next to them, so we can quickly associate the command with the image. Most menus are located on the menu bar, which is...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.vskills.in\/certification\/tutorial\/menus-and-toolbars-2\/\" \/>\n<meta property=\"og:site_name\" content=\"Tutorial\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/vskills.in\/\" \/>\n<meta property=\"article:modified_time\" content=\"2024-04-12T09:00:55+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.vskills.in\/lms\/wp-content\/uploads\/2016\/05\/Menus-and-Toolbars-1.gif\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/menus-and-toolbars-2\/\",\"url\":\"https:\/\/www.vskills.in\/certification\/tutorial\/menus-and-toolbars-2\/\",\"name\":\"Menus and Toolbars - Tutorial\",\"isPartOf\":{\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/menus-and-toolbars-2\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/menus-and-toolbars-2\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/www.vskills.in\/lms\/wp-content\/uploads\/2016\/05\/Menus-and-Toolbars-1.gif\",\"datePublished\":\"2021-02-24T10:39:07+00:00\",\"dateModified\":\"2024-04-12T09:00:55+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/menus-and-toolbars-2\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.vskills.in\/certification\/tutorial\/menus-and-toolbars-2\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/menus-and-toolbars-2\/#primaryimage\",\"url\":\"http:\/\/www.vskills.in\/lms\/wp-content\/uploads\/2016\/05\/Menus-and-Toolbars-1.gif\",\"contentUrl\":\"http:\/\/www.vskills.in\/lms\/wp-content\/uploads\/2016\/05\/Menus-and-Toolbars-1.gif\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/menus-and-toolbars-2\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.vskills.in\/certification\/tutorial\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Menus and Toolbars\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/#website\",\"url\":\"https:\/\/www.vskills.in\/certification\/tutorial\/\",\"name\":\"Tutorial\",\"description\":\"Vskills - A initiative in elearning and certification\",\"publisher\":{\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.vskills.in\/certification\/tutorial\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/#organization\",\"name\":\"Vskills\",\"url\":\"https:\/\/www.vskills.in\/certification\/tutorial\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2017\/07\/vskills-min-logo.jpg\",\"contentUrl\":\"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2017\/07\/vskills-min-logo.jpg\",\"width\":73,\"height\":55,\"caption\":\"Vskills\"},\"image\":{\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/vskills.in\/\",\"https:\/\/x.com\/vskills_in\",\"https:\/\/www.linkedin.com\/company-beta\/1371554\/\",\"https:\/\/www.youtube.com\/channel\/UCMWnscxPwRF_PqXo9B7q_Tw\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Menus and Toolbars - Tutorial","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.vskills.in\/certification\/tutorial\/menus-and-toolbars-2\/","og_locale":"en_US","og_type":"article","og_title":"Menus and Toolbars - Tutorial","og_description":"Menus and Toolbars Menus and toolbars provide ways to give Microsoft Excel instructions about what we want to do. A menu displays a list of commands. Some of these commands have images next to them, so we can quickly associate the command with the image. Most menus are located on the menu bar, which is...","og_url":"https:\/\/www.vskills.in\/certification\/tutorial\/menus-and-toolbars-2\/","og_site_name":"Tutorial","article_publisher":"https:\/\/www.facebook.com\/vskills.in\/","article_modified_time":"2024-04-12T09:00:55+00:00","og_image":[{"url":"http:\/\/www.vskills.in\/lms\/wp-content\/uploads\/2016\/05\/Menus-and-Toolbars-1.gif","type":"","width":"","height":""}],"twitter_misc":{"Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.vskills.in\/certification\/tutorial\/menus-and-toolbars-2\/","url":"https:\/\/www.vskills.in\/certification\/tutorial\/menus-and-toolbars-2\/","name":"Menus and Toolbars - Tutorial","isPartOf":{"@id":"https:\/\/www.vskills.in\/certification\/tutorial\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.vskills.in\/certification\/tutorial\/menus-and-toolbars-2\/#primaryimage"},"image":{"@id":"https:\/\/www.vskills.in\/certification\/tutorial\/menus-and-toolbars-2\/#primaryimage"},"thumbnailUrl":"http:\/\/www.vskills.in\/lms\/wp-content\/uploads\/2016\/05\/Menus-and-Toolbars-1.gif","datePublished":"2021-02-24T10:39:07+00:00","dateModified":"2024-04-12T09:00:55+00:00","breadcrumb":{"@id":"https:\/\/www.vskills.in\/certification\/tutorial\/menus-and-toolbars-2\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.vskills.in\/certification\/tutorial\/menus-and-toolbars-2\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.vskills.in\/certification\/tutorial\/menus-and-toolbars-2\/#primaryimage","url":"http:\/\/www.vskills.in\/lms\/wp-content\/uploads\/2016\/05\/Menus-and-Toolbars-1.gif","contentUrl":"http:\/\/www.vskills.in\/lms\/wp-content\/uploads\/2016\/05\/Menus-and-Toolbars-1.gif"},{"@type":"BreadcrumbList","@id":"https:\/\/www.vskills.in\/certification\/tutorial\/menus-and-toolbars-2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.vskills.in\/certification\/tutorial\/"},{"@type":"ListItem","position":2,"name":"Menus and Toolbars"}]},{"@type":"WebSite","@id":"https:\/\/www.vskills.in\/certification\/tutorial\/#website","url":"https:\/\/www.vskills.in\/certification\/tutorial\/","name":"Tutorial","description":"Vskills - A initiative in elearning and certification","publisher":{"@id":"https:\/\/www.vskills.in\/certification\/tutorial\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.vskills.in\/certification\/tutorial\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.vskills.in\/certification\/tutorial\/#organization","name":"Vskills","url":"https:\/\/www.vskills.in\/certification\/tutorial\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.vskills.in\/certification\/tutorial\/#\/schema\/logo\/image\/","url":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2017\/07\/vskills-min-logo.jpg","contentUrl":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2017\/07\/vskills-min-logo.jpg","width":73,"height":55,"caption":"Vskills"},"image":{"@id":"https:\/\/www.vskills.in\/certification\/tutorial\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/vskills.in\/","https:\/\/x.com\/vskills_in","https:\/\/www.linkedin.com\/company-beta\/1371554\/","https:\/\/www.youtube.com\/channel\/UCMWnscxPwRF_PqXo9B7q_Tw"]}]}},"_links":{"self":[{"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/pages\/110174","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/comments?post=110174"}],"version-history":[{"count":3,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/pages\/110174\/revisions"}],"predecessor-version":[{"id":127930,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/pages\/110174\/revisions\/127930"}],"wp:attachment":[{"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/media?parent=110174"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/categories?post=110174"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/tags?post=110174"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}