Why will Excel return an error for the formula =HLOOKUP(A1,B2:E6,6,0)?

Two common wildcard characters that Excel recognizes are

Under what tab can the Scenario Manager be found?

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

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

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

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

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

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

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

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