Course Intermediate several-sheets
Orders and a price list
This workbook has three sheets. Orders lists a month of orders by product code, and Prices holds the price list. On the Summary sheet, fill in the units sold, unit price and revenue for each product in B2:D9, then the total revenue in D11 and the code of the product that brought in the most in D12.
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