Case 14-1 Jenny, a programmer, uses Microsoft Excel 2016 to generate data required for the programs she develops. She uses various functions in Excel to perform the required calculations.
Jenny is coding a security program to generate numerical passwords in Excel. Jenny should use the _____ function to generate the numerical portions of the passwords arbitrarily.
A)SUM()
B)RAND()
C)ROUND()
D)INT()

Question

Quizplus · Accepted Answer

The RAND() function in Excel generates a random number greater than or equal to 0 and less than 1, which can be used as part of a method to generate arbitrary numerical values for passwords.

Case 14-1 Jenny, a Programmer, Uses Microsoft Excel 2016 to Generate