Question

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?
Click the Home tab and use the Find & Select function to look for a function that counts items.
Access the Find dialog box using Ctrl + F to look for a function that counts items.
Press Shift + F3 to access the Insert Function dialog box to look for a function that counts items.
Enter the item reference numbers into the worksheet, and click the Sort button to count the items.

Answer 1

Answer:

Option C: Press Shift + F3 to access the Insert Function dialog box to look for a function that counts items.

is the correct answer.

Explanation:

As Alex wants to find a function that is capable of counting item reference numbers that he is inserting into a spread sheet, so she should:

• Press Shift + F3
• This key would present a dialogue box on the screen.
• The dialogue box will have the option that will search for the functions inserted.
• Item counting function will be inserted into the dialogue box and press ok.

All other options will not help Alex in the respective manner.

hope it will help you!