{"id":992,"date":"2017-06-28T22:33:47","date_gmt":"2017-06-28T22:33:47","guid":{"rendered":"https:\/\/courses.lumenlearning.com\/wm-compapp\/?post_type=chapter&#038;p=992"},"modified":"2024-05-16T19:07:50","modified_gmt":"2024-05-16T19:07:50","slug":"entering-data","status":"publish","type":"chapter","link":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/chapter\/entering-data\/","title":{"raw":"Entering Data","rendered":"Entering Data"},"content":{"raw":"<div class=\"textbox learning-objectives\">\r\n<h3>Learning Outcomes<\/h3>\r\n<ul>\r\n \t<li>Add data to a table.<\/li>\r\n<\/ul>\r\n<\/div>\r\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.\r\n\r\nFirst, open a blank workbook. Next, click on the first cell for your data: this will almost always be A1.\r\n\r\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>\r\n\r\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.\r\n\r\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>\r\n\r\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.\r\n\r\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>\r\n\r\nEnter all of your data into each individual cell until you are ready to save your workbook.\r\n\r\nJust as with word processing, when using spreadsheets, there are different file types as well.\u00a0The default file type is <strong>.xlsx<\/strong> (Excel Workbook).\u00a0For example, in the screenshot below, inputting a file name of Book1 and saving with the default file type of Excel Workbook would result in a file that is named\u00a0<strong>Book1.xlsx<\/strong>. Note that you do not type in the file extension as part of the file name.\r\n\r\n<img class=\"aligncenter wp-image-5693 size-full\" src=\"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-content\/uploads\/sites\/5695\/2017\/06\/Screenshot-2023-10-25-145235.jpg\" alt=\"A dropdown menu in Microsoft Excel showing a &quot;Save As&quot; dialog box. The &quot;Save as type&quot; file format options listed include Excel Workbook, Excel Macro-Enabled Workbook, Excel Binary Workbook, Excel 97-2003 Workbook, XML Data, Single File Web Page, Web Page, Excel Template, Excel Macro-Enabled Template, Excel 97-2003 Template, Text (Tab delimited), Unicode Text, XML Spreadsheet 2003, Microsoft Excel 5.0\/95 Workbook, CSV (Comma delimited), Formatted Text (Space delimited), Text (MS-DOS), CSV (Macintosh), CSV (MS-DOS), DIF (Data Interchange Format), SYLK (Symbolic Link), Excel Add-In, Excel 97-2003 Add-In, PDF, XPS Document, Strict Open XML Spreadsheet, and OpenDocument Spreadsheet. The file name is set to &quot;Book1&quot;. On the left side of the window, there's an option to &quot;Hide Folders&quot;.\" width=\"940\" height=\"636\" \/>\r\n<div class=\"textbox tryit\">\r\n<h3>Practice Question<\/h3>\r\nhttps:\/\/assess.lumenlearning.com\/practice\/ebe75b76-c1d8-4ffa-8051-40cc8783a61b\r\n\r\nhttps:\/\/assess.lumenlearning.com\/practice\/ab7e8b44-ab21-457b-a119-8a1a625c8205\r\n\r\n<\/div>","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<p>Just as with word processing, when using spreadsheets, there are different file types as well.\u00a0The default file type is <strong>.xlsx<\/strong> (Excel Workbook).\u00a0For example, in the screenshot below, inputting a file name of Book1 and saving with the default file type of Excel Workbook would result in a file that is named\u00a0<strong>Book1.xlsx<\/strong>. Note that you do not type in the file extension as part of the file name.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-5693 size-full\" src=\"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-content\/uploads\/sites\/5695\/2017\/06\/Screenshot-2023-10-25-145235.jpg\" alt=\"A dropdown menu in Microsoft Excel showing a &quot;Save As&quot; dialog box. The &quot;Save as type&quot; file format options listed include Excel Workbook, Excel Macro-Enabled Workbook, Excel Binary Workbook, Excel 97-2003 Workbook, XML Data, Single File Web Page, Web Page, Excel Template, Excel Macro-Enabled Template, Excel 97-2003 Template, Text (Tab delimited), Unicode Text, XML Spreadsheet 2003, Microsoft Excel 5.0\/95 Workbook, CSV (Comma delimited), Formatted Text (Space delimited), Text (MS-DOS), CSV (Macintosh), CSV (MS-DOS), DIF (Data Interchange Format), SYLK (Symbolic Link), Excel Add-In, Excel 97-2003 Add-In, PDF, XPS Document, Strict Open XML Spreadsheet, and OpenDocument Spreadsheet. The file name is set to &quot;Book1&quot;. On the left side of the window, there's an option to &quot;Hide Folders&quot;.\" width=\"940\" height=\"636\" srcset=\"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-content\/uploads\/sites\/5695\/2017\/06\/Screenshot-2023-10-25-145235.jpg 940w, https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-content\/uploads\/sites\/5695\/2017\/06\/Screenshot-2023-10-25-145235-300x203.jpg 300w, https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-content\/uploads\/sites\/5695\/2017\/06\/Screenshot-2023-10-25-145235-768x520.jpg 768w, https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-content\/uploads\/sites\/5695\/2017\/06\/Screenshot-2023-10-25-145235-65x44.jpg 65w, https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-content\/uploads\/sites\/5695\/2017\/06\/Screenshot-2023-10-25-145235-225x152.jpg 225w, https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-content\/uploads\/sites\/5695\/2017\/06\/Screenshot-2023-10-25-145235-350x237.jpg 350w\" sizes=\"auto, (max-width: 940px) 100vw, 940px\" \/><\/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\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-992\">\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":20,"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-992","chapter","type-chapter","status-publish","hentry"],"part":975,"_links":{"self":[{"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/pressbooks\/v2\/chapters\/992","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/pressbooks\/v2\/chapters"}],"about":[{"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/wp\/v2\/types\/chapter"}],"author":[{"embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/wp\/v2\/users\/20"}],"version-history":[{"count":20,"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/pressbooks\/v2\/chapters\/992\/revisions"}],"predecessor-version":[{"id":5807,"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/pressbooks\/v2\/chapters\/992\/revisions\/5807"}],"part":[{"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/pressbooks\/v2\/parts\/975"}],"metadata":[{"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/pressbooks\/v2\/chapters\/992\/metadata\/"}],"wp:attachment":[{"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/wp\/v2\/media?parent=992"}],"wp:term":[{"taxonomy":"chapter-type","embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/pressbooks\/v2\/chapter-type?post=992"},{"taxonomy":"contributor","embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/wp\/v2\/contributor?post=992"},{"taxonomy":"license","embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/wp\/v2\/license?post=992"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}