The COUNT function will not count negative numbers when evaluating a range ofvalues. True or false?

You need to determine the largest value in a range of numbers. Which functionshould you use?

What delimiter does a CSV file use?

The data in J2 is the zip code 43892-3424. What would the result be for the function =MID(J2,7,4)? 

Which function would be best to apply to a cell containing a title of a book in which the first letter of every word should be capitalized? 

Which of the following can you use as a delimiter within a TEXTJOIN function?Select the correct option.

What is the correct order of entering the four parts of an HLOOKUP function? 

Indicate the correct sequence by adding numbers 1-4 next to the following items. 

Which of the following is the correct syntax for the WORKDAY function? Select the correct option.

If the content of A2 is 100 and the contents of B2 is 200, what result would you getusing the formula  =IF(AND(A2>50,B2>200),"Excellent","Needs improvement")  Select all that apply.

Instead of creating a nested IF function, what single function can you use if you have multiple criteria to meet? 

How many conditions can you have within an AND function? 

Which of the following steps isn’t required to delete an existing scenario in a workbook? 

Indicate the incorrect step by marking it as false. 

Which of the following commands are available in the Scenario Manager dialogbox? Select all that apply.

Which of the following command categories is Goal Seek part of?

The Remove Duplicates tool considers each row in a data set as a :

In a Linear fill series, what does the Step value refer to? Select the correct option.

When a cell has a precedent in another workbook, what is attached to the arrow?Select the correct option

Which of the following keyboard shortcuts can you use to navigate to a precedent or dependent cell? 

To step into a formula, what command would you use?

To change the color of the error indicator in a cell, which tab would you select in theExcel Options dialog box? Select the correct option.