Excel in 30 Minutes – Calculations

What symbol is used to start a formula?

=

*

>

!

Which of the following is NOT a method to copy a formula?

Copy and paste

Alt =

Click and drag the fill handle

Double click the fill handle

Why would you need to make a cell reference absolute? Select the correct answer and click Submit.

To ensure the cell reference changes when you copy it

To keep Excel from copying the cell reference

To format the number as currency

To keep Excel from changing the reference when you copy it

Information