Category: Uncategorized

The image below shows the results of using the Subtotal feature in Excel.  Why are there dots on the left of rows 62-67?  

What separates a worksheet reference from a cell reference?  

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.

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

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

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?   

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?