This preview shows page 1. Sign up to view the full content.
Unformatted text preview: rence the cell in column A of the current row. That is, if a formula entered in
cell A2 containing $A2 is copied in cell El2, this cell reference in the formula in
cell E12 will refer to cell A12.
3. Precede only the row number of the cell with a dollar sign ($) to make only
the row reference absolute. For example, A$2 is a cell reference that is absolute as
to row only. When copied at any other cell location, it will reference the cell in
row 2 of the current column. That is, if a formula entered in cell A2 containing
A$2 is copied in cell El2, this cell reference in the formula in cell E12 will refer to
All spreadsheet packages come with a set of commands to enable you to perform
many different operations. For example, copy and move commands enable you to
copy/move the contents of one or more cells to some other cells. Insert and delete
commands enable you to add/remove a column or row anywhere in your
spreadsheet. Format commands enable you to control the way cell contents are
displayed. Formatting features include specifying the width of columns, the
number of decimal places in a non-integer numerical value, automatic insertion of
a dollar sign and commas to separate thousands for currency amounts (such as
$6,852), the use of right- or left-justified values or labels, etc. Save and retrieve
commands enable you to store the format and data of an already created
spreadsheet on a disk, and to retrieve it later for updates and analyses. Print
command enables you to generate a hard copy of all or part of a spreadsheet.
Most spreadsheet packages come with presentation graphics feature, which
enables you to create graphs and charts from numerical data stored in a
spreadsheet. As shown in Figure 15.10, the most popular types of graphs and
charts supported for graphical representation of numerical data are line graphs, bar
charts and pie charts. This feature is very useful in presenting spreadsheet data in
easier to understand visual forms because most...
View Full Document
- Spring '14