A VLOOKUP function cannot be used as the false part of an IF function.

Use the chart image below to answer these questions:  

Use the figure below.  Which Excel feature was used to highlight any year built value earlier than 1980?  

When creating footers, you can have Excel automatically insert the page numbers.

Use the image below to match answers with the questions.  

In Excel, dates appear ____-aligned in the cell by default, regardless of date format.

The image below shows a portion of an Excel table that shows information about registrations for seminars.  A room change is needed only in the case where the number of people registered is greater than the capacity of the room.  Which Excel function should be used in the formula in cell K2 to display whether a room change is needed?  

Moving one or more slices of a pie chart away from the pie creates a(n) ____.

The image below shows a portion of an Excel table that shows information about company employees and their payroll.  A fixed bonus percentage will be used to pay bonuses for any employee whose rating value is not “Poor”.  Which Excel function should be used in the formula in cell I4 to display whether the employee will get a bonus?   

Using the image below, match the correct function that would be used for each of the indicated cells.