How To Use A Spreadsheet
Short Description
case lets you know that Excel recognizes your input by changing it to upper case. “PI()” is an Excel. function for the value 3.14159… Thus in the formula …
Website: www.whitman.edu | Filesize: 966kb
Content
How To Use A Spreadsheet
Excel?for the Mac and PC-Windows
by John D. Winter
Most good spreadsheets have very similar capabilities, but the syntax of the commands differs slightly.
I will use the keyboard command and mouse syntax of Excel?by Microsoft for this example. I am
assuming you have a mouse. In what follows, what you enter on the keyboard will be in bold. Special
keys, like the key labeled “Enter” will be written as:
Let’s suppose you have a number of data points such as data on a series of cylinders. You want to
perform some statistical analysis, perhaps to find the sum, mean and standard deviation of the various
data sets. The first step is to set up the organization of the rows and/or columns. Perhaps you decide to
list the rows as the separate measurements, and the columns as your measurements on each as follows:
Row 1 contains the titles of the columns as text. Each box in which you enter something is called a
“cell”. Excel recognizes the data in a cell as you type it in as either…
Get the file Download here
Related Searches: john d winter, keyboard command, excel function, menu options, standard deviation
Comments
Leave a Reply
