DATABASE FUNDAMENTALS
HOW TO INSERT DELETE COLUMNS ROWS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
You need to share your Excel 2016 workbook with a colleague who uses Excel 2003. What should you do?
|
|
Use the Check Compatibility tool to inspect the workbook for any compatibility issues with Excel 2003, then save your workbook in Excel 97-2003 format.
|
|
|
Encourage your colleague to upgrade to Excel 2016 so he can work with your data.
|
|
|
You don’t need to do anything-Excel 2003 can open an Excel 2016 workbook with no difficulties.
|
|
|
Allow your colleague to use your computer when working on the file.
|
Explanation:
Detailed explanation-1: -Click File > Info > Check for Issues. Choose Check Compatibility. To check for compatibility automatically from now on, check the Check compatibility when saving this workbook box.
Detailed explanation-2: -You need to share your Excel 2016 workbook with a colleague who uses Excel 2003. What should you do? Use the Check Compatibility tool to inspect the workbook for any compatibility issues with Excel 2003, then save your workbook in Excel 97-2003 format.
Detailed explanation-3: -To check compatibility with an older version of Office Click the File tab, and then click Info. Click Check for Issues, and then click Check Compatibility.
There is 1 question to complete.