Exploring Microsoft Excel 2003 Comprehensive
For Introductory Computer courses in Microsoft Office 2003 or courses in Computer Concepts with a lab component for Microsoft Office 2003 applications.
Results 1-3 of 60
(d) Example 4 (dependent cells) Cell reference adjusts to follow moved entry
Moved formula is unchanged (e) Example 5 (absolute cell addresses) Cell
reference adjusts to follow moved entry Both cell references adjust to follow
(a) The entry is equivalent to the formula =F5+F6 (b) The cell will display the
contents of cell F5 plus cell F6 (c) The entry will be treated as a text entry and
display F5+F6 in the cell (d) The entry will be rejected by Excel, which will signal
This is true despite the fact that the entries in cell A5 of both worksheets return a
value of 100. Consider what happens if a new row is inserted between existing
rows 2 and 3, with the entry in the new cell equal to 25 as shown in Figure 4.1 lb.
What people are saying - Write a review
What Is a Spreadsheet?
The File Menu
A Better Grade Book
16 other sections not shown