1. True/False: In Excel a logicalfunction in a worksheet returns a different value depending onwhether a specified condition is zero.

2. True/False: AND & IF are logicalfunctions that can be used to build formulas in a worksheet.

3. The AND functionwill only returns a value of FALSE if

A) the criteria isin numerical value

B) one or more ofits logical tests isfalse

C) all logicaltests are false

D) both b and c

4. Which comparisonoperator is not used in a logical test?

A) =

B) <>

C) >

D) /

5. In Excel 2019, alogical test is

A) a worksheet

B) based upon thenumbers 0 and 1

C) a condition thatcan be answered with a true or false response

D) formatting feature

6. Given thisstatistical formula, =COUNTA(F3:F12)

A) Excel willreturn the number of cells in the range that are not formatted andempty

B) Excel willreturn the number of cells in the range that are not empty

C) Excel willreturn the number of cells in the range that contain numericdata

D) Excel will return thenumber of cells in the range that only contain logicalfunctions

Answer rating: 100% (QA)

The detailed answer for the above question is provided below Answer 1 True Explanation In Excel if a... View the full answer