The Complete Excel Guide: Beginners to Advanced - Web App - Part 1

The video tutorial provides an overview of the Excel Web App, highlighting its features and limitations. It explains how to access the app through OneDrive and demonstrates the interface, including the ribbon and tabs. The tutorial covers saving, sharing, and downloading workbooks, emphasizing the automatic saving feature. It also discusses the integration with OneDrive for managing and opening workbooks, noting the limitations of the web app compared to the desktop version, such as the inability to run macros.

What is the primary function of the Excel Web App?

• To replace the desktop version of Excel

• To manage email and calendar online

• To edit workbooks using an Internet browser

• To create new Microsoft accounts

Which Microsoft service provides access to the Excel Web App?

• Office 365

• iCloud

• Dropbox

• Google Drive

What is a notable difference in the Excel Web App's ribbon compared to the desktop version?

• It has fewer tabs

• It has no tabs

• It has more tabs

• It has the same number of tabs

How does Excel Web App handle saving workbooks?

• Manually with a save button

• Automatically at frequent intervals

• Only when the user logs out

• Only when the workbook is closed

What happens when you download a workbook from Excel Web App?

• It is emailed to you

• It is saved to the downloads folder on your PC

• It is deleted from OneDrive

• It is saved to the cloud

What is the default location for downloaded workbooks from Excel Web App?

• OneDrive

• Downloads folder

• Documents folder

• Desktop

What feature is not available in the Excel Web App?

• Running macros

• Inserting charts

• Editing text

• Formatting cells

What must you do to open a workbook in the Excel Web App after saving it to OneDrive?

• Use a different browser

• Refresh the browser

• Download it again

• Log out and log back in

Which of the following is a limitation of the Excel Web App?

• It cannot run VBA code

• It cannot open any workbooks

• It cannot save workbooks

• It cannot display text

What should you do if you want to edit a workbook with full Excel functionality?

• Use Google Sheets

• Open in Excel desktop version

• Edit in Word

• Edit in the browser