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
