DATABASE FUNDAMENTALS
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: -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.
Detailed explanation-2: -To apply workbook protection in Excel, click the “Review” tab in the Ribbon. Then click the “Protect Workbook” button in the “Protect” button group to open the “Protect Structure and Windows” dialog box.
There is 1 question to complete.