Shop Decisions and Conditions1/4
Spreadsheet practice
Complete each goal to unlock the next task.
Module progress0/4
Goal
Classify Pen sales.
Use IF to show whether Pen sold enough units.
Steps
- 1Use the Pen sold value as the condition.
- 2Return High if the target is met and Check if it is not.
- 3Type = to start a formula.
- 4Use IF for this task.
- 5Use the worksheet labels to identify the correct range, criteria, lookup table, or return column.
- 6Press Enter and check the result.
0 points
Spreadsheet workspace
Loading spreadsheet engine...