FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS

Please wait while the activity loads.
If this activity does not load, try refreshing your browser. Also, this page requires javascript. Please visit using a browser with javascript enabled.

If loading fails, click here to try again

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]

If March is keyed in cell B5, then copied and pasted in cell B6, what will appear in cell B6?

A	April
B	February
C	March
D	June

Explanation:

Detailed explanation-1: -Be careful if you paste copied cell information into cells that already contain data. If you do, the existing data is overwritten. You can copy information from many different sources-including websites, emails, or other Office applications like Word and PowerPoint-and paste it into an Excel spreadsheet.

Detailed explanation-2: -Use the IF function, one of the logical functions, to return one value if a condition is true and another value if it’s false. For example: =IF(A2>B2, "Over Budget", "OK") =IF(A2=B2, B4-A4, "")

Detailed explanation-3: -The correct answer is The selected cell will show the value that is contained in cell B25. When you select a cell in MS Excel and type “=B25” then the selected cell will show the value that is contained in cell B25. In MS-Excel Equal (=) sign means that you enter either a calculation or function for the selected cell.

There is 1 question to complete.