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]

Adding, deleting, and viewing comments are performed from the commands on which Ribbon tab?

A	Comments
B	Review
C	File
D	View

Explanation:

Detailed explanation-1: -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.

Detailed explanation-2: -The pie chart is one of the most used and hated chart types of all time. Pie charts are used to show parts of a whole. A pie chart represents numbers in percentages, and the total sum of all the divided segments equals 100 percent.

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: -To convert the text to lowercase, type =LOWER(A2) instead. Use =UPPER(A2) in cases where you need to convert text to uppercase, replacing A2 with the appropriate cell reference.

There is 1 question to complete.