[mso] MOS Excel 2003 Expert Question
- From: "Renee Hughes" <reneehughesworks@xxxxxxxxx>
- To: <mso@xxxxxxxxxxxxx>
- Date: Thu, 12 Jul 2007 12:13:27 -0500
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit
I apologize ahead of time for the long message. I just took the Excel 2003
Expert exam for the second timed and failed again. I'm really disappointed
and wanted to get some help on some items. Linda's book helped me a LOT, my
scores went way up and I definitely would recommend it. Here are the items I
have questions about.
1. XML Mapping - I was asked to map elements from XML to a worksheet. I
went into XML Source opened it and to the right I got a dialog box with a
tree of elements. I was suppose to put those elements in the workbook, but
when I dragged the elements from the tree into the requested cells, nothing
happened. I couldn't get the headings to change.
2. I was asked to load the Analysis tool pack and to do something with a
regression chart, I can't remember the exact question, but wondered if I
could get some more detail on what regression is
3. I was asked to change the legend on a chart to include the category
names on the spreadsheet, I couldn't figure out how to do this on chart
options
4. I was asked to explode the data points, didn't know that one
5. I was asked to add a trendline and show exponential growth on a
chart. When I went to click on the chart so that I could choose "add a
trendline" from the chart menu, the menu would not change to chart it
remained data and I didn't know how else to add the trendline. I went to
chart type to change the chart type to trendline but not sure if that was
right
6. It asked me to place the merge and center button next to print
preview in a new group. I know how to add a button to the toolbar, but what
did it mean by "new group"
Thanks again for a great book, it really did help a lot I just got hung up
on these steps above and it was enough to keep me from passing. I retake for
the 3rd time Thursday and am hoping to get enough info to put me over the
top.
Renee Hughes
-- No attachments (even text) are allowed --
-- Type: image/jpeg
-- File: image001.jpg
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, visit the group's homepage and use the dropdown
menu at the top. This will allow you to unsubscribe your email address or
change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso
To be able to share files with the group, you must join our Yahoo sister group.
This group will not allow for posting of emails, but will allow you to join
and share problem files, templates, etc.:
http://tech.groups.yahoo.com/group/MicrosoftOffice . This group is for FILE
SHARING ONLY.
If you are using Outlook and you see a lot of unnecessary code in your email
messages, read these instructions that explain why and how to fix it:
http://personal-computer-tutor.com/abc3/v28/greg28.htm
*************************************************************
Other related posts:
