70.9k views
5 votes
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.

User Eeezyy
by
7.4k points

2 Answers

4 votes

Answer:

it's D

Step-by-step explanation:

User Dshap
by
7.6k points
1 vote

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.

Step-by-step 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!

User ShaneKm
by
7.5k points