Spreadsheets_28Aug11

C3d5 named cells by default named cells are always

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: C4 =$A1+$A2+C3 Ranges   A rectangular range of cells can be indicated by giving the address of the upper leJmost cell followed by a colon followed by the address of the lower rightmost cell   =sum(a3:a6) is the same as =a3+a4+a5+a6   =max(b2:d2) is the same as =max(b2,c2,d2)   =min(b3:c4) is the same as =min(b3,b4,c3,c4) Named Cells   Rather than always referring to a cell by its address, you can define a more meaningful name, making formulas more readable   For example,...
View Full Document

This note was uploaded on 12/01/2012 for the course ECE 1331 taught by Professor Staff during the Fall '08 term at University of Houston.

Ask a homework question - tutors are online