DATABASE FUNDAMENTALS
HOW TO MODIFY THE WORKSHEET TAB 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 your school. Which function would allow her to have Excel pick a random number between 1000 and 5000 for the new member ID numbers?
|
RAND()
|
|
RAND BETWEEN(1000, 5000)
|
|
BETWEEN(1000, 5000)
|
|
RANDOM(1000, 5000)
|
Explanation:
Detailed explanation-1: -You can access Backstage view by pressing Ctrl + B. To access an Excel template, you can click the FILE tab and click New.
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.
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.