Category Archives: Certification Exam Practice Questions

Practice Exam Question: Outlook 2010 – Block Junk Mail by Sender

outlook-pst-256_32

In Microsoft Outlook 2010,
how do you block Junk Mail by sender?

scroll-down

Answer:

1. In Outlook, on the Home tab in the Delete group, click the drop down arrow associated with the Junk button. Select Junk Mail Options.

2. Select the Blocked Senders tab in the Junk E-mail Options dialogue box. Click the Add button and enter the email address you wish to block. Click OK to confirm your entry. Repeat as necessary. When you’re finished, click OK in the Junk E-mail options box.

Outlook2010-Junk

Outlook2010-Junk-Options

-Katie Caplan,
Client Service Coordinator and Instructor,
Sector Learning Solutions

Advertisements

Practice Exam Question: Word 2010 – How to Create New Document Using Existing Template?

word-docx_win-256_32

In Microsoft Word 2010,
how do you create a new document based on an existing template?

scroll-down

Answer:

1. With Word already started, go into the Backstage view (File). Select the New command.

2. Choose any template you wish to work from (from any of the options available) and click the Create button (or double click). Voila!

Word2010CreateDocTemplate

-Katie Caplan,
Client Service Coordinator and Instructor,
Sector Learning Solutions

Practice Exam Question: Excel 2010 – Convert Existing Data into Table and Apply Table Style

In Microsoft Excel 2010,
how do you convert your existing data into a table and apply a table style to it?

Hint: As with so many functions in Microsoft Office programs across the board, there is more than one way to do this. The steps I take to achieve this particular goal may differ from what you would do, but if the end result is essentially the same then you’ve done it correctly!

scroll-down

Answer :

1. With your worksheet already open and on the screen, select the data from which you wish to create your table.

2. On the Home tab, in the Styles group, select the drop down arrow associated with the Format as Table button. Select the table style of your choice.

Excel2010DataTableBefore

Excel2010DataTableAfter

That’s all there is to it!

-Katie Caplan,
Client Service Coordinator and Instructor,
Sector Learning Solutions

New Blog Topic: Practice Exam Questions

I’m considering becoming certified in Microsoft Office and part of my decision-making process includes some (relatively) intense review of some of the various Microsoft Office programs. I’ve been going over our own courseware as well as looking at different online sources and some of my own books and practice files at home. In an effort to test my own knowledge as well as yours, I will be posting one skill testing question every month that I come across as I prepare for each Microsoft Office certification exam. Give the answer a shot and let us know what you’ve come up with.

Please note: I’ve based my questions on the Microsoft Office 2010 suite, but they can be adapted to whichever version you are using (2003, 2007, 2010, 2013).

-Katie Caplan,
Client Service Coordinator and Instructor,
Sector Learning Solutions