This question is based upon the figure shown below.

 

What does the icon marked with a red square in the figure above signify? 

 

Analyze the image shown. What would be the output when you use the following formula in an MS Excel 2010 worksheet? =SUM(A2:CHOOSE(2,A3,A4,A5))

Which of the following tools is used to format Excel worksheet data, as shown in the figure above?

____ shows you how a fill color will look before you apply it.

________ is the process of arranging data in a specific order based on the value in a field.

A ____ is a reference to a cell or range of cells in another workbook.

What is the first thing before launching subtotal function?

A cell with a numerical value has a green corner. What does this mean?

A green flag will appear on the upper right-hand side of a cell when it contains:

How can you remove an icon from the Quick Access Toolbar?

Under what tab can the Scenario Manager be found?