Using Ranges in Formulas and Functions

What is an example of absolute addressing in a range?

$C$7:$F$34

What is a range?

A range is one or more selected cells in any configuration A range is a collection of 1 or more selected cells in a rectangular shape

What is an example of a disjointed range designation?

A3:D32,F3:H32,L3:R32

You can select a range of cells by doing the following:

Clicking and dragging the mouse pointer on the screen

How do you designate a range?

If the range is disjointed, the range will be several ranges separated with commas like this A3:B22, E3:G22

Can any range be used in any function?

No, some ranges are disjointed and cannot be used in some functions or in creating charts

How do you designate a range to be absolute addressing?

Right after selecting the range you press the F4 key

How do you enter a range into an argument in a function?

Use the Insert Function dialog box and on the line where you enter the range, click on the collapse button, select the range and then click on the button again

What happens when you press the F4 key?

You change the current cell reference in the formula to an absolute address