Question

chris has taken a complete inventory of the student store. for each inventory item he has documented the item name, initial count of the item at the beginning of the school year, current count, purchase price, selling price, total value of inventory of the item, and the source it was purchased from. the principal wants to know how many pencils are available. what can chris use that easily sorts, filters and calculates the spreadsheet data?
a table
b column chart
c legend
d function

Explanation:

A function in a spreadsheet (e.g., SUMIF to calculate available pencils by filtering "pencils" in the item name column and summing current counts) allows sorting, filtering, and calculation of data. A table organizes data but doesn’t inherently calculate; a column chart visualizes data; a legend labels chart elements—none of these directly perform the needed calculation with filtering/sorting as efficiently as a function.

Answer:

D. Function