Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
#2
![]() |
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Getting data from another excel file | Excel Discussion (Misc queries) | |||
Creating Linked Workbook file name using cell variables | Excel Worksheet Functions | |||
Newbie to charts question - projecting values between data points | Excel Discussion (Misc queries) | |||
Creating a PDF file programatically from Excel | Excel Discussion (Misc queries) | |||
format question when open csv file | Excel Discussion (Misc queries) |