or they may be integrated together in a single

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: 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 cell E2. Spreadsheet Commands 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. Spreadsheet Graphics 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

Ask a homework question - tutors are online