Return to Spreadsheet_Ranges.tex CVS log

Up to [LON-CAPA] / loncom / html / adm / help / tex

.tex files from help.loncapa.org largely done. Added some lables to
older files. Last mega-massive .tex commit for a while.

\label{Spreadsheet_Ranges}
Ranges specify rectangles of various shapes in the spreadsheet, just
as ranges do in traditional spreadsheets. Exmples of legitimate
ranges: 

\begin{itemize}

\item \textbf{*} - all rows, all columns 
\item \textbf{B*} - all rows in column B 
\item \textbf{*5} - all columns in row 5 
\item \textbf{C5..F25} - all cells in the rectangle between C5 and F25

\end{itemize}

Many functions accept ranges. For example, \&SUM(``d*'') will add 
up all cells in column d.