How can we help?

You can also find more resources in our Help Center.

If cell D15 contains the formula =$C$5*D15, what is the D15 in the formula?

circular reference

What function would most appropriately accomplish the same thing as =(B5+C5+E5+F5)/5?

=AVERAGE(B5:F5)

When you type a function, what appears after you type the opening parenthesis?

Function Screen Tip

A formula containing the entry=$B3 is copied to a cell one column to the right and two rows down. How will the entry appear in its new location?

=$B5

Cell B10 conatins a date, such as 1/1/2012. which formula will determince how many days are between that date and the current date, given that the cell containing the formula is formatted with Number Format?

=TODAY()-B10

Which of the following is not at appropriate use of the SUM function?

=SUM(D15-C15)