Excel Features and Functions Overview

The video tutorial explains how to save and share files in Excel using OneDrive. It covers the regular save and save as commands, changing default save settings, and using the auto recovery feature. The tutorial also demonstrates how to export workbooks to different file types, such as PDF, and how to share workbooks via OneDrive. Additionally, it discusses the AutoSave feature available with Office 365 and how to manage it.

What is OneDrive primarily used for in Excel?

• Installing Excel updates

• Editing documents offline

• Online storage and sharing of files

• Creating new workbooks

What must you do before using OneDrive in Excel?

• Connect to a printer

• Enable offline mode

• Log in with your Microsoft account

• Install a special plugin

How can you change the default save location in Excel?

• By right-clicking on the desktop

• By using the 'Save As' command

• By adjusting settings in the 'Options' menu

• By clicking 'File' and selecting 'New'

What does the Auto Recovery feature in Excel do?

• Deletes old versions of files

• Saves a backup copy of your workbook

• Converts files to PDF format

• Automatically updates Excel to the latest version

How often does Excel auto-save a backup copy by default?

• Every 20 minutes

• Every 15 minutes

• Every 10 minutes

• Every 5 minutes

Why might you export a workbook as a PDF?

• To reduce the file size

• To ensure it can be viewed without Excel

• To allow others to edit it

• To improve the workbook's performance

Which file type should you use for compatibility with Excel 2003?

• CSV

• Excel 2010 Workbook

• Excel 97 to 2003 Workbook

• PDF

What must you do to share a workbook using OneDrive?

• Save it as a PDF

• Upload it to OneDrive

• Convert it to a CSV file

• Print the workbook

What happens when you enable AutoSave in Office 365?

• The workbook is shared with all your contacts

• You must manually save changes

• Changes are automatically saved to OneDrive

• Your workbook is saved only when you close Excel

How can you disable the AutoSave feature in Office 365?

• By clicking the button in the top left corner

• By logging out of your Microsoft account

• By uninstalling Excel

• By saving the file as a PDF