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

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
A1:D3. Clear all the contents, formats and comments from the range. Display
sheet3, select A1:D134, 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 A1:D13 - does that mean select only cell A1 & D13 or
from A1:D13.

This is on page 249
--
Thanks for your for your help and time

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) A1:D13 is a range reference. The give-away is the colon.

Have you looked in Excel's Help file?

--
Andy Wiggins FCCA
www.BygSoftware.com
Excel, Access and VBA Consultancy
-

"Dora" (donotspam wrote in message
...
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
A1:D3. Clear all the contents, formats and comments from the range.
Display
sheet3, select A1:D134, 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 A1:D13 - does that mean select only cell A1 & D13
or
from A1:D13.

This is on page 249
--
Thanks for your for your help and time