This question is based upon the figure shown below

What does the screen tip displaying "Showing All" mean?

Which part of the formula displays references in the given picture?

Result, when =T(A4) is applied on the given table?

What is the significance of the red symbol at the top right corner of the cell, as shown in the picture?

The checkbox 'Create links to source data' has been selected. Which of the following statements is correct regarding this?

Which Chart type is displayed in the given picture?

What are the two syntaxes for the AGGREGATE function?

If you aren't sure what type of chart to use for your data, how can Excel help?

You have a range of cells selected and want to place a duplicate of that range elsewhere on the page. How can you do this?

All of the following are recognized file extensions in Excel except:

Which formula should be used to find the row that 'Steven' appears in and return his phone number? (Sheet contains Names in Column A and Phone Numbers in Column B)