This question is based upon the figure shown below

 

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.

A _______ describes the location of a cell based on its column and row location.

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?

Two common wildcard characters that Excel recognizes are