Microsoft Excel

Ledger vs. Spreadsheet

Paper Ledger Computer Ledger Paper Spreadsheet Computer Spreadsheet ledger = book spreadsheet = (work)sheet

Although originally the word "ledger" was used to mean a book, not just a sheet, today sometimes it's also used to mean a sheet only. Although technically incorrect, nowadays unfortunately it's widely used = accepted in this incorrect way.

---

Formulas

=SUM(A2+A11) =SUM(A2-A11) =SUM(A2*A11) =SUM(A2/A11) =SUM(A2:A11) =AVERAGE(B2:B11) =MAX(B2:B11) =MIN(B2:B11) =COUNT(B2:B11) =IF(E2<0,"Underpaid","Paid")     If E2<0, then write Underpaid, otherwise write Paid.

Addition Subtraction Multiplication Division Add Thru Average Maximum Minimum Count If

---

Basic Exercises

Temperature
Budget
Students' Grades
Mail Merge

---

Advanced Exercises

Pivot Table
Vlookup

---