LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Dora
 
Posts: n/a
Default Using Data Table

Hi

Am working on practice excerice from MOS Excel 2003 Expert Exam. The problem
am having is understanding the instructions and asks the following...

Example E03E-1-7, page 343 is...

'Open the UseDataTable workbook. In Cell D9, enter the following formula:
=PMT(B5/12,B6,B4). Then enter the following loan terms in E9:H9:' entering
values in those vells. 'In cells D10:D15:' asks to enter more vaules. Then
use a data table to show the matrix that results when the formula is
calulated using each of the two sets of variables.

Q) When it asks.. 'In the column input cell box, enter reference to the
input cell for the varying values listed in the column.' Also asks me the
same for the rows as well. I don't really know what it means by that. Can
someone explain differently, for exanple when it says enter reference what
does it mean.
--
Thanks for your for your help and time
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Sort pages? David Excel Discussion (Misc queries) 15 May 13th 05 11:33 PM
Pivot Tables, Help? Adam Excel Discussion (Misc queries) 6 March 24th 05 02:35 PM
Multiple worksheet queries liam Excel Worksheet Functions 3 February 16th 05 06:52 PM
Pulling data from 1 sheet to another Dave1155 Excel Worksheet Functions 1 January 12th 05 05:55 PM
changing proportion of chart and data table Dawn Parks Charts and Charting in Excel 3 January 6th 05 01:18 AM


All times are GMT +1. The time now is 03:16 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"