USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
BackStage View
|
|
|
Compatibility Mode
|
|
|
Either A or B
|
|
|
None of the above
|
Detailed explanation-1: -In Compatibility Mode, any new or enhanced Excel features are not available, which prevents loss of data and fidelity when the workbook is opened in an earlier version of Excel. Also, instead of using a current file format (. xlsx, . xlsb, .
Detailed explanation-2: -If you’re using an older Excel version, all files you create will be opened in Compatibility Mode when someone using a newer version of Excel views your workbook. On the other hand, those who work with recent releases have to prep their documents to ensure others can open it properly.
Detailed explanation-3: -Compatibility mode ensures that no new or improved features in Office are available while users work with a document so that people who use earlier versions of Office will have full editing capabilities. Compatibility mode also preserves the layout of the document.
Detailed explanation-4: -Open the file you want to view. Click File > Info > Version history. Select a version to open it in a separate window. If you want to restore a previous version you’ve opened, select Restore.