USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
=RAND()
|
|
=RANDOM(10000, 99999)
|
|
=BYCHANCE(10000, 99999)
|
|
=RANDBETWEEN(10000, 99999)
|
Detailed explanation-1: -Use the RAND or RANDBETWEEN function to generate a list of random numbers.
Detailed explanation-2: -The RANDOM function randomly assigns a number between two specified values. You can recalculate a worksheet at any time by pressing the F9 function key or by electing the refresh button also found on the formulas tab in the calculation group.
Detailed explanation-3: -The fastest method is to click on the Add Sheet (+) icon located to the left of the sheet tabs, at the bottom of the spreadsheet. This inserts one new sheet without opening any dialog, with a default name (Sheet2, for example) and with the new sheet’s tab positioned at the right hand end of the sheet tabs.
Detailed explanation-4: -On the Review tab, in the Changes group, click the Protect and Share Workbook button. The Protect Shared Workbook dialog window will show up, and you select the Sharing with track changes check box.