Lookup functions allow spreadsheet users to show quantities of distinct, discrete categories of data. present data that changes as a function of time. keep track of IF statements and nested IF statements. reduce the amount of manual searching and data entry.

For the following example of making a peanut butter and jelly sandwich, identify which are inputs, processes, or outputs: bread scooping and spreading peanut butter plate scooping and spreading jelly finished sandwich putting two pieces of covered bread together dirty plate crumbs