Excel Formulas Lesson 4-5

There are two types of references.

• Relative and Dependent

• Relative and Proportionate

• Absolute and Dominant

• Relative and Absolute

Which of the following is an example of a relative cell reference?

• B2

• $B2

• !B2

• $B$2

Does not change when copied or filled.

• Relative Cell Reference

• Absolute Cell Reference

• Dominant Cell Reference

• Dependent Cell Reference

Press the __________________ key on the keyboard to apply absolute cell reference.

• F1

• F2

• F3

• F4

You can't reference across worksheets

• True

• False

A predefined formula that performs calculations using specific values in a particular order.

• Function

• Reference

• Chart

__________________contains the information you want to calculate.

• Arguments

• Syntax

• Equal Sign

• Cell Reference

Multiple arguments must be separated by a ______________.

• Space

• Comma

• = Sign

• !

Which function determined the highest cell value included in the argument.

• Max

• Min

• Count

• Sum

Answer =2*2+6-1

• 9

• 15

• 20

• 21