Blog

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?   

In the image below, cell I4 displays all “#” symbols.  Why?  

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.

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?   

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

A pivot chart will change automatically when you change the filtering in its associated pivottable.

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?  

If you delete a pivot table that has an associated pivot chart on the same worksheet, what happens to the pivot chart?

Use the image below to match answers with the questions.