Ch3_8 - Section 3.8: Excel functions Excel 11 has available...

Info iconThis preview shows pages 1–8. Sign up to view the full content.

View Full Document Right Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
This is the end of the preview. Sign up to access the rest of the 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

Page1 / 8

Ch3_8 - Section 3.8: Excel functions Excel 11 has available...

This preview shows document pages 1 - 8. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online