Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Andy Wiggins
 
Posts: n/a
Default

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



Reply
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
Getting data from another excel file Union70 Excel Discussion (Misc queries) 0 May 2nd 05 02:17 PM
Creating Linked Workbook file name using cell variables RichT Excel Worksheet Functions 5 April 13th 05 07:44 PM
Newbie to charts question - projecting values between data points 38N90W Excel Discussion (Misc queries) 3 January 6th 05 05:15 AM
Creating a PDF file programatically from Excel Chaplain Doug Excel Discussion (Misc queries) 0 December 16th 04 08:49 PM
format question when open csv file Jeff Excel Discussion (Misc queries) 1 December 1st 04 06:53 PM


All times are GMT +1. The time now is 04:25 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"