DATABASE FUNDAMENTALS
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
The FBLA Advisor at Hilltop High School would like to create random ID numbers for FBLA members. Which function would be used to have Excel pick a random number between 1, 000 and 5, 000 for the new member ID numbers?
|
|
RAND()
|
|
|
RAND BETWEEN(1000, 5000)
|
|
|
BETWEEN(1000, 5000)
|
|
|
RANDOM(1000, 5000)
|
Explanation:
Detailed explanation-1: -Typing =RAND() puts a 9-digit random number between 0 and 1 in the cell. The function =RAND() will re-randomize each time you make any changes to any other part of the spreadsheet. Excel does this because it recalculates all values with any change to any cell.
Detailed explanation-2: -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-3: -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.