FUNDAMENTALS OF COMPUTER

Previous
Next

USING MICROSOFT EXCEL

HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
which of the following functions allows you to have Excel place a random number between 10000 and 99999 in a cell?
A
=RAND()
B
=RANDOM(10000, 99999)
C
=BYCHANCE(10000, 99999)
D
=RANDBETWEEN(10000, 99999)
Explanation: 

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.

There is 1 question to complete.
Previous
Next