{"id":112219,"date":"2021-03-16T17:31:59","date_gmt":"2021-03-16T12:01:59","guid":{"rendered":"https:\/\/www.vskills.in\/certification\/tutorial\/?page_id=112219"},"modified":"2024-04-12T14:31:48","modified_gmt":"2024-04-12T09:01:48","slug":"ms-excel-interface-and-moving-in-a-worksheet-2","status":"publish","type":"page","link":"https:\/\/www.vskills.in\/certification\/tutorial\/ms-excel-interface-and-moving-in-a-worksheet-2\/","title":{"rendered":"MS-Excel Interface and Moving in a worksheet"},"content":{"rendered":"\n

A spreadsheet is a computer application with tools that increase the user’s productivity in capturing, analyzing, and sharing tabular data sets. It displays multiple cells usually in a two-dimensional matrix or grid consisting of rows and columns (in other words, a table, hence “tabular”).<\/p>\n\n\n\n

Microsoft Excel is a Spreadsheet package that is widely used for financial purposes. The workspace called the workbook is divided into a number of sheets called the worksheet. The screen that appears on opening MS-EXCEL is-<\/p>\n\n\n\n

Menu Bar \u2013 It is below title bar of the window, listing all nine drop down menu of MS-Excel.
Status Bar – It is at bottom of the window showing keyboard keys status and computed result.
Row and Row Number – The horizontal lines are rows, numbered 1,2,3 up to 65536.
Column and Column Number – The vertical lines columns named A, B, C and so on up to IV.
Cell – The intersection of a row and a column is called the cell.
Cell Address – The cell address is column name and the row address; so A1 is cell address of first cell at first column and first row. The last cell\u2019s address is IV65536.
Worksheets \u2013 It consists of cells organized into columns and rows and is stored in a workbook.
Workbooks – It is MS-Excel file with many worksheets to store data with \u201cXLS\u201d extension.
Work Sheet tabs – They appear at bottom showing worksheet names and to move or edit them.<\/p>\n\n\n\n

\"ms-excel-interface-and-moving-in-a-worksheet\"<\/figure><\/div>\n\n\n\n

Moving in a worksheet<\/strong><\/p>\n\n\n\n

To move between cells on a worksheet, click any cell or use the arrow keys. When we move to a cell, it becomes the active cell. To see a different area of the sheet, use the scroll bars.<\/p>\n\n\n\n

To scroll<\/strong><\/td>Do this<\/strong><\/td><\/tr><\/thead>
One row up or down<\/td>Click the arrows in the vertical scroll bar.<\/td><\/tr>
One column left or right<\/td>Click the arrows in the horizontal scroll bar.<\/td><\/tr>
One window up or down<\/td>Click above or below the scroll box in the vertical scroll bar.<\/td><\/tr>
One window left or right<\/td>Click to left or right of scroll box in the horizontal scroll bar.<\/td><\/tr>
A large distance<\/td>Drag the scroll box to the approximate relative position. In a very large worksheet, hold down SHIFT while dragging<\/td><\/tr><\/tbody><\/table><\/figure>\n","protected":false},"excerpt":{"rendered":"

A spreadsheet is a computer application with tools that increase the user’s productivity in capturing, analyzing, and sharing tabular data sets. It displays multiple cells usually in a two-dimensional matrix or grid consisting of rows and columns (in other words, a table, hence “tabular”). Microsoft Excel is a Spreadsheet package that is widely used for…<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"categories":[],"tags":[],"class_list":["post-112219","page","type-page","status-publish","hentry"],"acf":[],"yoast_head":"\nMS-Excel Interface and Moving in a worksheet - 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\/ms-excel-interface-and-moving-in-a-worksheet-2\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"MS-Excel Interface and Moving in a worksheet - Tutorial\" \/>\n<meta property=\"og:description\" content=\"A spreadsheet is a computer application with tools that increase the user’s productivity in capturing, analyzing, and sharing tabular data sets. It displays multiple cells usually in a two-dimensional matrix or grid consisting of rows and columns (in other words, a table, hence “tabular”). Microsoft Excel is a Spreadsheet package that is widely used for...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.vskills.in\/certification\/tutorial\/ms-excel-interface-and-moving-in-a-worksheet-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:01:48+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.vskills.in\/lms\/wp-content\/uploads\/2016\/05\/ms-excel-interface-and-moving-in-a-worksheet.jpg\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 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\/ms-excel-interface-and-moving-in-a-worksheet-2\/\",\"url\":\"https:\/\/www.vskills.in\/certification\/tutorial\/ms-excel-interface-and-moving-in-a-worksheet-2\/\",\"name\":\"MS-Excel Interface and Moving in a worksheet - Tutorial\",\"isPartOf\":{\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/ms-excel-interface-and-moving-in-a-worksheet-2\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/ms-excel-interface-and-moving-in-a-worksheet-2\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/www.vskills.in\/lms\/wp-content\/uploads\/2016\/05\/ms-excel-interface-and-moving-in-a-worksheet.jpg\",\"datePublished\":\"2021-03-16T12:01:59+00:00\",\"dateModified\":\"2024-04-12T09:01:48+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/ms-excel-interface-and-moving-in-a-worksheet-2\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.vskills.in\/certification\/tutorial\/ms-excel-interface-and-moving-in-a-worksheet-2\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/ms-excel-interface-and-moving-in-a-worksheet-2\/#primaryimage\",\"url\":\"http:\/\/www.vskills.in\/lms\/wp-content\/uploads\/2016\/05\/ms-excel-interface-and-moving-in-a-worksheet.jpg\",\"contentUrl\":\"http:\/\/www.vskills.in\/lms\/wp-content\/uploads\/2016\/05\/ms-excel-interface-and-moving-in-a-worksheet.jpg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/ms-excel-interface-and-moving-in-a-worksheet-2\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.vskills.in\/certification\/tutorial\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"MS-Excel Interface and Moving in a worksheet\"}]},{\"@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":"MS-Excel Interface and Moving in a worksheet - 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\/ms-excel-interface-and-moving-in-a-worksheet-2\/","og_locale":"en_US","og_type":"article","og_title":"MS-Excel Interface and Moving in a worksheet - Tutorial","og_description":"A spreadsheet is a computer application with tools that increase the user’s productivity in capturing, analyzing, and sharing tabular data sets. It displays multiple cells usually in a two-dimensional matrix or grid consisting of rows and columns (in other words, a table, hence “tabular”). Microsoft Excel is a Spreadsheet package that is widely used for...","og_url":"https:\/\/www.vskills.in\/certification\/tutorial\/ms-excel-interface-and-moving-in-a-worksheet-2\/","og_site_name":"Tutorial","article_publisher":"https:\/\/www.facebook.com\/vskills.in\/","article_modified_time":"2024-04-12T09:01:48+00:00","og_image":[{"url":"http:\/\/www.vskills.in\/lms\/wp-content\/uploads\/2016\/05\/ms-excel-interface-and-moving-in-a-worksheet.jpg","type":"","width":"","height":""}],"twitter_misc":{"Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.vskills.in\/certification\/tutorial\/ms-excel-interface-and-moving-in-a-worksheet-2\/","url":"https:\/\/www.vskills.in\/certification\/tutorial\/ms-excel-interface-and-moving-in-a-worksheet-2\/","name":"MS-Excel Interface and Moving in a worksheet - Tutorial","isPartOf":{"@id":"https:\/\/www.vskills.in\/certification\/tutorial\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.vskills.in\/certification\/tutorial\/ms-excel-interface-and-moving-in-a-worksheet-2\/#primaryimage"},"image":{"@id":"https:\/\/www.vskills.in\/certification\/tutorial\/ms-excel-interface-and-moving-in-a-worksheet-2\/#primaryimage"},"thumbnailUrl":"http:\/\/www.vskills.in\/lms\/wp-content\/uploads\/2016\/05\/ms-excel-interface-and-moving-in-a-worksheet.jpg","datePublished":"2021-03-16T12:01:59+00:00","dateModified":"2024-04-12T09:01:48+00:00","breadcrumb":{"@id":"https:\/\/www.vskills.in\/certification\/tutorial\/ms-excel-interface-and-moving-in-a-worksheet-2\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.vskills.in\/certification\/tutorial\/ms-excel-interface-and-moving-in-a-worksheet-2\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.vskills.in\/certification\/tutorial\/ms-excel-interface-and-moving-in-a-worksheet-2\/#primaryimage","url":"http:\/\/www.vskills.in\/lms\/wp-content\/uploads\/2016\/05\/ms-excel-interface-and-moving-in-a-worksheet.jpg","contentUrl":"http:\/\/www.vskills.in\/lms\/wp-content\/uploads\/2016\/05\/ms-excel-interface-and-moving-in-a-worksheet.jpg"},{"@type":"BreadcrumbList","@id":"https:\/\/www.vskills.in\/certification\/tutorial\/ms-excel-interface-and-moving-in-a-worksheet-2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.vskills.in\/certification\/tutorial\/"},{"@type":"ListItem","position":2,"name":"MS-Excel Interface and Moving in a worksheet"}]},{"@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\/112219","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=112219"}],"version-history":[{"count":1,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/pages\/112219\/revisions"}],"predecessor-version":[{"id":112220,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/pages\/112219\/revisions\/112220"}],"wp:attachment":[{"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/media?parent=112219"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/categories?post=112219"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/tags?post=112219"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}