1. True/False: In Excel a logicalfunction in a worksheet returns a different value depending onwhether a specified...
Question:
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
Essentials Of Statistics For Business And Economics
ISBN: 9781305081598
7th Edition
Authors: David Anderson, Thomas Williams, Dennis Sweeney, Jeffrey Cam