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

This video tutorial provides an in-depth look at using the Excel Web App, starting with logging into Office 365 and exploring the interface. It covers creating, saving, and renaming workbooks, and demonstrates how to use financial functions like the PV function to create a loan calculator. The tutorial also highlights the limitations of the web app compared to the desktop version, such as fewer chart options. Additionally, it discusses sharing workbooks and introduces features like surveys, emphasizing the app's capabilities and limitations.

What is the first step to access Excel Online through Office 365?

• Log into your Office 365 account

• Create a new Microsoft account

• Open the Excel desktop application

• Download the Excel app

Which feature is used to create a visual representation of data in Excel Online?

• Insert a pivot table

• Insert a column chart

• Insert a pie chart

• Insert a table

How can you rename a workbook in Excel Online?

• Select 'Rename' from the Home tab

• Double-click the workbook name

• Go to the File tab and choose 'Save As' then 'Rename'

• Right-click the workbook and select 'Rename'

Which function is used to calculate the present value of a loan in Excel?

• FV

• PMT

• RATE

• PV

What is a limitation of the Excel Web App compared to the desktop version?

• Cannot create charts

• Cannot open existing workbooks

• Limited chart formatting options

• No ability to save workbooks

What feature allows you to share a workbook with others in Excel Online?

• Print and distribute

• Share with specific permissions

• Export as PDF

• Email as attachment

Which feature in Excel Online allows you to create a survey?

• Insert a poll

• Insert a questionnaire

• Insert a survey

• Insert a form