Sample Excel Worksheets
either already complete, or you finish them. |
|
Samples built by D. Dal Bello | |
Attendance
Sheet |
Steel
Bar Plot Column Plot of distribution of strengths of a steel bar. |
Building Load |
Temperature
(you finish it) Input Celsius. Convert to Fahrenheit. Use Conditional formatting to apply background color corresponding to "Hot" "Warm" "Cool" and "Freezing" temperatures. |
Grade
Sheet (you finish it) Input grades, calculate Homework, Exam, Final Scores. Sum up scores. Automatically give grade using IF function. |
|
Samples from : Excel for Engineers and Scientists, Bloch S., John Wiley and Sons, 2003 | |
Vector
Algebra Magnitude, Addition, Subtraction: Dot Product, Cross-Product, Angles |
Matrix Dealing with matrixes in Excel! |
Surface Plot 3-d plot example. |