DATABASE FUNDAMENTALS
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
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 the latest version of Excel so he can work with your data.
|
|
|
You don’t need to do anything-Excel 2003 can open any Excel workbook regardless of the version, with no difficulties
|
|
|
Allow your colleague to use your computer when working on the file
|
Detailed explanation-1: -You need to share your Excel workbook that you created in Office 365 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-2: -If you selected the Share button, people will receive an email message inviting them to open the file. They can select the link to open the workbook. A web browser will open, and the workbook will open in Excel for the web. If they want to use the Excel desktop app to co-author, they can select Edit in Desktop App.
Detailed explanation-3: -While you’ll use Save or press Ctrl+S to save an existing workbook in its current location, you need to use Save As to save your workbook for the first time, in a different location, or to create a copy of your workbook in the same or another location.