1.0 Microsoft Excel Flashcards
1
Q
What is Microsoft Excel?
A
It is a spreadsheet software that is extremely useful in solving many types of problems
* It requires no user programming
2
Q
Exel Capabilities you will learn in this course are
A
- Iterative solution of Nonlinear Equations
- Numerical Differentiation
- Numerical Integration
3
Q
Several methods to solve an equation
A
- Plotting
- Guessing and Checking
- Direct Substitution
- Goal Seek
- Solver
4
Q
Iterative solution of Nonlinear Equations
A
2 Standard Forms of writing an equation
1. Plotting and using Goal Seek and Solver
2. Direct Substitution
Both can be used for solution by the Guess-and-Check Method
