USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
RAND()
|
|
|
RAND BETWEEN(1000, 5000)
|
|
|
BETWEEN(1000, 5000)
|
|
|
RANDOM(1000, 5000)
|
Detailed explanation-1: -We use the ISNUMBER function to test if a value is a number. It will return “true” when the value is numeric and “false” when non-numeric. Let us consider the syntax “=ISNUMBER(G1).” It returns “true” if the argument “G1” contains a number or a formula that returns a numeric value.
Detailed explanation-2: -On the Home tab, in the Cells group, click Insert, and then click Insert Sheet. Tip: You can also right-click the selected sheet tabs, and then click Insert. On the General tab, click Worksheet, and then click OK.
Detailed explanation-3: -Excel is an incredibly powerful tool for getting meaning out of vast amounts of data. But it also works really well for simple calculations and tracking almost any kind of information. The key for unlocking all that potential is the grid of cells. Cells can contain numbers, text, or formulas.