Here are answers to some questions I’ve been asked about Lab-3
“In lab 3, should we convert all the measurements to SI units or can we use them the way they are?”
- Please work in US (Imperial) units. A good guide would be to use the same units that Prof. Dasaro used in his lecture example.
“Is it necessary to 'name' each data cell? I have found that for this lab it makes it somewhat difficult, since each name is specific to to one cell, and we have many cells throughout the lab referring to the same data.”
- If you reuse the same named cell you can just insert its name. If, for instance, you’ve named cell A3 “Kinetic_Energy”, then if you want that value to appear in cell g5 (on the same or another sheet) all you need to do is put in that cell ‘=Kinetic_Energy’ and the value from A3 will appear. You can use that name in formulas just as easily.
- Note that if you start typing Excel will offer a list that includes your named variable. In this case, just typing ‘=k’ will produce a list of two items, the first of which is Kinetic_Energy. With the item you want selected hit the Tab key and that value will be entered.
- You are not required to use named variables in this exercise. I just recommend it. It’s an easy way to generate the required display formula by creating the actual formula and then copying everything but the “=” sign and pasting it in a cell beginning with an apostrophe.
Jim Mitchell
No comments:
Post a Comment