Microsoft Office 2010 (MOS): practice products for Core and Expert certifications

December 13, 2011 at 9:20 am | Posted in Kaplan IT Training news, Microsoft | Leave a comment
Tags: ,

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.

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:

MOS 2010 PowerPoint beta exams want YOU – only one day left!

September 7, 2010 at 5:05 pm | Posted in Microsoft | Leave a comment
Tags: , ,

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
F-Keys Ltd UK Gillingham Kent Alex Waterton
Penobscot Community Health Care USA Bangor ME Jennifer McBee
AAA PCITS USA Lawrenceville GA Pamelia Evans
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
Sawyer Training USA Minneapolis MN George Sawyer
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
SkillSoft Canada Fredericton NB Cathy Colpitts
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
S&G Training UK Swanley Kent Nicola Joyce
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
Infotest GREECE Kallithea Georgios Tsoupos
Oakwood University USA Huntsville AL Odessa Jordan
Global Information Technology USA Lathrup Village MI Paula Artis
Prodigy Learning SP Andrew Flood

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!

Office 2010 MOS study tips & tricks

September 1, 2010 at 10:21 pm | Posted in Microsoft, Study hints | 68 Comments
Tags: ,

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.

Study Guides

First, free is free. Download the e-book First Look: Microsoft Office 2010 from (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:

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: (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!

Taking the Office 2010 exams: the rolling stone gathers the MOS

August 26, 2010 at 3:22 pm | Posted in Microsoft, Performance-Based Testing, Study hints | 11 Comments
Tags: , ,

“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.

The preparation

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.

The experience

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.

The results

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.


The experience

For Office 2010, make the MOS of your MCAS

August 24, 2010 at 9:46 pm | Posted in Certification Paths, Microsoft | Leave a comment
Tags: ,

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…

Stay tuned!

-Ann Lang

Office 2010: Slice Excel Data Your Way

April 5, 2010 at 9:54 am | Posted in Microsoft, Technical Tips | Leave a comment
Tags: , , ,

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.

Office 2010: Spark some interest in Excel!

February 25, 2010 at 2:20 pm | Posted in Microsoft, Technical Tips | Leave a comment
Tags: , , ,

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

Office 2010: A Tool That’s Worth a Thousand Words

February 19, 2010 at 1:28 pm | Posted in Microsoft | Leave a comment
Tags: , , ,

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.)

Office 2010 Ribbon

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.

Original Image

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 …

Image with Pencil

Or apply the Plastic Wrap effect for more 3D impact …

Image with Plastic Wrap

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

Entries and comments feeds.

%d bloggers like this: