Knowledge of Microsoft Office Skills Test

Knowledge of Microsoft Office Skills Test Answers

Question: 1

What does 'Class A office space' commonly refer to?
    a.     Office space on former sites of class A drug offenses.
    b.     The lowest quality office buildings in a given area. (Answer)
    c.     The highest quality office space available in a given area.
    d.     The highest quality office space for the least price.

Question: 2

Traditionally, approximately how many pages should a business CV or resume have?
    a.     1-3, preferably 2
    b.     1-5, but usually 2-3
    c.     Just 1
    d.     Exactly 2 and a half, and never more or less (Answer)
    e.     All of the above

Question: 3

what is the normal length of notice period for quitting job in most professional offices?
    a.     Either 2 weeks or 1 month
    b.     2-3 months
    c.     1 week
    d.     Up to 3 months, or longer
    e.     None of the above (Answer)

Question: 4

What is the most frequently used typeface and point size when creating Word documents?
    a.     Times New Roman, 12 point
    b.     Times, 14 point
    c.     Courier New, 12 point
    d.     Courier New, 14 point
    e.     All of the above (Answer)

Question: 5

What does 'the bottom line' commonly refer to in an office environment?
    a.     The line that appears at the bottom of a paper with the  company letterhead.
    b.     The lowest office floor in a building.
    c.     The same as the dotted line.
    d.     The basic controlling factor, notably the financial cost, regarding whether a task or project can be accomplished or not. (Answer)

Question: 6

Which of the following are not recommended when trying to improve working with others in an office environment
    a.     Talking when others are talking, and listening only occasionally.
    b.     Being as consciously helpful as possible, and offering practical solutions. (Answer)
    c.     Changing the printer ink or cartridge when it runs out.
    d.     None of the above

Question: 7

What is the difference between Microsoft Access and Microsoft Excel?
    a.     Access is mainly for spreadsheets and Excel is for databases
    b.     Access is mainly for databases and Excel is for spreadsheets
    c.     Access is mainly for databases and Excel is for word processing (Answer)
    d.     Access is mainly for word processing and Excel is for spreadsheets, including digitial photograph editing

Question: 8

What two kinds of printers are commonly in use in most office environments?
    a.     Industrial and private (Answer)
    b.     Hewlett Packard and Brother
    c.     Laser and ink-jet
    d.     Black-and-white and color
    e.     None of the above

Question: 9

what information would the petty cash register contain?
    a.     Details of expenses on account of the administrative staff.
    b.     Details of small expenses related to the running of the office.
    c.     Details of expenses on account of electricity and water bills. (Answer)
    d.     Details of expenses worth less than $80.

Question: 10

What is 'outsourcing'?

    a.     Working outside the office, often from home.

    b.     Freelancing work to workers outside the main office building, often to foreign workers for cheaper labor costs.

    c.     A form of half working from home, half at the office.

    d.     Leaving work early. (Answer)

Question: 11

What are the dimensions of an A4 size sheet of paper?

    a.     216 mm x 279 mm

    b.     220 mm x 310 mm

    c.     215 mm x 295 mm (Answer)
    d.     210 mm x 297 mm

    e.     a and d

Question: 12

What is the appropriate response to discovering the printer is out of ink? 

    a.     Force the printer to deliver the last drop of ink by turning it upside down, holding it carefully.

    b.     Walk away and tell a fellow office worker, hoping he or she will take responsibility. (Answer)
    c.     Leave it to the next person.

    d.     Replace the ink if the cartridge is available otherwise follow the office procedure for replacing or ordering the cartridges.

Question: 13

You realize that the computer in your office is getting a lot of spam and unwanted e-mails. What should be your first action to stop these emails? 

    a.     E-mail the Regulatory Authority in charge of stopping spam in order to complain.

    b.     E-mail the source of the emails asking them to stop them. (Answer)
    c.     Call over a computer expert to solve the problem.

    d.     Look for a Remove From Mailing List link in the email.

Question: 14

Which of the following are proven methods of improving your office skills? 

    a.     Smiling and being appreciative of others, especially the clients.

    b.     Actively listening to, even humoring people at times.

    c.     Looking to resolve conflicts and bringing people together.

    d.     Conveying what is expected in return as an appropriate response, and avoiding ambiguity.

    e.     All of the above (Answer)

Question: 15

What does the CTRL+V shortcut accomplish in Word 2007?

    a.     It makes the selected text appear in bold.

    b.     It pastes the text that has already been copied.

    c.     It converts the selected text into the next larger size of the same font. (Answer)
    d.     It applies italic formatting to the selected text.

    e.     All of the above

Question: 16

You send a package through FEDEX to a client in Korea. The client calls up after a few days and says that he has not received it. What is the best way to immediately let the client know the status of the courier? 

    a.     Give the client the airway bill number and ask him to call up FEDEX about the status of the courier.

    b.     Give the client the local number of FEDEX in Korea.

    c.     Call FEDEX and ask them to speak directly to the customer.

    d.     Track the packet on the FEDEX website and send the client a copy of the current status of the packet. (Answer)

Question: 17

Your computer is not printing and a technician is not available, so you perform the following activities to investigate the problem. In which order should you take these up?

1 See if the printer cartridge is finished

2 See if the printer is switched on

3 Try to print a test page using the printer self-test

4 Try to print a test page from Windows

5 See if the printer is properly attached to the computer

    a.     5,4,3,2,1

    b.     3,2,1,4,5

    c.     3,5,4,1,2 (Answer)
    d.     2,3,1,5,4

    e.     3,1,5,2,4

Question: 18

You are required to create a cost report for your department, and then present the report to the board. Which two programs would you use for these two tasks?

    a.     MS Powerpoint, MS Access

    b.     Adobe Photoshop, MS Powerpoint

    c.     MS Word, MS Excel (Answer)
    d.     MS Excel, MS Word

    e.     MS Excel, MS PowerPoint

Question: 19

What is very important to remember to do when entering an office business meeting at any level, especially when clients are there?

    a.     Bow slightly before your superiors or company executives.

    b.     Take the coats from clients and drape them over your arm during the meeting. (Answer)
    c.     Turn off all cell phones, pagers and other electronic devices.

    d.     Turn on all cell phones, pagers and other electronic devices.

    e.     a and c

Question: 20

According to standard filing conventions, in which order will the following three documents be filed?

Dr. Jones's office, Doctor at sea, Doctor come quickly

    a.     Dr. Jones's office, Doctor at sea, Doctor come quickly

    b.     Doctor at sea, Doctor come quickly, Dr. Jones's office (Answer)
    c.     Doctor come quickly, Dr. Jones's office, Doctor at sea

    d.     Dr. Jones's office, Doctor come quickly, Doctor at sea

Question: 21

When a client visits the office and arrives early, what does office etiquette require you to do to handle the situation?

    a.     If you are free, allow the meeting to start early.

    b.     Take their coat, offer them something to drink, and tell them you won't be a moment.

    c.     Try and meet them as soon as possible.

    d.     All of the above. (Answer)

Question: 22

You work in a company where some of your co-workers are recent foreign immigrants. They are unfamiliar with the work environment and your supervisor is polite to everybody in the staff but is often rude to these foreign workers. What will you do in this situation?

    a.     You talk to the foreign workers and tell them that they should complain to the Upper Management. (Answer)
    b.     You tell your supervisor that his misbehavior is inappropriate.

    c.     Nothing, you prefer to keep quiet because everybody else is quiet.

    d.     You complain to the Upper Management.

Question: 23

What are the traditional office hours in the Western world, now much more flexible, though still adhered to in most offices?

    a.     9 AM — 5 PM

    b.     6 AM — 6 PM

    c.     8 AM — 7 PM

    d.     10 AM — 8 PM

    e.     None of the above (Answer)

Question: 24

What does the 'glass ceiling' refer to in a business context?

    a.     The internal ceiling above the boardroom, whether it is on the top floor or not.

    b.     The roof of the company building, frequently constructed from glass to optimize the company's public status for the surrounding area.

    c.     The upper level of senior management or company executive positions which is traditionally hard to break through, for example, for women and/or minorities. (Answer)
    d.     The imaginary level above the CEO at which the company profits skyrocket.

Question: 25

Consider the following sentence:

'There are 20 new PC's in the accounts department.'
Should there be an apostrophe in PC's?

    a.     No

    b.     Yes

    c.     Not sure (Answer)
    d.     No idea

    e.     None of the above

Question: 26

What is a 'golden handshake'?

    a.     The welcome to the building of a new CEO.

    b.     The last day in the office before the holidays.

    c.     The common usage for a generous employment severance package when an executive loses his or her job through restructuring, redundancy or a scheduled retirement.

    d.     The common usage for a series of re-hirings of past employees. (Answer)
    e.     c and d

Question: 27

What is the best practice for ensuring that sensitive material to be destroyed does not leak out of the company building? 

    a.     Always encrypt on computer disk, and shred any hard copies.

    b.     Shred hard copies, save onto the file. (Answer)
    c.     Burn hard copies, save only once to the file.

    d.     E-mail documents to colleagues, and then close the e-mail browser.

Question: 28

What is the benefit of e-mailing documents rather than always providing hard copies to individuals? 

    a.     There is no benefit except that people can delete them more easily.

    b.     The documents can potentially be edited online and re-circulated.

    c.     The documents can be electronically forwarded, which saves stationery that may otherwise be used.

    d.     b and c (Answer)

Question: 29

What is 'flexi-time'?

    a.     The feeling when time slows down or speeds up at certain times of the day in an office environment.

    b.     The flexible use of personal office hours, such as working an hour earlier one day, in order to leave an hour earlier another day.

    c.     Occasionally moving the hands on the office clock so everyone can go home early now and then. (Answer)
    d.     Bringing an alarm clock to work that rings at the end of the day and at lunchtimes.

Question: 30

With regard to emails, when is bcc: used? 

    a.     When you want to send the same mail to several people and do not want the To: and cc: recipients of the mail to know the bcc: recipients of the same mail.

    b.     When you want to send the same mail to several people and do not want the bcc: recipients of the mail to know who else the mail was sent to. (Answer)
    c.     When you want to send the same mail to several people and want to receive acknowledgments from each recipient.

    d.     When you want to send the same mail to several people, but the mail does not support attachments.

Question: 31

What is the best way to handle an angry colleague or client with a complaint?

    a.     Listen to their concerns, and calmly but firmly explain what you are able to do, offering other solutions and options, without getting angry in turn.

    b.     Show a little anger as a way of evening out the situation.

    c.     Shout back, and then, later in the day, find a place to sulk, or time to complain to your own boss. (Answer)
    d.     Listen to their concerns, politely explain what you are able to do, and if they insist, shout back your own concerns and complaints.

Question: 32

What is a 'mouse potato'(a comic phrase in an office environment)? 

    a.     The equivalent of a couch potato, but in terms of using a computer — i.e. someone who spends all their time at a computer.

    b.     A virus or other harmful computer bug, such as a 'trojan horse'.

    c.     An office ornament that workers place on their desks to keep them motivated during office hours.

    d.     b and c  (Answer)

Question: 33

What is the person in charge of administering an office commonly called?

    a.     Office Assistant

    b.     Full-time Manager

    c.     Office Manager (Answer)
    d.     CEO

    e.     None of the above

Question: 34

When replying to an e-mail, who do you place in the cc: line and who in the bcc: line? 

    a.     A person you wish to openly inform goes in the cc: line, and the same person in the bcc: line.  (Answer)
    b.     A person you wish to openly inform goes in the bcc: line, and the same person in the cc: line. 

    c.     A person you wish to openly inform goes in the cc: line, and the person you wish to read the e-mail, but without the knowledge of either the recipient or the person in the cc: line, goes in the bcc: line. 

    d.     A person you wish to openly inform goes in the cc: line, and the person you wish to read the e-mail without the knowledge of the recipient, but with the knowledge of the person in the cc: line, goes in the bcc: line. 

Question: 35

Which of the following are commonly used computer web browsers? 

    a.     Mozilla, Guardian Website, The Times of London, MSN

    b.     Expedia, Opodo, Student Universe, Godzilla

    c.     Chrome, Explorer, Firefox

    d.     Google, MSN, Yahoo, Ask (Answer)

Question: 36

What is 'commodity value,' an important business term of relevance to most office environments? 

    a.     The value of all the office hardware, including computers and furniture.

    b.     An economics term meaning the intrinsic value under optimal, often free market conditions, of the product the company sells or manufactures.

    c.     The value of common decency between employees of a given office.

    d.     The cost in petty cash of all company expense dinners in a given month.

Question: 37

Which of the following file formats relate to a graphic file or scanned image file? 

    a.     JPEG (Answer)
    b.     VBP

    c.     HTML

    d.     GIF

    e.     a and d

Question: 38

What does the abbreviation CEO stand for? 

    a.     Company Executive Officer

    b.     Communicate Especially On

    c.     Corporate Exact Office (Answer)
    d.     Cheat Every One

    e.     Chief Executive Officer

Question: 39

Which of the following are the most important components of good interpersonal office skills? 

    a.     Effectively translating and conveying information.

    b.     Being able to accurately interpret other people's emotions.

    c.     Calmly arriving at resolutions to conflict.

    d.     Avoiding gossip and being polite.

    e.     All of the above (Answer)

Question: 40

When you are introducing a woman and are unsure of her marital status, which title should you use? 

    a.     Ms.

    b.     Miss

    c.     Mrs. (Answer)
    d.     Madam

None of the above

Question: 41

Which of the following actions CANNOT be performed by the user on the Business Contact Manager database?

a. Update records

b. Create new records

c. Delete records permanently

d. Move records to the Deleted Items folder

Question: 42

Dave receives a file named Theme1.thmx from his boss. Opening the file opens a blank PowerPoint document. On clarifying from his boss, he learns that the .thmx file contains a particular theme which needs to be applied to the annual report on which Dave is working. How can Dave achieve this?

a. By pasting all the text of the report in thePowerPoint file which opens on double clicking the .thmx file and then saving it as a Word document.

b. By opening the .thmx file with Microsoft Word 2010 and pasting the complete report text into it.

ans c. Dave’s Boss is wrong. No such arrangement is possible in Microsoft Word 2010.

d. By opening the Word file containing the report, and importing the theme from the .thmx file by using the “Browse for themes” option on the Page Layout tab.

Question: 43

Which of the following types of worksheets will not load in Microsoft Excel Services?

a. Worksheets with ActiveX controls

b. Worksheets with tables

c. Worksheets with hyperlinks

d. Worksheets with Organization Charts and Diagrams

e. All of the above

Question: 44

What are the benefits of digitally signing an e-mail in Microsoft Excel 2010?

a. Digital signatures help authenticate the source of the messages.

b. Both the sender and the receiver of a message can verify that the message has not been altered during transmission, if the message is digitally signed.

c. Digitally signed e-mails meet legal requirements for admissibility and authenticity.

d. All of the above.

Question: 45

If I do not want the contents of one of my fields to automatically update, I would have to do which of the following?

a. Lock the field.

b. Protect the field.

c. Make the field hidden.

d. Turn field shading off.

Question: 46

When using the booklet-printing feature, the term “gutter” refers to the space between page content and the fold in the middle of the paper where you would normally bind pages together.

a. True

b. False

Question: 47

You have just created a new document based on the normal template and have created a custom style. You now want to make that custom style easily available in all future documents. In order to do this, you need to select:

a. “Add to Quick Style List” in the Styles pane.

b. “New documents based on this template” under modify style option.

c. Copy the style to each document manually each time you want to use it.

Question: 48

In MS 2010 PowerPoint, how would you crop a picture to an exact set of dimensions?

a. Under Picture Tools, on the Format tab, in the Size group, click Dialog Box Launcher, then Crop. Enter the size numbers in the Width, Height, Left and Top boxes.

b. Select the picture and right click on it. Select Size and Position from the list and then enter the size numbers in the Width, Height, Left and Top boxes.

c. Both a and b

d. None of the above

Question: 49

How will you read comments that reviewers have added to your presentation?

a. On the View tab, in the Show/Hide group, click on Show Comments.

b. On the Review tab, in the Comments group, click on Show Markup.

c. Both a and b

d. None of the above

Question: 50

Which standard form is used to record actions which relate to specific contacts and put the action in a Timeline view?

a. Post

b. Journal Entry

c. Appointment

d. Task Request

Question: 51

How many items can be maintained on the clipboard at one time?

a. One

b. Up to 24

c. Unlimited

d. Up to 100

Question: 52

Which of the following is INCORRECT regarding setting of passwords in Microsoft Outlook 2010?

a. There is no logon password for the Outlook program itself. The password you set protects only your Outlook data file (.pst) that is used in Outlook.

b. If you are running Outlook with a Microsoft Exchange account, your data for that account, including password access, is automatically managed by Microsoft Exchange.

c. You can set a password for individual folders within the .pst.

d. None of the above

Question: 53

What does the Compare tool do?

a. Compares changes in two presentations

b. Compares one image to another to indicate differences

c. Compares file size

d. Compares presentations for backward compatibility

Question: 54

What is one thing the Compress Pictures feature does?

a. Changes all pictures from color to black and white

b. Decreases the contrast of all pictures in the presentation

c. Permanently deletes cropped areas of pictures

d. Condenses the pictures to one area of the slide

Question: 55

How would you assign a macro to a graphic?

a. On the Developer tab, in the Code group, click on Macros.

b. On the View tab, click on Macros and then click on Assign Macro on the shortcut menu. In the Macro name box, click on the macro that you want to assign.

c. On a worksheet, right-click on the graphic, then click on Assign Macro on the shortcut menu. In the Macro name box, click on the macro that you want to assign.

d. You can use any of the above three techniques.

e. You cannot assign a macro to a graphic.

Question: 56

How would you add a logo to all the slides in a presentation?

a. In the Normal editing View, paste the logo onto every slide in the presentation.

b. In the Slide Master View, add the logo to the slide master and the title slide layout.

c. In the Slide Master View, add the logo to the blank slide layout.

d. None of the above

Question: 57

Which among the following settings is the default macro security setting?

a. Disable all macros without notification.

b. Disable all macros except digitally signed macros.

c. Disable all macros with notification.

d. Enable all macros.

Question: 58

Which of the following tag is not available in Microsoft Outlook 2010?

a. Unread/read

b. Follow Up

c. Categorize

d. Show in Favorites

Question: 59

How do you insert a new slide master into a presentation?

a. In Master View, click the Insert Layout button

b. In Master View, click the Insert Slide Master button

c. In Slide Sorter View, click the Insert Slide Design button

d. In Normal editing View, click the Insert Slide Design button

This question is based upon the figure shown below

Question: 60

In the given screenshot, there are red triangles in the upper-right corner of each cell under the column titled ‘Registrations’. What do these signify?

a. The red triangles represent the comment associated.

b. The red triangles signify an associated data validation control.

c. The red triangles represent the tracking of the cell.

d. The red triangles signify that the cell is a hidden cell.

Question: 61

Which of the following statements regarding images in Microsoft Excel 2010 are true?

a. Microsoft Excel 2010 validates images which are in the form of external and active content.

b. Microsoft Excel 2010 provides for changing the sharpness and contrast of images but not changing their transparency.

c. Microsoft Excel 2010 supports 3D rotation of images.

Question: 62

How do you repair a Microsoft Outlook 2010 .pst file if it gets damaged?

a. By using the last backup .pst file.

b. By scanning the .pst file with scanpst

c. By re-logging into the mail account.

d. The file cannot be repaired.

Question: 63

Format Painter will not normally work with pictures in which the text wrapping is set to:

a. Square

b. Behind Text

c. In Front of Text

d. In Line with Text

Question: 64

This question is based upon the figure shown below

In the given screenshot, the letter X is pointing to an area between the first Row header, and the first Column header. What will happen when this particular area is selected?

a. It will select the whole sheet, having the same effect as that of Ctrl+A.

b. It will close and save this particular worksheet of the workbook.

c. Nothing will happen.

d. It will hide this particular worksheet.

Question: 65

Which of the following actions from the Delete group not only moves all the existing messages but also the future messages in the selected Conversations to the Deleted Items folder?

a. Ignore

b. Clean Up

c. Delete

Question: 66

How can you remove duplicate emails present in a particular folder?

a. By using the Clean Up Folder option.

b. By repeatedly using the Send/Receive mails option.

c. By applying filtration of the email according to groups, in a particular folder.

d. By sorting the emails received in a particular folder.

Question: 67

Suppose there are some files in a folder named ‘demo’, which were archived to a file named demo.pst. Now you want to restore this archive to a folder named ‘demo1′. Which option in the File tab will you use for this purpose, in Microsoft Outlook 2010?

a. Info

b. Open

c. Options

d. None of these

Question: 68

You are editing a shape using the Drawing Tools. Which among the following Shape Fill options in the Shape Styles group gives you control over the transparency for a shape?

a. Fill color, More Fill Colors

b. Background Color

c. Texture

d. Pattern

Question: 69

In Microsoft Word 2010, “Keep lines together” paragraph formatting:

a. works well for paragraphs within a table if “Allow row to break across pages” is also selected.

b. automatically enables the text rows to break across pages.

c. does not work for paragraphs within a table if “Allow row to break across pages” is also selected.

d. always works for paragraphs within a table.

Question: 70

Slicers are filtering components which are used to filter the data in a PivotTable report or CUBE functions. Which of the following data sources is/are supported by Slicers in Microsoft Excel 2010?

a. Office Database connections

b. Online Analytical Processing (OLAP) Queries

c. Online Analytical Processing (OLAP) Cube Files

Question: 71

What will happen if the Junk E-mail filter of Microsoft Outlook 2010 does NOT consider a message to be spam but considers it to be phishing?

a. It will shift the message to the Spam folder.

b. It will disable all the links in the e-mail.

c. It will disable the Reply and Reply All commands.

d. It will delete the e-mail.

Question: 72

How would you write on the slides during a slide show?

a. In the Slide Sorter view, right-click on the slide that you want to write on, point to Pen Options, and then click on a pen. Drag it to write.

b. On the Slide Show tab, in the Set Up group, select a pen and then drag it to write.

c. In the Slide Show view, right-click on the slide that you want to write on, point to Pointer Options, and then click on a pen or a highlighter option. Hold down the left mouse button and drag to write.

d. All of the above

Question: 73

Which picture format maintains transparency in MS 2010 Powerpoint?

a. .png

b. .gif

c. .jpg

d. .wmf

Question: 74

Which of the following is not a category of transition?

a. Subtle

b. Exciting

c. Dynamic Content

d. Emphasis

Question: 75

The default chart colors are determined by what?

a. Slide Design Effects

b. Slide Background Graphics

c. Slide Fill Shading

d. Slide Color Scheme

Question: 76

With which chart type(s) is the “Depth Gridlines” option available?

a. Bubble chart

b. Line chart

c. True 3D chart

d. All of the above

Question: 77

Which of the following record types of Business Contact Manager for Microsoft Outlook 2010 allows you to plan and track communication activities to accomplish a business result, such as increasing market share, introducing a new product, or retaining customers?

a. Opportunity

b. Marketing Activity

c. Business Project

d. Business Contact

Question: 78

This question is based upon the figure shown below

Which of the following tools is used to format Excel worksheet data, as shown in the figure above?

a. Slicer

b. SmartArt

c. WordArt

d. Macros

Question: 79

By default, when you paste a chart from Excel into PowerPoint 2007, is it linked or embedded?

a. It is linked

b. It is embedded

Question: 80

Josh is to create a technical write-up comprising short paragraphs with double line spacing. Each paragraph is to be separated from the other by a single line space. He writes a paragraph, selects the text, points to Line Spacing on the paragraph toolbar and sets it to 2.0. He gets the paragraph double spaced. The moment he clicks enter to start a new paragraph, it automatically gets double spaced. How can Josh achieve paragraphs separated by single line spaces from each other within the document?

a. He sets the Line Spacing on the formatting toolbar to 1.0.

b. He selects the double-spaced paragraphs and clicks on Paragraph.Then under Indents and Spacing, he sets the Spacing “Before” and “After” options to zero.

c. He uses the Shift and Enter keys at the same time to create a new paragraph.

d. He selects the double-spaced paragraphs and clicks on Paragraph. Then under Indents and Spacing, he sets the Spacing “Before” and “After” options to Auto.

Knowledge of Microsoft Office Skills Test Questions and Answers