USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Page Layout
|
|
|
Print
|
|
|
Normal
|
|
|
Web
|
Detailed explanation-1: -To view a page in Page Layout View, first you need to click the worksheet that you want to change in this view and then on the ‘View’ tab click ‘Page Layout View’ which is found under the ‘Views’ group.
Detailed explanation-2: -When you select one or more sheets and then click File > Print, you’ll see a preview of how the data will appear on the printout. Select the worksheet(s) you want to preview. Click File, and then click Print to display the Preview window and printing options. Keyboard shortcut You can also press Ctrl+F2.
Detailed explanation-3: -Add a Sheet View Select the worksheet where you want the Sheet View, then click to View > Sheet View > New.
Detailed explanation-4: -Work in Compatibility Mode You can open a workbook that was created in an earlier version of Excel and work in Compatibility Mode so that the workbook remains in a file format that can easily be opened again in the earlier version.
Detailed explanation-5: -To change worksheet views, locate the commands in the bottom-right corner of the Excel window and select Normal view, Page Layout view, or Page Break view.