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:

Under which ribbon item can you find protection options?

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

Where do you enable/disable the Developer Tab?

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

If A1 contains the text 'Red' and B2 contains 'Blue' then =OFFSET(A1,1,1) returns

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

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

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

How will you find cells with data validation?

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