Course Advanced several-sheets
Payroll from two sheets
Payroll needs this month's pay for everyone on the Payroll sheet. Hours and grades are on the Staff sheet, and the hourly rate for each grade is on Rates. Work out each person's pay in B2:B21, then the total in E2 and the name of the highest-paid person in E3. The names on Payroll are not in the same order as on Staff.
Sheet What it is for Filled cells
- =
- start a formula
- ↑ ↓ ← →
- move, or pick cells
- Ctrl D
- fill down
- Alt =
- AutoSum
- Ctrl Enter
- check
- ?
- all shortcuts