Blog

In the image below, a ____ has been inserted into the merged cell B32.  

A(n) ____ cell is a single cell created by combining two or more adjacent cells to become a single cell.

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

What separates a worksheet reference from a cell reference?  

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

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?