Tags: MOS, Office 2010
Transcender has partnered with G*Metrix, a technology testing provider, to offer you the Microsoft Office 2010 practice test products! Those who are familiar with our Office 2003 and Office XP products will find the same ease of grading and remediation text in the G*Metrix products. The Microsoft Word and Excel practice tests will also include a third pool of Transcender’s practice questions and corresponding explanations.
- 77-881 – MOS: Microsoft Office Word 2010
- 77-882 – MOS: Microsoft Office Excel 2010
- 77-883 – MOS: Microsoft Office PowerPoint 2010
- 77-884 – MOS: Microsoft Office Outlook 2010
- 77-885 – MOS: Microsoft Office Access 2010
- 77-887 – MOS: Microsoft Office Word 2010 Expert
- 77-888 – MOS: Microsoft Office Excel 2010 Expert
Users can choose from testing mode or training mode.
In either mode, the format and appearance of the test engine mirrors a live exam. The task(s) to be solved for each item appear(s) at the bottom of the screen below a fully enabled version of the Office 2010 product being tested. In training mode only, users can click the question mark at the lower right-hand corner of the screen and pull up a full tutorial that explains each step of the action to take to complete the task.
The practice test application is available as a download that installs on your computer. Because this simulates a live-in-the-application test, you must also have your own copy of Office 2010 installed to run the exam.
For more information on passing your Office 2010 exams, check out our earlier blog posts:
Tags: Beta Exams, MOS, PowerPoint
Certiport is seeking qualified individuals and test centers to participate in the MOS 2010 PowerPoint beta exam! The beta period is limited, currently scheduled for September 16th through September 28th, but the closing date to enroll in the beta program as a test candidate is Wednesday, September 8th and the closing date to enroll as a test center is Thursday, September 9th, so you have to act fast!
You don’t need to be a once and future master of PowerPoint Karaoke to participate. The requirements for test candidates are simple:
- Be a native English speaker, even if not living in an English-speaking country
- Have good familiarity with the 2007 PowerPoint application version
Certiport would prefer you also be familiar with PowerPoint 2010, although it’s not a strict requirement. Candidates who are familiar with 2010 features are very desirable for the program. Fortunately, you can download a beta version for a free trial from this link and make yourself eligible:
To enroll in the PowerPoint beta, you must contact one of the approved Certiport Testing Centers enrolled in the beta program:
|Name/Company||LOCATION||CITY||STATE/ PROVINCE||First Name||Last Name|
|Certiport Singapore Pte Ltd||SINGAPORE||Teck Seng||Nah|
|Lasalle Computer Learning Center||USA,||Tampa,||FL||Suzanne||Ricci|
|The Turn Around Agenda/Technology and Education Center||USA||Dallas||TX||Vonetta||Pelts|
|Idaho State University, College of Education||USA||Pocatello||ID||Brenda||Jacobsen|
|Penobscot Community Health Care||USA||Bangor||ME||Jennifer||McBee|
|Karen Todd Pickles CPI||USA||Madison||FL||Karen||Pickles|
|Lambton College (CCI)||CAN||Sarnia||ON||Kim||Hunt|
|CCI Learning Solutions Inc||CAN||Langley||BC||Daniel||Sweeney|
|Northwestern State University||USA||Natchitoches||LA||Mary Beth||Tarver|
|Welkin Systems Limited||Hong Kong||Kitty||Luk|
|MicroAge College Station||USA||College Station||TX||Richard||Carroll|
|The Training Foundry||UK||Sheffield||South Yorkshire||David||Rotherham|
|Advantage Caribbean Institute Ltd||WEST INDIES||Bentley||Beckles|
|ATG Testing Center||USA||Van Nuys||CA||Arman||Gasparyan|
|Maple Tronics Computers||USA||Goshen||IN||Gloria||Moser|
|Berry College-B.I.T.S.||USA||Mount Berry||GA||Daniel||O Sandberg|
|Micro Market Business Centre, (CCI)||CAN||Kingston||ON||Paola||Lockett|
|Latham & Watkins LLP||USA||Los Angeles||CA||Vivia||Weller|
|Qendra per Trajnim dhe Zhvillim e PTK-se||Republic of Kosovo||Prishtinë||Kosovo||Besnik||Skenderi|
|NR Computer Learning Center||USA||Orange||CA||Vazi||Okhandiar|
|In Demand Testing Account E||USA||New York||NY||Betty Lou||Herter|
|DreVon Software Training||USA||Jonesboro||GA||LeAndra||Jordan|
|Lytton High School||NZ||Gisborne||Maurice||Alfred|
|Time Saving Solutions, LLC||USA||Redmond||WA||Lynn||Landry|
|Zenos IT Academy||UK||Leeds||West Yorkshire||Zeshan||Sattar|
|Cherokee High School||USA||Canton||GA||Anna||Green|
|Salt Lake Community College-ACT||USA||Draper||UT||Joe||Fox|
|Dunbar High School||USA||Fort Myers||FL||Denise||Spence|
|Toronto Training Center For Information Technology and Business Accounting||CAN||Mississauga||ON||Mousa Abdallah||Hamdan|
|Lynn Testing Center||USA||Boca Raton||FL||Tammy||Swett|
|Global Information Technology||USA||Lathrup Village||MI||Paula||Artis|
If your favorite Testing Center isn’t on the list or you believe your test center can participate, there is still time to enroll by contacting Certiport directly. There are are few tidbits of information required from test centers; including: a single-point-of-contact, availability of the test center for the duration of the beta period, Certiport ID#, etc., but nothing too complicated – so be sure contact Certiport directly for the list of requirements.
~ Happy Beta Testing!
Tags: MCAS, MOS
Before attempting a Microsoft Office exam, you should be able to complete each task of the exam objectives quickly. The fact that you know how to do a task in your daily job might not cut it. You need to complete the task in the tight time constraints allotted for the test. Once you answer a question, you cannot go back.
First, a quick review of the objectives:
As we saw in the Office 2007 exams, the exam clock is 50 minutes. There are around 30 sub-objectives listed for each exam. Assuming one question per sub-objective, that’s 30 questions. When you remember that most questions ask you to perform multiple tasks, that’s more like 55 questions in 50 minutes – less than a minute per task. If you spend too much time on one question, you are losing time on the other questions. Time flies when you are under the gun. Most people I have talked to said that they could do all the tasks and pass the test…given enough time. However, they probably could not do it with the time constraints of the test. Practice each task until you know it like the “back of your hand.”
Here’s some MOS 2010 study tips from Ann, Josh, and George. It includes the stuff we did to prepare for the exam that worked for us, and the things we wish we’d tried.
First, free is free. Download the e-book First Look: Microsoft Office 2010 from http://www.microsoft.com/learning/en/us/training/office.aspx (registration required). It’s not a very in-depth feature guide, but this book is useful on multiple levels; just looking at the features that Microsoft chooses to highlight gives you a feel for what might be asked on the exam. This is particularly useful if there are features you just don’t use daily and wouldn’t otherwise think to practice.
For more free instruction, don’t forget blogs and communities. You can find targeted, in-depth articles on certain features in many places, including:
- The Official Microsoft Excel 2010 blog
- The Official Microsoft Word 2010 blog
- Network World’s Author Expert blog for Excel 2010
- Learning Snacks
What about official study guides? Well, at last check, the Microsoft Press MOS 2010 Study Guides are due out late fall 2010. Keep checking the Microsoft Office Training Portal for announcements.
Don’t have a copy of Office 2010 to practice on yet? You can download a trial of Office 2010 here: http://office.microsoft.com/en-us/products/office-products-FX101825692.aspx?assetid=FX010048741 (requirements vary by system).
The key aspect to both Microsoft Word and Excel 2010 exams is the ribbon. You have to know where to find common functionalities, or else you will not complete the exam in the allotted time. Josh downloaded and used the free Ribbon Hero plug-in to practice for the exam, and I have to admit it was low on the goofy factor (this is not the talking paperclip of days gone by) and high on the challenge factor. Create a complicated Smart Art diagram in three clicks of the ribbon bar? Sure! I just…well, I’m used to using the menus, aren’t I? Huh. How do I do that again? (Fortunately, it tells you how if you get stuck.)
Remember: many roads lead to Rome
To succeed on the Microsoft Office 2010 exams, you should be familiar with the different ways to achieve a goal. For example, included in the description of the Create Tables sub-objective, under the Formatting Content objective of Microsoft Word, you should know how to use the Insert Table Dialog Box, draw a table, insert a Quick Table, Convert text to tables, and use a table to control page layout. I habitually create tables in Word from the Insert Table menu, so I took the time to practice those other routes.
Because the way we do things in our Office applications every day may not be the most efficient way when the exam clock is ticking down, we urge you to practice familiar tasks from multiple approaches (use a wizard, use a ribbon button, create a shortcut). This way, no matter how you are asked to accomplish a task, you’ll be familiar with the specific terminology used.
If you combine these techniques with a solid knowledge of how to use Word and Excel, you will be well prepared to pass your MOS 2010 certification exam. Good luck!
Tags: MOS, Office 2010, test-taking tips
“A rolling stone gathers no moss.” — English proverb
Earlier this month, a couple of colleagues and I took the new Word and Excel 2010 core exams. Of the three of us, I was the only person who had never sat for an Office exam, but I’ve been a Microsoft Word user since installing Office for Windows 1.0 from a 5 1/4″ floppy, so I didn’t think I’d have any problems.
Although they were released on June 30, the Office 2010 Word and Excel exams were not available in our nearest and dearest testing centers. As it turns out the bleeding edge of MOS certification is located in rural Rome, Georgia, two hours outside of Atlanta, on the 25,000-acre campus of Berry College. The drive was long, but the scenery was gorgeous: farm fields, rolling hills, and periodic “See Rock City!” billboards.
Sidebar: My favorite sight was a group of teenagers on horseback riding up to a gas station to buy sodas.
Once we finally got to Rome, as several roads turned out not to lead there at all, our Certiport test proctor was wonderfully accommodating, and more than pleased to have three guinea pigs for the new exam series.
Before setting out, of course, we thoroughly reviewed the published exam objectives. They’re more detailed and explicit than the 2007 counterparts.
As objectives go, these are pretty unambiguous. Notice, however, that the objectives range in complexity; saving an open document as a template is much simpler than performing mail merge tasks. We also expected that the Ribbon would be key to the exam experience, so we made sure we knew what each button accomplished.
The fine print
The MOS exams are each 50 minutes long and ask a series of scenario-based questions. These first two Office 2010 exams are similar to their 2007 predecessors in that the exams are live-in-the-application, meaning you are using a full version of the software with the Help function disabled. Pop-ups are still active (for example, if you hover your mouse over the B button on the Home tab, a note will pop up saying “Make the selected text bold”).
While it seems you’re allowed to take any path to a result, there’s no crying in baseball and there’s no backtracking in MOS. Once you finish with a scenario, you have to move on to the next set of questions without the option of returning later. If you get mired inside of one scenarios and need to start over, there’s a handy “Reset” button. This resets only the active question, not the entire test.
We started with the test we thought would be more difficult for us: Excel 2010. Josh started pounding through it like a machine. George was sweating a little, but I could hear the steady click click clicks from his terminal. Meanwhile, Excel stomped me into the dirt. Now, I hate to lose and I hate to fail, but I have to admit this failure was a badly needed lesson for me.
I’m an adequate daily user of Excel 2007. I had reviewed the 2007-to-2010 feature changes, but gaps in knowledge aside, I can truthfully say the live exam killed me for one reason alone: I didn’t watch my time. While George and Josh clicked feverishly along, I pondered and guessed and spent long minutes hunting up and down the menus. End result: I didn’t even get to a third of the questions, while the guys both finished with minutes to spare. There were most likely more questions I could have answered, but just didn’t get to.
Unlike the 2007 objectives for Excel, the 2010 exam Objectives focus much more on graphics than on formulas and functions. So take a tip from my hard-learned lesson – don’t sweat the small stuff, mind the clock, focus on the task at hand, and manipulate the data in the way the tasks require, and you should be able to click, click, click with time to spare.
After a brief break, we moved on to Word 2010. I expected to get 100% (I was seriously miffed that I scored just under 90%). Again, this was a test where you had to know exactly which menu or mouse-click hid your required task and go straight to it if you expected to finish on time. Given my broader knowledge of Word, I was able to blast through nine-tenths of the questions I saw and then grant myself a bit of leeway one of the harder scenarios, testing different options until I had as close to a correct answer as I could manage. But I had learned my lesson from Excel, and kept my eye on the ticking clock as I went through the test.
One of us left the test center with two sparkly new certifications (overachiever!), while the rest of us (yours truly included) proudly walked away with one certification each.
Look for one more blog post in the Office 2010 series where I go over the targeted study advice we wish we’d followed before taking the exams.
Tags: MCAS, MOS
As you get ready to dive into the new suite of Microsoft Office 2010 products, don’t forget recent updates to the certification track! The Microsoft Office 2007 exams that released under the Microsoft Certified Application Specialist (MCAS) designation have been renamed to Microsoft Office Specialist (MOS) and will now include the Office 2010 exams.
Those of you certified in Office 2000, 2002, and 2003 products will recognize the MOS certification and this recent change will not affect those existing credentials. With the Office 2007 release, the MOS terminology was retained for older products, the new generation of 2007 certifications were branded MCAS, and all were held under the umbrella of the Microsoft Business Certification (MBC) program. The MBC program was not limited to the Office suite, but included business-oriented technologies like Vista desktop operations and project management.
Confused yet? Hang in there – it gets easier from here on out!
The uniform MOS nomenclature, re-adopted as of June, makes it easier for candidates to identify exactly which certifications and technologies will best benefit their careers. All exam numbers for Office-related tests (such as 77-601) remain unchanged. Still, the Internet contains a lot of confusing references to older names and outdated certification paths, so in the interest of clearing it up, here’s the breakdown:
If you previously earned an MCAS, the certification is unchanged except for the name. In fact your transcript will be updated to reflect the certification track name change, but you can choose which designation to use in your signature and which logo to use on your resume. So exam names & numbers, not changed; certification acronym, changed.
Now that I’ve thoroughly UN-confused you (I hope!), it’s time to report that we’ve seen the new core-level MOS 2010 exams for Excel and Word. In an upcoming post we’ll report that all roads don’t quite lead to Rome, it doesn’t pay to cram, and the rolling stone is the ONLY kind that will gather this particular MOS…
Tags: Excel, MCAS, MOS, Office 2010
Now that you’ve learned how to quickly summarize your Excel data, we’ll conclude the new features in Excel 2010 with the slicer.
The slicer is a filter you can apply to PivotTables and PivotCharts. Slicers can add or remove elements from a table display and be reused across multiple tables. Enough theory; enter the real-world.
Let’s say that you work for a big pharmaceutical company and you’ve got the following data (excerpted only).
So, to allow sales managers to parse the data easily, you create a PivotTable as follows:
But maybe a sales manager wants to filter the data dynamically by drug name or category value. What can you do?
This is where the slicer comes into play. Let’s create two slicers: one for the drug name and the other for the category. A sales manager can then filter the data to display only non-drug sales as follows.
If you select option(s) from the Category slicer, then only drugs from those categories are available in the Pharmaceutical slicer to filter. Only those options selected in these slicers will be displayed in the PivotTable. These slicers can then be applied to other PivotTables or PivotCharts.
The slicer highlights non-filtered fields and displays a lighter highlight for fields that do not match the filter criteria. You can even customize the color scheme and general appearance of these slicers to your heart’s content.
So, don’t be intimidated by manager requests for data filtering. Give them some slicers and let them do their own filtering with Excel 2010’s new interface.
Tags: Excel, MCAS, MOS, Office 2010
Continuing our tour through the new features of Office 2010, we move into Excel. The new version of Excel includes graphic improvements in conditional formatting and new functions for engineering and cube analysis (if you don’t know what a data cube, you’re better off not knowing). But Excel has some mores surprises in store. Namely, sparklines and slicers.
To understand what a sparkline is, we need to revisit a common problem with data tables and charts.
If you want to ensure that your meeting audience doesn’t nod off and wake up in their own drool, you need to make data interesting. So, you make a chart. But, then that one person gets all up tight and insists on seeing the numbers, and you have to fumble around to look it up. Wouldn’t be swell if you could keep your data table, but still retain a bit of that chart excitement?
Enter sparklines. Sparklines are basically inline summary charts. To use one, you simply select a data range and then choose the Line, Column, or Win/Loss style. The SparkLine tools section provides many customization options. You can choose whether to mark the low and high point markers, modify the line or bar style, and set the sparkline and marker colors.
So now our data table has a visual summary column as follows.
Hey! I never promised the next James Cameron 3D epic, but it certainly works better for those visualizers out there, right? Next session, we’ll focus on the new analysis cube features and slices!
–Joshua Hester aka codeguru, Transcender’s MCAS test developer and in-house nerf herder
Tags: MCAS, MOS, Office 2010, Word 2010
As the impending release of Office 2010 looms, we here at Transcender are preparing for the next generation of MCAS certification exams. So what better time is there than now to highlight the new features of Office 2010? Rather than bore you with a laundry list of nuanced improvements, though, we’ll focus on a new functionality for each of the applications in the Office 2010 suite.
Remember that this is the Technical Preview and some features may change by the final release.
Let’s begin the journey with Word 2010, the desktop workhorse. Since Word 2007, many advanced formatting features available in previous versions have been exposed through the Office Ribbon. (On that note, Microsoft Office Labs recently released the Ribbon Hero game to help power users adapt better to the Ribbon interface.)
The Ribbon was introduced in 2007, and looks largely unchanged in 2010. However, a brand-new functionality in Word 2010 is the suite of built-in artistic effects for graphics. For example, let’s take the following image and apply some artistic effects.
The Artistic Effects menu provides some intriguing Adobe Photoshop-style filters to make things interesting. It provides everything from pencil and brush strokes to screen effects. And the preview function, introduced in Office 2007, lets you quickly see an application preview in the menu itself.
So we can make the image look like a pencil drawing with the Pencil Grayscale effect …
Or apply the Plastic Wrap effect for more 3D impact …
Or if you are going for something completely different, then you can use the Glow Edges effect (black light bulb optional) …
In Word 2010, as in Word 2007, you can still apply color corrections, 3D and shadow effects, and compress and crop images. To retrieve these screenshots, I used the new Screenshot menu. From this menu, you can also insert screenshots (captured using the PrintScreen key) into Word documents.
Word 2010 also offers many advanced layout options specifically geared toward books and other publication types.
That concludes the new graphic bling in Word. Next week, we’ll move onto the new data analysis capabilities in Excel 2010.
–Joshua Hester aka codeguru, Transcender’s MCAS test developer