{"id":46,"date":"2023-05-18T08:27:33","date_gmt":"2023-05-18T12:27:33","guid":{"rendered":"https:\/\/pressbooks.library.upei.ca\/bio3310\/chapter\/part-1-spreadsheet-basics-2\/"},"modified":"2024-08-01T09:10:46","modified_gmt":"2024-08-01T13:10:46","slug":"part-1-spreadsheet-basics-2","status":"publish","type":"chapter","link":"https:\/\/pressbooks.library.upei.ca\/bio3310\/chapter\/part-1-spreadsheet-basics-2\/","title":{"raw":"Part 1: Spreadsheet Basics","rendered":"Part 1: Spreadsheet Basics"},"content":{"raw":"<div class=\"part-1:-spreadsheet-basics\">\r\n<h1 class=\"import-BodyText\" style=\"margin-left: 18pt;margin-right: 21.25pt\">Spreadsheet Basics in Excel<\/h1>\r\n<p class=\"import-BodyText\" style=\"margin-left: 18pt;margin-right: 21.25pt\">Remember that the main strength of spreadsheet programs is to manipulate numbers. If you know how to do something in one program, you can be pretty sure that the same options are available in the other program, but it may not be called the same thing. So we\u2019ll run through some of the main options Excel to give you some idea of how to use some of these options.<\/p>\r\n\r\n<h2 class=\"import-BodyText\" style=\"margin-left: 18pt;margin-right: 21.25pt\">Data manipulations<\/h2>\r\n<p class=\"import-BodyText\" style=\"margin-left: 18pt;margin-right: 21.25pt\">Most of the examples in this guide refer to a dataset on your Moodle site called the \u201cpulses\u201d dataset. It consists of sample data from a study where a researcher had his class take their pulse rate to give a \u201cbaseline\u201d value, then part of the class ran in place for one minute, and the class members took their pulse rates again. After the experiment, the researcher asked the students what their normal activity level was, whether they smoked, what sex they were, and what their height and weight were. This gives us a useful dataset to evaluate a number of different techniques, and if you want, you can try out these methods to make sure you understand how to do them.<\/p>\r\n<p class=\"import-BodyText\" style=\"margin-left: 18pt;margin-right: 21.25pt\">If you open your \u201cpulses\u201d dataset, your excel spreadsheet should look like the one given below.<\/p>\r\n<p class=\"import-Normal\" style=\"margin-left: 18pt\"><img src=\"http:\/\/pressbooks.library.upei.ca\/bio3310\/wp-content\/uploads\/sites\/94\/2023\/05\/image4.jpeg\" alt=\"image\" width=\"678.666666666667px\" height=\"424px\" \/><\/p>\r\n\r\n<h2>Sorting Data<\/h2>\r\nThe ability to sort the data is one of the most useful data manipulations available with a spreadsheet.\r\n\r\nFor this example, we\u2019ll use the \u201cpulses dataset\u201d available on your disk.\r\n\r\n<strong>Method:<\/strong>\r\n<ul>\r\n \t<li class=\"import-BodyText\">Open the pulses dataset. Depending on how your data are set up, you may need to use the mouse to select the data you would like to sort (if you don\u2019t highlight the data first, the program will highlight all of your data, including headers and any notes you might have).\r\n<ul>\r\n \t<li class=\"import-BodyText\"><strong>Important:<\/strong> be sure <strong>all<\/strong> data columns in your dataset are highlighted or selected. Otherwise you will only sort the selected columns, and your other data may get out of synchrony with the new sorted data.<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<ul>\r\n \t<li class=\"import-BodyText\">Click on the \u201cData\u201d tab at the top, and then choose the \u201cSort\u201d icon. Click on it to open the sort window<\/li>\r\n \t<li class=\"import-Normal\">Click on the small arrow beside \u201csort by\u201d and a drop down menu showing your column titles (A, B, C....). \u2013 Choose the Column that you wish to sort by (for example, if we wished to sort by whether they smoked or not, we would choose column D). If you check the box for \u201cmy data has headers\u201d then you will see the heading names instead of the column letter<\/li>\r\n<\/ul>\r\nNotice at the top left of the Sort window... there is a box to \u201c<strong>add<\/strong> <strong>level<\/strong>\u201d. You would use this if you wanted to be able to sort by more than one category. For example, if I wanted to sort so the runners came first, and then the non-runners, but I also wanted to sort the smokers within each running group, I\u2019d do it by specifying a second level. First choose column C, then click on Add Level. This adds a second level for your sorting, and you can specify column D. Finally, for each level, choose whether you want ascending (lowest to highest) or descending numbers.\r\n<ul>\r\n \t<li class=\"import-BodyText\"><strong>C<\/strong><strong>lick<\/strong> <strong>ok.<\/strong> Your data should now be sorted.<\/li>\r\n<\/ul>\r\n<h2><a id=\"_Toc135219862\"><\/a>Arithmetic Functions<\/h2>\r\nA major strength of spreadsheets is the ability to do repetitive arithmetic functions easily<em>.<\/em>\r\n\r\nHow to access the arithmetic functions in Excel:\r\n<ul>\r\n \t<li class=\"import-BodyText\">Click on the Formulas tab, and look for the 3 symbol in the Excel property bar. Notice the small arrow beneath the 3 key... click on that to get the most common arithmetic functions, then choose \u201cmore functions\u201d to get into any additional ones you may need.\r\n<ul>\r\n \t<li class=\"import-BodyText\">Hint: if you want to sum other columns now, you can just copy the arithmetic function (=SUM...) from your first column and paste it into the same cell for other columns. The computer will automatically adjust the column letters, so that you get the sum of the appropriate column.<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<h3><a id=\"_Toc135219863\"><\/a><strong><span class=\"import-Heading3Char\">Sums<\/span><\/strong><\/h3>\r\n<ul>\r\n \t<li>To sum all the values in a column or row, simply place your cursor in a blank space at the end of a row or column and click on the auto-sum key. Then hit the Enter key, to get your value.<\/li>\r\n \t<li>To sum the numbers in only part of the column or row, highlight the numbers you want summed before clicking on the sum key.<\/li>\r\n<\/ul>\r\n<h2><a id=\"_Toc135219864\"><\/a><span class=\"import-Heading3Char\">Averages<\/span><\/h2>\r\n<img src=\"http:\/\/pressbooks.library.upei.ca\/bio3310\/wp-content\/uploads\/sites\/94\/2023\/05\/image9.jpeg\" alt=\"image\" width=\"360.066666666667px\" height=\"237.133333333333px\" \/>\r\n<ul>\r\n \t<li class=\"import-BodyText\">Click on the small arrow below the 3 key on the property bar, and choose \u201caverage\u201d from the drop-down menu.\r\n<ul>\r\n \t<li class=\"import-BodyText\">Hint.... you can do this calculation for multiple columns, by copying and pasting the formula into an adjoining cell.\r\nTo obtain an average for an entire column or row, simply place your cursor on a blank cell at the end of the row or column, then click on <strong>average<\/strong> from the autosum drop down menu.<\/li>\r\n<\/ul>\r\n<\/li>\r\n \t<li class=\"import-BodyText\">To obtain an average for a subset of values, highlight the values before clicking on \u201caverage\u201d.<\/li>\r\n<\/ul>\r\n<h3><a id=\"_Toc135219865\"><\/a><span class=\"import-Heading3Char\">Other statistical functions<\/span><\/h3>\r\n<ul>\r\n \t<li>First place your cursor on an empty cell at the bottom of the column or to the right of the row you want analysed.<\/li>\r\n \t<li>Now access the other functions by clicking on the small arrow below the <strong>3<\/strong> icon on the functions tab of the property bar, and clicking on \u201c<strong>more<\/strong> <strong>functions<\/strong>\u201d from the drop-down menu to get the <strong>Insert<\/strong> <strong>Function<\/strong> box<\/li>\r\n \t<li>You can type in a brief description of what you would like to do (e.g. \u201cFind the median\u201d), or you can select a function category.\r\n<ul>\r\n \t<li>If you click on the \u201cselect a category\u201d window, you\u2019ll see a listing of the different categories available<\/li>\r\n<\/ul>\r\n<\/li>\r\n \t<li>For the statistical functions, click on \u201cstatistical\u201d, and choose from the listing.\r\n<ul>\r\n \t<li><strong>e.g.<\/strong> <strong>standard<\/strong> <strong>deviation<\/strong> of the mean for Column F of our pulses dataset<\/li>\r\n \t<li>click on an empty cell and choose STDEV.S from the statistical list. In the \u201c<strong>function<\/strong> <strong>arguments<\/strong>\u201d dialogue box, choose the data you want to analyse.<\/li>\r\n \t<li>If you don\u2019t do anything else, it will calculate the value for all the numbers in the column.<\/li>\r\n<\/ul>\r\n<\/li>\r\n \t<li class=\"import-BodyText\"><strong>For<\/strong> <strong>a<\/strong> <strong>subset<\/strong> <strong>of<\/strong> <strong>the<\/strong> <strong>column<\/strong> (or a different column), either type in the values in the window, or click on the small box to the right of the <strong>Number<\/strong> <strong>1<\/strong> window to return to the spreadsheet and highlight your values.\r\n<ul>\r\n \t<li class=\"import-BodyText\">After highlighting your values, maximize (little box at the right) to return to the function arguments dialogue box, and click OK.<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<h3><a id=\"_Toc135219867\"><\/a>Typing in your own formulas<\/h3>\r\n<p class=\"import-BodyText\" style=\"margin-left: 18pt;margin-right: 8.6pt\">We often want to be able to type in our own formulas, to be able to multiply an entire row or column by a number, or to transform an entire set of data. For this, simply click on a blank cell, then go to the <em>f<\/em><em>X<\/em> window. Instead of selecting a pre-programmed formula, type in your own using the column letters and row numbers, preceded by an equal sign (=).<\/p>\r\n<p class=\"import-Normal\" style=\"margin-left: 18pt;margin-right: 342.3pt\"><strong>e.g.<\/strong> <strong>multiply<\/strong> <strong>every<\/strong> <strong>value<\/strong> <strong>in<\/strong> <strong>our<\/strong> <strong>column<\/strong> <strong>G<\/strong> <strong>by<\/strong> <strong>2,<\/strong> <strong>and<\/strong> <strong>have<\/strong> <strong>the<\/strong> <strong>new<\/strong> <strong>number<\/strong> <strong>appear<\/strong> <strong>in<\/strong> <strong>column<\/strong> <strong>i<\/strong><\/p>\r\n\r\n<ul>\r\n \t<li class=\"import-BodyText\" style=\"text-indent: 0pt\">Place your cursor on the empty cell in column i next to the first value in column G... in our pulses dataset, it will be on row 3. The designation for that cell is I3.\r\n<ul>\r\n \t<li class=\"import-BodyText\" style=\"text-indent: 0pt\">Note: new versions of Excel are not as picky about placing brackets around cell labels.<\/li>\r\n<\/ul>\r\n<\/li>\r\n \t<li class=\"import-BodyText\" style=\"text-indent: 0pt\">We want to get column G values, though, so we type in = (G3)*2\r\n<ul>\r\n \t<li class=\"import-BodyText\" style=\"text-indent: 0pt\">Press enter, to get the value, which is 280.<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<p class=\"import-Normal\" style=\"margin-left: 18pt\">Hint: You can copy that formula cell and paste it into the cells below, rather than re-typing the formula. A quick version of this is to drag the small square beside the formula cell downward to highlight cells below, which will copy the formula.<\/p>\r\n\r\n<h3><a id=\"_Toc135219869\"><\/a>Converting from formulas to values:<\/h3>\r\n<p class=\"import-BodyText\" style=\"margin-left: 18pt;margin-right: 259.25pt;text-indent: 0pt\">The calculated values that you have created are arithmetic formulas, so when you try to copy them into another sheet or program, you may get an error message. You can convert them to number values (rather than formulas when you copy and paste.<\/p>\r\n<p class=\"import-BodyText\" style=\"margin-left: 18pt;margin-right: 244.6pt\"><strong><em>Method:<\/em><\/strong> copy your cell(s) that you want values for, then click on an empty cell where you would like to paste the data. Right-click on that cell or cells, to get the paste menu. Choose the one that shows <strong>123<\/strong> and your selection will be pasted as values.<\/p>\r\n\r\n<h2>Quick tips:<\/h2>\r\n<strong>Typing<\/strong> <strong>in<\/strong> <strong>series<\/strong> <strong>of<\/strong> <strong>numbers<\/strong>: If your numbers go up by a standard progression, such as 1,2,3,4,... or 2,4,6,8... etc., you can try this trick rather than typing them all in.\r\n<ul>\r\n \t<li class=\"import-BodyText\">Start typing your numbers in the column<\/li>\r\n \t<li class=\"import-BodyText\">Highlight your numbers in the column, then look for the small box at the lower right of the last number you\u2019ve typed in the series<\/li>\r\n<\/ul>\r\n<img src=\"http:\/\/pressbooks.library.upei.ca\/bio3310\/wp-content\/uploads\/sites\/94\/2023\/05\/image23.png\" alt=\"image\" width=\"99.0666666666667px\" height=\"176.066666666667px\" \/>\r\n<ul>\r\n \t<li>Place your cursor on that box so that the cursor marker turns into a small cross (+)<\/li>\r\n \t<li>Drag that cross down the column and excel will fill in the next numbers in your series<\/li>\r\n<\/ul>\r\n<strong>\u201cLocking\u201d<\/strong> <strong>or<\/strong> <strong>\u201cfreezing\u201d<\/strong> <strong>a<\/strong> <strong>heading<\/strong> <strong>in<\/strong> <strong>place<\/strong> <strong>so<\/strong> <strong>you<\/strong> <strong>can<\/strong> <strong>scroll<\/strong> <strong>through<\/strong> <strong>your<\/strong> <strong>document<\/strong> <strong>without<\/strong> <strong>losing<\/strong> <strong>your<\/strong> <strong>headings<\/strong> <strong>or<\/strong> <strong>row<\/strong> <strong>titles:<\/strong>\r\n<ul>\r\n \t<li class=\"import-BodyText\">Click on the \u201cview\u201d tab<\/li>\r\n \t<li class=\"import-BodyText\">Click on the \u201cfreeze panes\u201d drop-down menu<\/li>\r\n \t<li class=\"import-BodyText\">Choose which parts of the data set you want to \u201cfreeze\u201d and click on that<\/li>\r\n<\/ul>\r\n<strong>Copying<\/strong> <strong>and<\/strong> <strong>pasting<\/strong> <strong>formula<\/strong> <strong>cells<\/strong>\r\n<p class=\"import-BodyText\" style=\"margin-left: 18pt;margin-right: 20.2pt\">If you need to take the average or apply a formula to multiple rows or columns of data, you do not need to type it in for every case. If you copy and paste it over a number of cells, Excel automatically advances the cell number for you so that your operation applies to the new cell. For examples, see the hints in the Arithmetic functions sections given in the previous pages.<\/p>\r\n<p class=\"import-Normal\"><\/p>\r\n\r\n<\/div>","rendered":"<div class=\"part-1:-spreadsheet-basics\">\n<h1 class=\"import-BodyText\" style=\"margin-left: 18pt;margin-right: 21.25pt\">Spreadsheet Basics in Excel<\/h1>\n<p class=\"import-BodyText\" style=\"margin-left: 18pt;margin-right: 21.25pt\">Remember that the main strength of spreadsheet programs is to manipulate numbers. If you know how to do something in one program, you can be pretty sure that the same options are available in the other program, but it may not be called the same thing. So we\u2019ll run through some of the main options Excel to give you some idea of how to use some of these options.<\/p>\n<h2 class=\"import-BodyText\" style=\"margin-left: 18pt;margin-right: 21.25pt\">Data manipulations<\/h2>\n<p class=\"import-BodyText\" style=\"margin-left: 18pt;margin-right: 21.25pt\">Most of the examples in this guide refer to a dataset on your Moodle site called the \u201cpulses\u201d dataset. It consists of sample data from a study where a researcher had his class take their pulse rate to give a \u201cbaseline\u201d value, then part of the class ran in place for one minute, and the class members took their pulse rates again. After the experiment, the researcher asked the students what their normal activity level was, whether they smoked, what sex they were, and what their height and weight were. This gives us a useful dataset to evaluate a number of different techniques, and if you want, you can try out these methods to make sure you understand how to do them.<\/p>\n<p class=\"import-BodyText\" style=\"margin-left: 18pt;margin-right: 21.25pt\">If you open your \u201cpulses\u201d dataset, your excel spreadsheet should look like the one given below.<\/p>\n<p class=\"import-Normal\" style=\"margin-left: 18pt\"><img decoding=\"async\" src=\"http:\/\/pressbooks.library.upei.ca\/bio3310\/wp-content\/uploads\/sites\/94\/2023\/05\/image4.jpeg\" alt=\"image\" width=\"678.666666666667px\" height=\"424px\" \/><\/p>\n<h2>Sorting Data<\/h2>\n<p>The ability to sort the data is one of the most useful data manipulations available with a spreadsheet.<\/p>\n<p>For this example, we\u2019ll use the \u201cpulses dataset\u201d available on your disk.<\/p>\n<p><strong>Method:<\/strong><\/p>\n<ul>\n<li class=\"import-BodyText\">Open the pulses dataset. Depending on how your data are set up, you may need to use the mouse to select the data you would like to sort (if you don\u2019t highlight the data first, the program will highlight all of your data, including headers and any notes you might have).\n<ul>\n<li class=\"import-BodyText\"><strong>Important:<\/strong> be sure <strong>all<\/strong> data columns in your dataset are highlighted or selected. Otherwise you will only sort the selected columns, and your other data may get out of synchrony with the new sorted data.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<ul>\n<li class=\"import-BodyText\">Click on the \u201cData\u201d tab at the top, and then choose the \u201cSort\u201d icon. Click on it to open the sort window<\/li>\n<li class=\"import-Normal\">Click on the small arrow beside \u201csort by\u201d and a drop down menu showing your column titles (A, B, C&#8230;.). \u2013 Choose the Column that you wish to sort by (for example, if we wished to sort by whether they smoked or not, we would choose column D). If you check the box for \u201cmy data has headers\u201d then you will see the heading names instead of the column letter<\/li>\n<\/ul>\n<p>Notice at the top left of the Sort window&#8230; there is a box to \u201c<strong>add<\/strong> <strong>level<\/strong>\u201d. You would use this if you wanted to be able to sort by more than one category. For example, if I wanted to sort so the runners came first, and then the non-runners, but I also wanted to sort the smokers within each running group, I\u2019d do it by specifying a second level. First choose column C, then click on Add Level. This adds a second level for your sorting, and you can specify column D. Finally, for each level, choose whether you want ascending (lowest to highest) or descending numbers.<\/p>\n<ul>\n<li class=\"import-BodyText\"><strong>C<\/strong><strong>lick<\/strong> <strong>ok.<\/strong> Your data should now be sorted.<\/li>\n<\/ul>\n<h2><a id=\"_Toc135219862\"><\/a>Arithmetic Functions<\/h2>\n<p>A major strength of spreadsheets is the ability to do repetitive arithmetic functions easily<em>.<\/em><\/p>\n<p>How to access the arithmetic functions in Excel:<\/p>\n<ul>\n<li class=\"import-BodyText\">Click on the Formulas tab, and look for the 3 symbol in the Excel property bar. Notice the small arrow beneath the 3 key&#8230; click on that to get the most common arithmetic functions, then choose \u201cmore functions\u201d to get into any additional ones you may need.\n<ul>\n<li class=\"import-BodyText\">Hint: if you want to sum other columns now, you can just copy the arithmetic function (=SUM&#8230;) from your first column and paste it into the same cell for other columns. The computer will automatically adjust the column letters, so that you get the sum of the appropriate column.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<h3><a id=\"_Toc135219863\"><\/a><strong><span class=\"import-Heading3Char\">Sums<\/span><\/strong><\/h3>\n<ul>\n<li>To sum all the values in a column or row, simply place your cursor in a blank space at the end of a row or column and click on the auto-sum key. Then hit the Enter key, to get your value.<\/li>\n<li>To sum the numbers in only part of the column or row, highlight the numbers you want summed before clicking on the sum key.<\/li>\n<\/ul>\n<h2><a id=\"_Toc135219864\"><\/a><span class=\"import-Heading3Char\">Averages<\/span><\/h2>\n<p><img decoding=\"async\" src=\"http:\/\/pressbooks.library.upei.ca\/bio3310\/wp-content\/uploads\/sites\/94\/2023\/05\/image9.jpeg\" alt=\"image\" width=\"360.066666666667px\" height=\"237.133333333333px\" \/><\/p>\n<ul>\n<li class=\"import-BodyText\">Click on the small arrow below the 3 key on the property bar, and choose \u201caverage\u201d from the drop-down menu.\n<ul>\n<li class=\"import-BodyText\">Hint&#8230;. you can do this calculation for multiple columns, by copying and pasting the formula into an adjoining cell.<br \/>\nTo obtain an average for an entire column or row, simply place your cursor on a blank cell at the end of the row or column, then click on <strong>average<\/strong> from the autosum drop down menu.<\/li>\n<\/ul>\n<\/li>\n<li class=\"import-BodyText\">To obtain an average for a subset of values, highlight the values before clicking on \u201caverage\u201d.<\/li>\n<\/ul>\n<h3><a id=\"_Toc135219865\"><\/a><span class=\"import-Heading3Char\">Other statistical functions<\/span><\/h3>\n<ul>\n<li>First place your cursor on an empty cell at the bottom of the column or to the right of the row you want analysed.<\/li>\n<li>Now access the other functions by clicking on the small arrow below the <strong>3<\/strong> icon on the functions tab of the property bar, and clicking on \u201c<strong>more<\/strong> <strong>functions<\/strong>\u201d from the drop-down menu to get the <strong>Insert<\/strong> <strong>Function<\/strong> box<\/li>\n<li>You can type in a brief description of what you would like to do (e.g. \u201cFind the median\u201d), or you can select a function category.\n<ul>\n<li>If you click on the \u201cselect a category\u201d window, you\u2019ll see a listing of the different categories available<\/li>\n<\/ul>\n<\/li>\n<li>For the statistical functions, click on \u201cstatistical\u201d, and choose from the listing.\n<ul>\n<li><strong>e.g.<\/strong> <strong>standard<\/strong> <strong>deviation<\/strong> of the mean for Column F of our pulses dataset<\/li>\n<li>click on an empty cell and choose STDEV.S from the statistical list. In the \u201c<strong>function<\/strong> <strong>arguments<\/strong>\u201d dialogue box, choose the data you want to analyse.<\/li>\n<li>If you don\u2019t do anything else, it will calculate the value for all the numbers in the column.<\/li>\n<\/ul>\n<\/li>\n<li class=\"import-BodyText\"><strong>For<\/strong> <strong>a<\/strong> <strong>subset<\/strong> <strong>of<\/strong> <strong>the<\/strong> <strong>column<\/strong> (or a different column), either type in the values in the window, or click on the small box to the right of the <strong>Number<\/strong> <strong>1<\/strong> window to return to the spreadsheet and highlight your values.\n<ul>\n<li class=\"import-BodyText\">After highlighting your values, maximize (little box at the right) to return to the function arguments dialogue box, and click OK.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<h3><a id=\"_Toc135219867\"><\/a>Typing in your own formulas<\/h3>\n<p class=\"import-BodyText\" style=\"margin-left: 18pt;margin-right: 8.6pt\">We often want to be able to type in our own formulas, to be able to multiply an entire row or column by a number, or to transform an entire set of data. For this, simply click on a blank cell, then go to the <em>f<\/em><em>X<\/em> window. Instead of selecting a pre-programmed formula, type in your own using the column letters and row numbers, preceded by an equal sign (=).<\/p>\n<p class=\"import-Normal\" style=\"margin-left: 18pt;margin-right: 342.3pt\"><strong>e.g.<\/strong> <strong>multiply<\/strong> <strong>every<\/strong> <strong>value<\/strong> <strong>in<\/strong> <strong>our<\/strong> <strong>column<\/strong> <strong>G<\/strong> <strong>by<\/strong> <strong>2,<\/strong> <strong>and<\/strong> <strong>have<\/strong> <strong>the<\/strong> <strong>new<\/strong> <strong>number<\/strong> <strong>appear<\/strong> <strong>in<\/strong> <strong>column<\/strong> <strong>i<\/strong><\/p>\n<ul>\n<li class=\"import-BodyText\" style=\"text-indent: 0pt\">Place your cursor on the empty cell in column i next to the first value in column G&#8230; in our pulses dataset, it will be on row 3. The designation for that cell is I3.\n<ul>\n<li class=\"import-BodyText\" style=\"text-indent: 0pt\">Note: new versions of Excel are not as picky about placing brackets around cell labels.<\/li>\n<\/ul>\n<\/li>\n<li class=\"import-BodyText\" style=\"text-indent: 0pt\">We want to get column G values, though, so we type in = (G3)*2\n<ul>\n<li class=\"import-BodyText\" style=\"text-indent: 0pt\">Press enter, to get the value, which is 280.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p class=\"import-Normal\" style=\"margin-left: 18pt\">Hint: You can copy that formula cell and paste it into the cells below, rather than re-typing the formula. A quick version of this is to drag the small square beside the formula cell downward to highlight cells below, which will copy the formula.<\/p>\n<h3><a id=\"_Toc135219869\"><\/a>Converting from formulas to values:<\/h3>\n<p class=\"import-BodyText\" style=\"margin-left: 18pt;margin-right: 259.25pt;text-indent: 0pt\">The calculated values that you have created are arithmetic formulas, so when you try to copy them into another sheet or program, you may get an error message. You can convert them to number values (rather than formulas when you copy and paste.<\/p>\n<p class=\"import-BodyText\" style=\"margin-left: 18pt;margin-right: 244.6pt\"><strong><em>Method:<\/em><\/strong> copy your cell(s) that you want values for, then click on an empty cell where you would like to paste the data. Right-click on that cell or cells, to get the paste menu. Choose the one that shows <strong>123<\/strong> and your selection will be pasted as values.<\/p>\n<h2>Quick tips:<\/h2>\n<p><strong>Typing<\/strong> <strong>in<\/strong> <strong>series<\/strong> <strong>of<\/strong> <strong>numbers<\/strong>: If your numbers go up by a standard progression, such as 1,2,3,4,&#8230; or 2,4,6,8&#8230; etc., you can try this trick rather than typing them all in.<\/p>\n<ul>\n<li class=\"import-BodyText\">Start typing your numbers in the column<\/li>\n<li class=\"import-BodyText\">Highlight your numbers in the column, then look for the small box at the lower right of the last number you\u2019ve typed in the series<\/li>\n<\/ul>\n<p><img decoding=\"async\" src=\"http:\/\/pressbooks.library.upei.ca\/bio3310\/wp-content\/uploads\/sites\/94\/2023\/05\/image23.png\" alt=\"image\" width=\"99.0666666666667px\" height=\"176.066666666667px\" \/><\/p>\n<ul>\n<li>Place your cursor on that box so that the cursor marker turns into a small cross (+)<\/li>\n<li>Drag that cross down the column and excel will fill in the next numbers in your series<\/li>\n<\/ul>\n<p><strong>\u201cLocking\u201d<\/strong> <strong>or<\/strong> <strong>\u201cfreezing\u201d<\/strong> <strong>a<\/strong> <strong>heading<\/strong> <strong>in<\/strong> <strong>place<\/strong> <strong>so<\/strong> <strong>you<\/strong> <strong>can<\/strong> <strong>scroll<\/strong> <strong>through<\/strong> <strong>your<\/strong> <strong>document<\/strong> <strong>without<\/strong> <strong>losing<\/strong> <strong>your<\/strong> <strong>headings<\/strong> <strong>or<\/strong> <strong>row<\/strong> <strong>titles:<\/strong><\/p>\n<ul>\n<li class=\"import-BodyText\">Click on the \u201cview\u201d tab<\/li>\n<li class=\"import-BodyText\">Click on the \u201cfreeze panes\u201d drop-down menu<\/li>\n<li class=\"import-BodyText\">Choose which parts of the data set you want to \u201cfreeze\u201d and click on that<\/li>\n<\/ul>\n<p><strong>Copying<\/strong> <strong>and<\/strong> <strong>pasting<\/strong> <strong>formula<\/strong> <strong>cells<\/strong><\/p>\n<p class=\"import-BodyText\" style=\"margin-left: 18pt;margin-right: 20.2pt\">If you need to take the average or apply a formula to multiple rows or columns of data, you do not need to type it in for every case. If you copy and paste it over a number of cells, Excel automatically advances the cell number for you so that your operation applies to the new cell. For examples, see the hints in the Arithmetic functions sections given in the previous pages.<\/p>\n<p class=\"import-Normal\">\n<\/div>\n","protected":false},"author":116,"menu_order":1,"template":"","meta":{"pb_show_title":"on","pb_short_title":"","pb_subtitle":"","pb_authors":[],"pb_section_license":""},"chapter-type":[],"contributor":[],"license":[],"class_list":["post-46","chapter","type-chapter","status-publish","hentry"],"part":3,"_links":{"self":[{"href":"https:\/\/pressbooks.library.upei.ca\/bio3310\/wp-json\/pressbooks\/v2\/chapters\/46","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/pressbooks.library.upei.ca\/bio3310\/wp-json\/pressbooks\/v2\/chapters"}],"about":[{"href":"https:\/\/pressbooks.library.upei.ca\/bio3310\/wp-json\/wp\/v2\/types\/chapter"}],"author":[{"embeddable":true,"href":"https:\/\/pressbooks.library.upei.ca\/bio3310\/wp-json\/wp\/v2\/users\/116"}],"version-history":[{"count":9,"href":"https:\/\/pressbooks.library.upei.ca\/bio3310\/wp-json\/pressbooks\/v2\/chapters\/46\/revisions"}],"predecessor-version":[{"id":313,"href":"https:\/\/pressbooks.library.upei.ca\/bio3310\/wp-json\/pressbooks\/v2\/chapters\/46\/revisions\/313"}],"part":[{"href":"https:\/\/pressbooks.library.upei.ca\/bio3310\/wp-json\/pressbooks\/v2\/parts\/3"}],"metadata":[{"href":"https:\/\/pressbooks.library.upei.ca\/bio3310\/wp-json\/pressbooks\/v2\/chapters\/46\/metadata\/"}],"wp:attachment":[{"href":"https:\/\/pressbooks.library.upei.ca\/bio3310\/wp-json\/wp\/v2\/media?parent=46"}],"wp:term":[{"taxonomy":"chapter-type","embeddable":true,"href":"https:\/\/pressbooks.library.upei.ca\/bio3310\/wp-json\/pressbooks\/v2\/chapter-type?post=46"},{"taxonomy":"contributor","embeddable":true,"href":"https:\/\/pressbooks.library.upei.ca\/bio3310\/wp-json\/wp\/v2\/contributor?post=46"},{"taxonomy":"license","embeddable":true,"href":"https:\/\/pressbooks.library.upei.ca\/bio3310\/wp-json\/wp\/v2\/license?post=46"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}