answersLogoWhite

0

A colon is used for a range, by putting it between two cell references. So if you want to refer to the range from cell A3 to cell C9, it would be A3:C9 which could be then used in a function:

=SUM(A3:C9)

=AVERAGE(A3:C9)

=MAX(A3:C9)

User Avatar

Wiki User

10y ago

What else can I help you with?

Related Questions

What is the significance of the clef music symbol in determining the pitch range of a musical staff?

The clef music symbol indicates which notes correspond to the lines and spaces on a musical staff, determining the pitch range of the music being played or written.


What does a colon between two cells references indicates a range of cells including?

all cells between the two cells


A colon between two cell references indicates a range of cells that includes?

the entire worksheet


What is the symbol used between two code numbers to indicate that a range is available?

The symbol used between two code numbers to indicate that a range is available is the hyphen (-). In coding and data representation, the hyphen signifies a continuous sequence or range of values between the two specified numbers. This notation is commonly used in programming languages, spreadsheets, and various data processing applications to represent a series of values within a specified range.


Which punctuation mark between codes in the index of the cpt manual indicates a range of codes is available?

hyphen


Which punctuation mark between codes in the index of the cpt manual indicates a range of codes available?

hyphen


What is the significance of the symbol on viola music sheets?

The symbol on viola music sheets, called the clef, indicates the pitch range of the instrument. It helps viola players read and play music accurately by showing where the notes are positioned on the staff.


What is the significance of the viola symbol in music notation?

The viola symbol in music notation indicates that the music should be played one octave higher than written. This is important for instruments like the viola that have a different range than the written notes.


What is placed between a starting value and ending value defining a range?

A symbol such as a comma, a colon or a hyphen.


What is the symbol for Range Resources Corporation in the NYSE?

The symbol for Range Resources Corporation in the NYSE is: RRC.


Which punctuation mark in the cpt index indicates a range of codes are available?

A dash (-) in the CPT index indicates a range of available codes.


What is frequency range of airtel SIM card?

The SIM card doesn't have a frequency range as such, that comes from the phone the card is inserted into.