Which Consolidate option would you choose when you want to arrange the data in all the worksheets in identical order and location?

How will you find cells with data validation?

What is the purpose of using the Keep text flat option, as shown in the picture?

What is the purpose of the cell denoted as 'A' in the worksheet?

When does the error, as shown in the picture, occur?

True or False: Zero values are not plotted using sparklines.

Where do you enable/disable the Developer Tab?

What function returns information about the formatting, location or contents of a cell?

Under which ribbon item can you find protection options?

Sometimes, data that you're charting may be missing one or more data points. Excel offers three ways to handle the missing data. All of the following are ways to handle missing data EXCEPT: