Alex needs to create a function capable of counting item reference numbers that he is inserting into a spread sheet. The purpose of this function will be to keep track of inventory. How would Alex go about finding a function to do this?

In a spreadsheet program such as Excel, Shift + F3 opens the Insert Function dialog box, where Alex can search for a function that counts the item reference numbers. The Find & Select and Ctrl + F options search worksheet content, not the function library, and sorting arranges values without counting them.

AI-written and checked against the verified answer.