Question from MOS file E03C-1-1 , Creating data and contents

[Guest]

Hi,

Am currently studying MOS 2003 - Excel Core Exam. Am practicing file E03C-1-
from the practice folder where its giving the following instructions...

Open the EditContent workbook, and on sheet1, select the contents of D7 for
editing . Delete the period to the left of the 8, and insert a period between
8 and 5. Complete the correct corrected entry. Display Sheet2, and select
A13. Clear all the contents, formats and comments from the range. Display
sheet3, select A1134, and clear only its formats.

Q1) When it says "select the contents of D7 for editing . Delete the period
to the left of the 8, and insert a period between 8 and 5. " Does it want me
to delete cell C8 and enter vaule betwwen 8-5, if not then what does it mean.

2) When it says select A113 - does that mean select only cell A1 & D13 or
from A113.

This is on page 249

 

[Andy Wiggins]

Q1) I assume that in cell D7 there is a value of .85? If so then the
requirement is to EDIT the cell, remove the decimal point from before the 8
and put it in-between the 8 and 5 so that you end up with 8.5

Q2) A113 is a range reference. The give-away is the colon.

Have you looked in Excel's Help file?