asfenshell.blogg.se

I can select the values and specify that they are numbers.

I think it looks cleaner for all of them to have the same number of decimal places. Some of my results have decimals and some don't. Then, if I click one of those cells, I can see which numbers it is using in its calculation. I can copy this formula and paste it into all the other cells in the table. I can start any calculation in a spreadsheet by typing the equals sign, then I just click on the cells I want to use so the first words per minute calculation will be "= A2/B2". Now I'm ready to calculate the words per minute for each typing test. If I want, I can put them all on either side or in the middle. You can see that words are aligned on the left side of the cell, and numbers are all pushed to the right. You can see some of my labels are too long for the cell, so I can resize them by hovering between two columns until I get a double-sided arrow, then I can click and drag to change the column's width. I can style the headers myself by making them bold or changing a font, or I can use a preset setting.Įither way, it's nice to draw attention to what I measured. I'll add a cell border so it's easier to see where my data is. My goal will be to calculate her typing speed in words per minute for each test.īefore I do the calculations, I'd like to style my data. I'll put the data from each of her tests in a new row, until they're all in the spreadsheet. In Row 2, I'll pick one of her typing tests and record the number of words she typed, in cell A2, and how long it took, in cell B2. In a spreadsheet, you always put each piece of data in its own cell, so I'll put the labels in different cells in the top row. My friend Sarah has been practicing her typing speed, and she's given me some data on her timed typing tests: how many words she typed, and how many minutes she had to type them in. A spreadsheet lets you organize data and calculations.