The Complete Excel Guide: Beginners to Advanced - What's New in Excel 2019

The video provides an overview of new features in Excel 2019, including selecting and deselecting cells, the accessibility checker, the translate feature, and the new concat function. These features enhance usability, accessibility, and functionality, making Excel more efficient for users, especially those with visual impairments or language translation needs.

What is a new feature in Excel 2019 that allows users to deselect cells without starting over?

• Auto-Select

• Cell Locking

• Range Highlighting

• Improved Selection

What is the purpose of the Accessibility Checker in Excel 2019?

• To enhance spreadsheet performance

• To translate text into different languages

• To automatically format cells

• To assist visually impaired users in identifying issues

Where can you find the Accessibility Checker in Excel?

• Home tab

• Insert tab

• Review tab

• Data tab

What does the Translate feature in Excel 2019 allow you to do?

• Translate selected text into different languages

• Convert numbers to text

• Encrypt spreadsheet data

• Change the font style

Which function in Excel 2019 replaces the older CONCATENATE function?

• MERGE

• JOIN

• CONCAT

• COMBINE

What is a key difference between CONCAT and CONCATENATE in Excel?

• CONCATENATE is faster

• CONCAT can merge more than two cells

• CONCATENATE supports more languages

• CONCAT requires a plugin

How can you add a space between merged text using the CONCAT function?

• By using the space function

• By using a semicolon

• By adding a comma and a space

• By pressing the spacebar