Microsoft Excel 2021365 - Beginner to Advanced - Section Introduction - 2

Deborah Ashby introduces an Excel 2021 Intermediate course, covering standalone versions, logical functions, lookup functions, advanced sorting, data preparation, Pivot Tables, formula auditing, data validation, and What-If analysis tools. The course includes 15 sections and 70 lessons, with video demonstrations and downloadable resources.

What is the main difference between Excel 2021 and Office 365 versions?

• Excel 2021 receives automatic updates, unlike Office 365.

• Office 365 includes automatic updates, whereas Excel 2021 requires waiting for the next standalone release.

• Excel 2021 has more features than Office 365.

• Excel 2021 is subscription-based, while Office 365 is a one-time purchase.

Which of the following is NOT a logical function covered in the course?

• AVERAGEIFS

• SUMIFS

• VLOOKUP

• COUNTIFS

What new function in Excel 2021 is introduced for more complex lookups?

• HLOOKUP

• XLOOKUP

• MATCH

• INDEX

Which feature is used to create interactive dashboards in Excel?

• Goal Seek

• Pivot Tables

• Slicers and Timelines

• Data Validation

What is the purpose of formula auditing in Excel?

• To create interactive dashboards

• To identify and fix errors in formulas

• To validate data entries

• To perform What-If analysis

Which tool is NOT part of Excel's What-If analysis?

• Goal Seek

• Variable Data Tables

• Scenario Manager

• Data Validation

What is required before starting the Excel 2021 Intermediate course?

• Access to the internet

• A subscription to Office 365

• A copy of Excel 2021 installed on your PC

• Previous experience with Excel 2019