{"id":201,"date":"2022-12-01T20:31:32","date_gmt":"2022-12-01T20:31:32","guid":{"rendered":"https:\/\/courses.lumenlearning.com\/suny-compappmgr\/chapter\/entering-data\/"},"modified":"2022-12-01T20:31:32","modified_gmt":"2022-12-01T20:31:32","slug":"entering-data","status":"publish","type":"chapter","link":"https:\/\/courses.lumenlearning.com\/suny-compappmgr\/chapter\/entering-data\/","title":{"raw":"Entering Data","rendered":"Entering Data"},"content":{"raw":"\n<div class=\"textbox learning-objectives\">\n<h3>Learning Outcomes<\/h3>\n<ul>\n \t<li>Add data to a table.<\/li>\n<\/ul>\n<\/div>\nExcel workbooks are used to organize data very clearly. Numerical data can be used in a variety of ways, some of which we will examine in later modules. The first step, however, is simply to enter data into a table.\n\nFirst, open a blank workbook. Next, click on the first cell for your data: this will almost always be A1.\n\n<a href=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/1844\/2017\/06\/28222501\/enterdata1.png\"><img class=\"aligncenter wp-image-994\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/1844\/2017\/06\/28222501\/enterdata1.png\" alt=\"A blank Microsoft Excel sheet is open. There is a green box surrounding the first cell which is A1.\" width=\"800\" height=\"598\"><\/a>\n\nIf you wish to organize your data in a column, you will hit ENTER to move to the next cell down. In this case, A2.\n\n<a href=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/1844\/2017\/06\/28222626\/enterdata2.png\"><img class=\"aligncenter wp-image-995\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/1844\/2017\/06\/28222626\/enterdata2.png\" alt=\"A blank Microsoft Excel sheet is open. There is a green pointing downward signaling a transition of rows from cell A1 to cell A2.\" width=\"800\" height=\"598\"><\/a>\n\nIf you wish to organize your data in a row, you will hit the Tab key to move to the next cell over. In this case, the next cell over is B1.\n\n<a href=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/1844\/2017\/06\/28223227\/enterdata3.png\"><img class=\"aligncenter wp-image-997\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/1844\/2017\/06\/28223227\/enterdata3.png\" alt=\"A blank Microsoft Excel sheet is open. There is a green arrow pointing to the right indicating moving columns from A1 to B1.\" width=\"800\" height=\"597\"><\/a>\n\nEnter all of your data into each individual cell until you are ready to save your workbook.\n<div class=\"textbox tryit\">\n<h3>Practice Question<\/h3>\nhttps:\/\/assess.lumenlearning.com\/practice\/ebe75b76-c1d8-4ffa-8051-40cc8783a61b\n\nhttps:\/\/assess.lumenlearning.com\/practice\/ab7e8b44-ab21-457b-a119-8a1a625c8205\n\n<\/div>\n<h2>Contribute!<\/h2><div style=\"margin-bottom: 8px;\">Did you have an idea for improving this content? We\u2019d love your input.<\/div><a href=\"https:\/\/docs.google.com\/document\/d\/1mo_Effh7GaD7wh3ZVh_6TO6hg_YWyl-2jbS0qdd3TN8\" target=\"_blank\" style=\"font-size: 10pt; font-weight: 600; color: #077fab; text-decoration: none; border: 2px solid #077fab; border-radius: 7px; padding: 5px 25px; text-align: center; cursor: pointer; line-height: 1.5em;\">Improve this page<\/a><a style=\"margin-left: 16px;\" target=\"_blank\" href=\"https:\/\/docs.google.com\/document\/d\/1vy-T6DtTF-BbMfpVEI7VP_R7w2A4anzYZLXR8Pk4Fu4\">Learn More<\/a>\n","rendered":"<div class=\"textbox learning-objectives\">\n<h3>Learning Outcomes<\/h3>\n<ul>\n<li>Add data to a table.<\/li>\n<\/ul>\n<\/div>\n<p>Excel workbooks are used to organize data very clearly. Numerical data can be used in a variety of ways, some of which we will examine in later modules. The first step, however, is simply to enter data into a table.<\/p>\n<p>First, open a blank workbook. Next, click on the first cell for your data: this will almost always be A1.<\/p>\n<p><a href=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/1844\/2017\/06\/28222501\/enterdata1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-994\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/1844\/2017\/06\/28222501\/enterdata1.png\" alt=\"A blank Microsoft Excel sheet is open. There is a green box surrounding the first cell which is A1.\" width=\"800\" height=\"598\" \/><\/a><\/p>\n<p>If you wish to organize your data in a column, you will hit ENTER to move to the next cell down. In this case, A2.<\/p>\n<p><a href=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/1844\/2017\/06\/28222626\/enterdata2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-995\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/1844\/2017\/06\/28222626\/enterdata2.png\" alt=\"A blank Microsoft Excel sheet is open. There is a green pointing downward signaling a transition of rows from cell A1 to cell A2.\" width=\"800\" height=\"598\" \/><\/a><\/p>\n<p>If you wish to organize your data in a row, you will hit the Tab key to move to the next cell over. In this case, the next cell over is B1.<\/p>\n<p><a href=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/1844\/2017\/06\/28223227\/enterdata3.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-997\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/1844\/2017\/06\/28223227\/enterdata3.png\" alt=\"A blank Microsoft Excel sheet is open. There is a green arrow pointing to the right indicating moving columns from A1 to B1.\" width=\"800\" height=\"597\" \/><\/a><\/p>\n<p>Enter all of your data into each individual cell until you are ready to save your workbook.<\/p>\n<div class=\"textbox tryit\">\n<h3>Practice Question<\/h3>\n<p>\t<iframe id=\"assessment_practice_ebe75b76-c1d8-4ffa-8051-40cc8783a61b\" class=\"resizable\" src=\"https:\/\/assess.lumenlearning.com\/practice\/ebe75b76-c1d8-4ffa-8051-40cc8783a61b?iframe_resize_id=assessment_practice_id_ebe75b76-c1d8-4ffa-8051-40cc8783a61b\" frameborder=\"0\" style=\"border:none;width:100%;height:100%;min-height:300px;\"><br \/>\n\t<\/iframe><\/p>\n<p>\t<iframe id=\"assessment_practice_ab7e8b44-ab21-457b-a119-8a1a625c8205\" class=\"resizable\" src=\"https:\/\/assess.lumenlearning.com\/practice\/ab7e8b44-ab21-457b-a119-8a1a625c8205?iframe_resize_id=assessment_practice_id_ab7e8b44-ab21-457b-a119-8a1a625c8205\" frameborder=\"0\" style=\"border:none;width:100%;height:100%;min-height:300px;\"><br \/>\n\t<\/iframe><\/p>\n<\/div>\n<h2>Contribute!<\/h2>\n<div style=\"margin-bottom: 8px;\">Did you have an idea for improving this content? We\u2019d love your input.<\/div>\n<p><a href=\"https:\/\/docs.google.com\/document\/d\/1mo_Effh7GaD7wh3ZVh_6TO6hg_YWyl-2jbS0qdd3TN8\" target=\"_blank\" style=\"font-size: 10pt; font-weight: 600; color: #077fab; text-decoration: none; border: 2px solid #077fab; border-radius: 7px; padding: 5px 25px; text-align: center; cursor: pointer; line-height: 1.5em;\">Improve this page<\/a><a style=\"margin-left: 16px;\" target=\"_blank\" href=\"https:\/\/docs.google.com\/document\/d\/1vy-T6DtTF-BbMfpVEI7VP_R7w2A4anzYZLXR8Pk4Fu4\">Learn More<\/a><\/p>\n\n\t\t\t <section class=\"citations-section\" role=\"contentinfo\">\n\t\t\t <h3>Candela Citations<\/h3>\n\t\t\t\t\t <div>\n\t\t\t\t\t\t <div id=\"citation-list-201\">\n\t\t\t\t\t\t\t <div class=\"licensing\"><div class=\"license-attribution-dropdown-subheading\">CC licensed content, Original<\/div><ul class=\"citation-list\"><li>Enter Data into a Table. <strong>Authored by<\/strong>: Shelli Carter. <strong>Provided by<\/strong>: Lumen Learning. <strong>License<\/strong>: <em><a target=\"_blank\" rel=\"license\" href=\"https:\/\/creativecommons.org\/licenses\/by\/4.0\/\">CC BY: Attribution<\/a><\/em><\/li><\/ul><\/div>\n\t\t\t\t\t\t <\/div>\n\t\t\t\t\t <\/div>\n\t\t\t <\/section>","protected":false},"author":503070,"menu_order":4,"template":"","meta":{"_candela_citation":"[{\"type\":\"original\",\"description\":\"Enter Data into a Table\",\"author\":\"Shelli Carter\",\"organization\":\"Lumen Learning\",\"url\":\"\",\"project\":\"\",\"license\":\"cc-by\",\"license_terms\":\"\"}]","CANDELA_OUTCOMES_GUID":"d6c3a08b-d223-46c1-a4ee-4981647b40af, 5b3fd20e-0885-4a5d-ad31-0ff9fd7302dc","pb_show_title":"on","pb_short_title":"","pb_subtitle":"","pb_authors":[],"pb_section_license":""},"chapter-type":[],"contributor":[],"license":[],"class_list":["post-201","chapter","type-chapter","status-publish","hentry"],"part":197,"_links":{"self":[{"href":"https:\/\/courses.lumenlearning.com\/suny-compappmgr\/wp-json\/pressbooks\/v2\/chapters\/201","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/courses.lumenlearning.com\/suny-compappmgr\/wp-json\/pressbooks\/v2\/chapters"}],"about":[{"href":"https:\/\/courses.lumenlearning.com\/suny-compappmgr\/wp-json\/wp\/v2\/types\/chapter"}],"author":[{"embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/suny-compappmgr\/wp-json\/wp\/v2\/users\/503070"}],"version-history":[{"count":0,"href":"https:\/\/courses.lumenlearning.com\/suny-compappmgr\/wp-json\/pressbooks\/v2\/chapters\/201\/revisions"}],"part":[{"href":"https:\/\/courses.lumenlearning.com\/suny-compappmgr\/wp-json\/pressbooks\/v2\/parts\/197"}],"metadata":[{"href":"https:\/\/courses.lumenlearning.com\/suny-compappmgr\/wp-json\/pressbooks\/v2\/chapters\/201\/metadata\/"}],"wp:attachment":[{"href":"https:\/\/courses.lumenlearning.com\/suny-compappmgr\/wp-json\/wp\/v2\/media?parent=201"}],"wp:term":[{"taxonomy":"chapter-type","embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/suny-compappmgr\/wp-json\/pressbooks\/v2\/chapter-type?post=201"},{"taxonomy":"contributor","embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/suny-compappmgr\/wp-json\/wp\/v2\/contributor?post=201"},{"taxonomy":"license","embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/suny-compappmgr\/wp-json\/wp\/v2\/license?post=201"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}