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]
Dean needs to print a worksheet for distribution at a meeting. The worksheet currently includes sensitive information that Dean needs to see, but which should not be seen by the meeting attendees. What is the easiest way for Dean to print an appropriate version of the worksheet for his meeting?
A
Make a copy of the worksheet, delete the sensitive information from the new worksheet, and then print the new worksheet.
B
Use a conditional printing command that skips over the cell ranges containing sensitive information.
C
Delete the sensitive information, print the worksheet, then enter the deleted information back into the worksheet.
D
Hide the rows or columns that contain the sensitive information before printing the worksheet.
Explanation: 

Detailed explanation-1: -Page Layout view shows you the position of your worksheet as it will appear on a printed page. One of the features of Page Layout view is the Ruler which shows the size of the margins and allows you to drag the margins in or out to change the amount of the worksheet shown on the page.

Detailed explanation-2: -Select the Review tab, and then, in the Proofing section, select Workbook Statistics. You can also press CTRL+SHIFT+G. (Note that the CTRL+SHIFT+G shortcut won’t work in Excel for the web.) The Workbook Statistics dialog opens and displays counts and other information about the current worksheet and workbook.

Detailed explanation-3: -Press and hold the Shift key on the keyboard. Press and release the F11 key. Release the Shift key. A new worksheet is inserted into the current workbook to the left of all existing worksheets.

Detailed explanation-4: -To change the color of a sheet tab, right-click the tab, point to Tab Color and pick a color that you want. Tip: Click away from the formatted tab to see the new tab color. If you want to remove the color, right-click the tab, point to Tab Color, and pick No Color.

There is 1 question to complete.
Previous
Next