This preview shows pages 1–8. Sign up to view the full content.
This preview has intentionally blurred sections. Sign up to view the full version.
View Full DocumentThis preview has intentionally blurred sections. Sign up to view the full version.
View Full DocumentThis preview has intentionally blurred sections. Sign up to view the full version.
View Full DocumentThis preview has intentionally blurred sections. Sign up to view the full version.
View Full Document
Unformatted text preview: Section 3.8: Excel functions Excel 11 has available a number of useful engineering functions These are similar to the single result functions in C++ e.g. sin, cos, sqrt, etc. more expansive in number of functions possible relatively simple to use for mathematical calculations within a cell all are single result functions return one number or character (a letter or word) to the cell excellent help support within Excel describes the mathematics behind the function shows how to use the function, and gives several examples
Next Used Have Section 3.8: Excel functions
Previous An example of using functions: the "sin" function
Select "Formulas" tab 22 x data function wizard y data sin(y) data Section 3.8: Excel functions
Previous Next Using functions: the "sin" function 33 copy paste Section 3.8: Excel functions
Previous Next Using functions: the "sum" function 44 Section 3.8: Excel functions
Previous Next Using functions: the "average" function 55 Section 3.8: Excel functions
Previous Next Using functions: the "countif" function 66 You can easily learn to use other Excel functions using the function "Help" window Section 3.8: Excel functions
Previous Next 77 End of Slide Show for Section 3.8
Excel example done in this section Excel_function_example.xlsx
Click to edit Master subtitle style This is a good time to work on Exercise 3.8 Section 3.8: Excel functions
Previous Next 88 End of Slide Show for Section 3.8
Excel example done in this section Excel_function_example.xlsx
Click to edit Master subtitle style This is a good time to work on Exercise 3.8 Section 3.8: Excel functions
Previous Next ...
View
Full
Document
 Spring '08
 ALL

Click to edit the document details