USING MICROSOFT EXCEL
USING THE UPPER AND LOWER FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
The FBLA Advisor at your school would like to create random ID numbers for FBLA members at yourschool. Which function would allow her to have Excel pick a random number between 1000 and 5000 for thenew member ID numbers?
|
|
RAND()
|
|
|
RAND BETWEEN(1000, 5000)
|
|
|
BETWEEN(1000, 5000)
|
|
|
RANDOM(1000, 5000)
|
Explanation:
Detailed explanation-1: -Use the COUNT function to get the number of entries in a number field that is in a range or array of numbers.
Detailed explanation-2: -Right-click the cell and then click Insert Comment (or press Shift+F2). If you’re using Excel for Office 365, right-click the cell and choose New Note.
There is 1 question to complete.