Office Skills Test Answers 2017, Upwork Office Skills Test Answers

Upwork Office Skills Test Answers

1. 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
Answers:
a. 5,4,3,2,1
a. 3,2,1,4,5
a. 3,5,4,1,2
a. 2,3,1,5,4
a. 3,1,5,2,4
2. What is ‘flexi-time’?
Answers:
a. The feeling when time slows down or speeds up at certain times of the day in an office environment.
a. The flexible use of personal office hours, such as working an hour earlier one day, in order to leave an hour earlier another day. 
a. Occasionally moving the hands on the office clock so everyone can go home early now and then.
a. Bringing an alarm clock to work that rings at the end of the day and at lunchtimes.
3. Which of the following are proven methods of improving your office skills?
Answers:
a. Smiling and being appreciative of others, especially the clients.
a. Actively listening to, even humoring people at times.
a. Looking to resolve conflicts and bringing people together.
a. Conveying what is expected in return as an appropriate response, and avoiding ambiguity.
a. All of the above
4. When replying to an e-mail, who do you place in the cc: line and who in the bcc: line?
Answers:
a. A person you wish to openly inform goes in the cc: line, and the same person in the bcc: line.
a. A person you wish to openly inform goes in the bcc: line, and the same person in the cc: line.
a. 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.
a. 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. 
5. 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?
Answers:
a. MS Powerpoint, MS Access
a. Adobe Photoshop, MS Powerpoint
a. MS Word, MS Excel
a. MS Excel, MS PowerPoint
6. What is a ‘golden handshake’?
Answers:
a. The welcome to the building of a new CEO.
a. The last day in the office before the holidays.
a. The common usage for a generous employment severance package when an executive loses his or her job through restructuring, redundancy or a scheduled retirement. 
a. The common usage for a series of re-hirings of past employees.
a. c and d
7. Which of the following is the correct response when you are dealing with a client, and your boss enters the room?
Answers:
a. Smile, stand up and politely introduce the client. 
a. Stand up and salute, standing to attention.
a. Keep sitting down, but look up without smiling.
a. Keep discussing business until your boss politely interrupts.
a. a and d
8. Which of the following are considered bad manners while greeting a business visitor to your office?
Answers:
a. Remaining seated while the visitor introduces himself/herself
a. Not shaking hands, but simply saying hello with a smile
a. Shaking hands from the shoulder rather than the elbow
a. Shaking hands with gloves on, or forgetting to smile
a. All of the above
9. With regard to emails, when is bcc: used?
Answers:
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.
a. 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. 
a. When you want to send the same mail to several people and want to receive acknowledgments from each recipient.
a. When you want to send the same mail to several people, but the mail does not support attachments.
10. What does the ‘glass ceiling’ refer to in a business context?
Answers:
a. The internal ceiling above the boardroom, whether it is on the top floor or not.
a. The roof of the company building, frequently constructed from glass to optimize the company’s public status for the surrounding area.
a. The upper level of senior management or company executive positions which is traditionally hard to break through, for example, for women and/or minorities. 
a. The imaginary level above the CEO at which the company profits skyrocket.
11. 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?
Answers:
a. E-mail the Regulatory Authority in charge of stopping spam in order to complain.
a. E-mail the source of the emails asking them to stop them.
a. Call over a computer expert to solve the problem.
a. Look for a Remove From Mailing List link in the email. 
12. What does ‘the bottom line’ commonly refer to in an office environment?
Answers:
a. The line that appears at the bottom of a paper with the company letterhead.
a. The lowest office floor in a building.
a. The same as the dotted line.
a. The basic controlling factor, notably the financial cost, regarding whether a task or project can be accomplished or not. 
13. What is the person in charge of administering an office commonly called?
Answers:
a. Office Assistant
a. Full-time Manager
a. Office Manager
a. CEO
a. None of the above
14. What is the normal length of notice period for quitting job in most professional offices?
Answers:
a. Either 2 weeks or 1 month
a. 2-3 months
a. 1 week
a. Up to 3 months, or longer
a. None of the above
15. What is the best practice for ensuring that sensitive material to be destroyed does not leak out of the company building?
Answers:
a. Always encrypt on computer disk, and shred any hard copies. 
a. Shred hard copies, save onto the file.
a. Burn hard copies, save only once to the file.
a. E-mail documents to colleagues, and then close the e-mail browser.
16. Consider the following sentence:
‘There are 20 new PC’s in the accounts department.’
Should there be an apostrophe in PC’s?
Answers:
a. No
a. Yes
a. Not sure
a. No idea
a. None of the above
17. What information would the petty cash register contain?
Answers:
a. Details of expenses on account of the administrative staff.
a. Details of small expenses related to the running of the office. 
a. Details of expenses on account of electricity and water bills.
a. Details of expenses worth less than $80.
18. When you are introducing a woman and are unsure of her marital status, which title should you use?
Answers:
a. Ms. 
a. Miss
a. Mrs.
a. Madam
a. None of the above
19. You are asked to call up senior executives of your company located in different continents to inform them about the proposed dates for an international sales meeting. What is the best time to call them up?
Answers:
a. During the call recipient’s office hours
a. After your office hours
a. During your office hours
a. Between 9:00 A.M. and 5:00 P.M.
a. Any of the above
20. What is ‘outsourcing’?
Answers:
a. Working outside the office, often from home.
a. Freelancing work to workers outside the main office building, often to foreign workers for cheaper labor costs. 
a. A form of half working from home, half at the office.
a. Leaving work early.
21. Which of the following are good office practices when creating documents such as letters, memos, company files etc?
Answers:
a. Always save to hard drive and at least one back-up, such as a CD or thumb drive. 
a. Save to the hard drive and a back-up, if necessary.
a. Save to the back-up first, and then the hard drive.
a. Save once a day.
22. What is ‘commodity value’�an important business term of relevance to most office environments?
Answers:
a. The value of all the office hardware, including computers and furniture.
a. An economics term meaning the intrinsic value under optimal, often free-market conditions of the product the company sells or manufactures. 
a. The value of common decency between employees of a given office.
a. The cost in petty cash of all company-expense dinners in a given month.
23. What is the appropriate response to discovering the printer is out of ink?
Answers:
a. Force the printer to deliver the last drop of ink by turning it upside down, holding it carefully.
a. Walk away and tell a fellow office worker, hoping he or she will take responsibility.
a. Leave it to the next person.
a. Replace the ink if the cartridge is available otherwise follow the office procedure for replacing or ordering the cartridges. 
24. What does ‘Class A office space’ commonly refer to?
Answers:
a. Office space on former sites of class A drug offenses.
a. The lowest quality office buildings in a given area.
a. The highest quality office space available in a given area. 
a. The highest quality office space for the least price.
25. What does the CTRL+V shortcut accomplish in Word 2007?
Answers:
a. It makes the selected text appear in bold.
a. It pastes the text that has already been copied. 
a. It converts the selected text into the next larger size of the same font.
a. It applies italic formatting to the selected text.
a. All of the above
26. Which of the following energy-saving practices can be used in an office without adversely affecting company productivity?
Answers:
a. Use only one bathroom light during office hours
a. Turn off lights and computers at the end of the day
a. Turn off the computers between sending e-mails
a. Use lower Watt light bulbs, especially in the emergency exits
a. a and d
27. What is the best way to handle an angry colleague or client with a complaint?
Answers:
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. 
a. Show a little anger as a way of evening out the situation.
a. Shout back, and then, later in the day, find a place to sulk, or time to complain to your own boss.
a. Listen to their concerns, politely explain what you are able to do, and if they insist, shout back your own concerns and complaints.
28. Which of the following are not recommended when trying to improve working with others in an office environment
Answers:
a. Talking when others are talking, and listening only occasionally. 
a. Being as consciously helpful as possible, and offering practical solutions.
a. Changing the printer ink or cartridge when it runs out.
a. None of the above
29. What is the benefit of e-mailing documents rather than always providing hard copies to individuals?
Answers:
a. There is no benefit except that people can delete them more easily.
a. The documents can potentially be edited online and re-circulated.
a. The documents can be electronically forwarded, which saves stationery that may otherwise be used. 
a. b and c
30. Which of the following file formats relate to a graphic file or scanned image file?
Answers:
a. JPEG
a. VBP
a. HTML
a. GIF
a. a and d
31. What is the difference between Microsoft Access and Microsoft Excel?
Answers:
a. Access is mainly for spreadsheets and Excel is for databases
a. Access is mainly for databases and Excel is for spreadsheets
a. Access is mainly for databases and Excel is for word processsing
a. Access is mainly for word processing and Excel is for spreadsheets, including digitial photograph editing
32. What is the most frequently used typeface and point size when creating Word documents?
Answers:
a. Times New Roman, 12 point
a. Times, 14 point
a. Courier New, 12 point
a. Courier New, 14 point
a. All of the above
33. What is a ‘mouse potato'(a comic phrase in an office environment)?
Answers:
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. 
a. A virus or other harmful computer bug, such as a ‘trojan horse’.
a. An office ornament that workers place on their desks to keep them motivated during office hours.
a. b and c
34. What is very important to remember to do when entering an office business meeting at any level, especially when clients are there?
Answers:
a. Bow slightly before your superiors or company executives.
a. Take the coats from clients and drape them over your arm during the meeting.
a. Turn OFF all cell phones, pagers and other electronic devices. 
a. Turn ON all cell phones, pagers and other electronic devices.
a. a and c
35. What are the traditional office hours in the Western world, now much more flexible, though still adhered to in most offices?
Answers:
a. 9 AM — 5 PM
a. 6 AM — 6 PM
a. 8 AM — 7 PM
a. 10 AM — 8 PM
a. None of the above
36. What is an office ‘memo circular’?
Answers:
a. A simple message, usually delivered by e-mail or hard copy and sent to all office staff, updating everyone on new office procedures. 
a. A circular-shaped memo.
a. A letter of introduction by a potential new client.
a. A complaint letter to the CEO circulated to and signed by the entire company staff.
37. Traditionally, approximately how many pages should a business CV or resume have?
Answers:
a. 1-3, preferably 2
a. 1-5, but usually 2-3
a. Just 1
a. Exactly 2 and a half, and never more or less
a. All of the above
38. Which of the following activities could possibly infect your computer with a virus?
Answers:
a. Installing pirated Software from a CD.
a. Downloading games and songs from the internet. 
a. Booting your computer with a ‘write protected floppy disk’.
a. All of the above
39. In any office or business environment, what does the ‘opportunity success rate’ refer to?
Answers:
a. The success of a business in dollar value minus the dollar value of previous attempts to make it a success.
a. The number of won opportunities as a percentage of the number of won and lost opportunities. 
a. The number of lost opportunities as a percentage of the number of almost won opportunities.
a. The opportunity costs divided by the so-called sunk costs.
40. What are the dimensions of an A4 size sheet of paper?
Answers:
a. 216 mm x 279 mm
a. 220 mm x 310 mm
a. 215 mm x 295 mm
a. 210 mm x 297 mm
a. a and d
41. What does the abbreviation CEO stand for?
Answers:
a. Company Executive Officer
a. Communicate Especially On
a. Corporate Exact Office
a. Cheat Every One
a. Chief Executive Officer
42. 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?
Answers:
a. You talk to the foreign workers and tell them that they should complain to the Upper Management. 
a. You tell your supervisor that his misbehavior is inappropriate.
a. Nothing, you prefer to keep quiet because everybody else is quiet.
a. You complain to the Upper Management.
43. 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
Answers:
a. Dr. Jones’s office, Doctor at sea, Doctor come quickly
a. Doctor at sea, Doctor come quickly, Dr. Jones’s office
a. Doctor come quickly, Dr. Jones’s office, Doctor at sea
a. Dr. Jones’s office, Doctor come quickly, Doctor at sea
44. When a client visits the office and arrives early, what does office etiquette require you to do to handle the situation?
Answers:
a. If you are free, allow the meeting to start early.
a. Take their coat, offer them something to drink, and tell them you will be with them in a moment.
a. Try and meet them as soon as possible.
a. All of the above. 
45. Which of the following are the important components of good interpersonal office skills?
Answers:
a. Effectively translating and conveying information.
a. Being able to accurately interpret other people’s emotions.
a. Calmly arriving at resolutions to conflict.
a. Avoiding gossip and being polite.
a. All of the above
46. What does administration generally handle in an office environment?
Answers:
a. Paperwork and accounts.
a. Specifically, the hiring of new management and middle management.
a. The efficient day-to-day running of the office, with regard to company files, communication, management of jobs such as overseeing hiring and firing and human resources, etc. 
a. Ensuring that the infrastructure of the building is regularly checked and modernized.
47. What is ‘commodity value’—an important business term of relevance to most office environments?
Answers:
a. The value of all the office hardware, including computers and furniture.
a. An economics term meaning the intrinsic value under optimal, often free-market conditions of the product the company sells or manufactures. 
a. The value of common decency between employees of a given office.
a. The cost in petty cash of all company-expense dinners in a given month.
48. Which of the following are commonly used computer web browsers?
Answers:
a. Mozilla, Guardian Website, The Times of London, MSN
a. Expedia, Opodo, Student Universe, Godzilla
a. Chrome, Explorer, Firefox
a. Google, MSN, Yahoo, Ask
49. What common injury can result from too much concentrated typing over too little amount of time?
Answers:
a. Leg injury
a. Broken neck
a. Blue hands
a. Repetitive strain injury
a. All of the above
50. 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?
Answers:
a. Give the client the airway bill number and ask him to call up FEDEX about the status of the courier.
a. Give the client the local number of FEDEX in Korea.
a. Call FEDEX and ask them to speak directly to the customer.
a. Track the packet on the FEDEX website and send the client a copy of the current status of the packet. 
51. What two kinds of printers are commonly in use in most office environments?
Answers:
a. Industrial and private
a. Hewlett Packard and Brother
a. Laser and ink-jet
a. Black-and-white and color
a. None of the above
52. In which order would the following strategic planning activities take place?

  1. Evaluating performance
  2. Devising strategy
  3. Documenting plans
  4. Executing plans


a.2, 4, 3, 1
b.4, 3, 1, 2
c.3, 2, 1, 4
d.4, 1, 3, 2
e.2, 3, 4, 1

53. Which of the following are the characteristics of highly productive people?

a.Approaching a problem in a systematic manner.
b.Acting spontaneously.
c.Concentrating single-mindedly.
d.Trying to analyze a problem from a single point of view.

54. If a subordinate is having difficulty carrying out a delegated task, what should a manager do?

a.Take over the task for the employee so he or she will not become demoralized.
b.Be available as a role model and resource in identifying alternative solutions.
c.Give the employee a written warning.
d.Give the employee a second delegated task so he or she has another opportunity to prove his worth.

55. Suppose there is a queue of two printing jobs to be completed by a printer and unfortunately one of the jobs got stuck in the queue. Which of the following steps can be useful in this case?

  1. i) Press cancel button on the printer to cancel the job.
  2. ii) Power off the printer.
iii) Unplug the printer cable, wait for a minute then re-plug it.
  1. iv) Click on Start -> Devices and Printers -> Double-click on the printer icon and cancel the printer job.
a.(i) and (iii) only
b.(ii) and (iv) only
c.(i) and (iv) only
d.(ii), (iii), and (iv)

56. What is/are the benefit(s) 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

57. A person with good interpersonal skills MUST possess:

a.The ability to know when to listen, how to listen and when to speak.
b.The skill of intuition.
c.Enormous deal of patience and calmness.
d.The ability to fulfill his/her commitments.

58. Which of the following options will help you in establishing strong relationships with your clients?

a.Spending sufficient capital instead of time to acquire your client.
b.Doing creative outsourcing to research about the needs of the client.
c.Acquiring new clients while not letting the old ones go.
d.Avoiding being friendly and instead being professional, while dealing with a client.

59. What are the dimensions of an A4 size sheet of paper?
a.5.8 × 8.3 in/148 × 210 mm
b.16.5 × 23.4 in/420 × 594 mm
c.11.7 × 16.5 in/297 × 420 mm
d.8.3 × 11.7 in/210 × 297 mm

60. Which of the following resources is/are managed by an administrator?

  1. i) People
  2. ii) Equipment
iii) Space
  1. iv) Information
a.Only option i)
b.Only options i) and iii)
c.Only options i) and iv)
d.All options i), ii), iii), and iv)

61. Nominal Group Technique is used when:

a.the group has new members.
b.some members are not participating.
c.tasks are allotted scores according to their importance.
d.the manager wants to reduce his workload.

62. What does ‘the bottom line’ commonly refer to in an office environment?

a.It is described as any action that may increase or decrease the net earnings or the overall profit of company.
b.It is the minimum wage/pay that must be provided to an employee in the company.
c.It is described as the maximum number of employees that can be hired by a company.
d.None of the above

63. Which of the following correctly defines a consensus decision?

a.A consensus decision involves everyone, but the decision is taken by the person in charge.
b.A consensus decision involves everyone and is based on where the majority rules.
c.A consensus decision is based on the decision of the person in charge.
d.None of the above.

64. Which persuasion technique are you using when the listeners have complied with requests and you let them know that they made a good decision that was of great help?

a.Reassurance
b.Artificial Disinterest
c.Bandwagon
d.Exchange Favors

65. Which of the following does NOT represent good negotiating and influencing skills?

a.A sharp, quick reaction to something that you object.
b.Assertiveness.
c.Active listening.
d.Asking probing questions and seeking time to ponder over ideas.

66. Which of the following needs to be considered before delegating a task to someone else?

a.Whether someone else can do the task.
b.Whether someone else can do the task better than you.
c.Whether someone else can do the task at a lower cost than you.
d.All of the above.

67. Which of the following best describes ‘scenario planning’ as a planning tool?

a.Considering multiple possible outcomes so that an executive/a team can respond to a range of eventualities.
b.Focusing efforts on the most likely outcome so that an executive/a team is ready to respond.
c.Using comparisons with past examples to predict likely outcomes.
d.Preparing a detailed plan that addresses each stage of a particular scenario.

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

a.Inform the HR department about the issue.
b.Report the issue to your immediate manager and ask him to handle it.
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.

69. On creating her two page resume, Emma finds the paragraph heading for her “Professional Achievements” paragraph is showing at the bottom of the first page, while the details are on the next page. To keep the paragraph heading as well as the paragraph text on the same page, and assuming there are no empty paragraph markers in the document and the widow/orphan option is turned on, Emma should click on the paragraph heading and select which option from the Paragraph group?

a.Keep lines together
b.Keep with next
c.Widow/orphan

70. What does the term ‘kaizen’ refer to?

a.Continuous improvement
b.Introducing a flatter management structure
c.Work ethics
d.Up-skilling employees

71. Which of the following shortcut keys is used to perform the replace function in a Word document?

a.Ctrl+H
b.Ctrl+Y
c.Ctrl+V
d.Ctrl+I

72. For which of the following activities is a Policy and Procedure (P&P) Manual useful?

a.For spreading business philosophies within and between departments.
b.For providing training and orientation to new and current employees.
c.For defining limits of authority within organization.
d.All of the above.

73. The first thing to remember before taking the humor-route in office:

a.Is to ensure that the boss is not around.
b.Is to ensure that you are in the company of friends.
c.Is that people have different tastes for jokes.
d.All of the above.

74. Suppose you made some changes in Sheet1 in cell ‘B13’ and you want to change the same cell in Sheet2. Which of the following functions will help you for this task?

a.Combine
b.Group
c.Macro
d.Copy and Paste

75. Fill in the blank:
Those with a ___________ believe that performance and success levels are attributed to the effort that is put into something.

a.Fixed mindset
b.Growth mindset
c.Optimistic mindset
d.Pragmatic mindset

76. If the financial year starts in January, the Fixed Budget will be prepared:

a.a month or two earlier
b.in January
c.at the end of that year
d.as and when the financial manager decides

77. Choose True or False.
The risk factor for pre-set goals is high.

a.True
b.False

78. What is a ‘golden handshake/parachute’?

a.It is the term that describes a final agreement on a proposed business deal between two organizations.
b.It is the formal agreement about pay structure, leave policy, and working hours etc., signed by a new employee while joining an organization.
c.It is the term used for a generous employment severance package when an executive loses his or her job through restructuring, redundancy or a scheduled retirement.
d.It is the term used for re-hiring of past employees in an organization.

79. Which of the following is/are the correct advantage(s) of decentralization?

a.It gives the freedom to act and for some decision making to the subordinates. Thus, it gives the feeling of status and recognition to them.
b.It enables one to take prompt and quick action at the earliest.
c.It is suitable for any type of organization.
d.It provides uniformity to policies and procedures.

80. Which of the following Excel 2013 features allows sharing files with other people and working together in real time?

a.Representational State Transfer (REST)
b.SkyDrive
c.Online Meeting
d.Both b and c

81. Which of the following keys’ combinations is used to lock a computer that has a Microsoft Windows operating system?

a.Ctrl + L
b.Windows logo key + L
c.Alt + N
d.Windows logo key + W

1. 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
Answers:
  1. 5,4,3,2,1
  2. 3,2,1,4,5
  3. 3,5,4,1,2
  4. 2,3,1,5,4
  5. 3,1,5,2,4
2. What is ‘flexi-time’?
Answers:
  1. The feeling when time slows down or speeds up at certain times of the day in an office environment.
  2. The flexible use of personal office hours, such as working an hour earlier one day, in order to leave an hour earlier another day.
  3. Occasionally moving the hands on the office clock so everyone can go home early now and then.
  4. Bringing an alarm clock to work that rings at the end of the day and at lunchtimes.
3. Which of the following are proven methods of improving your office skills?
Answers:
  1. Smiling and being appreciative of others, especially the clients.
  2. Actively listening to, even humoring people at times.
  3. Looking to resolve conflicts and bringing people together.
  4. Conveying what is expected in return as an appropriate response, and avoiding ambiguity.
  5. All of the above
4. When replying to an e-mail, who do you place in the cc: line and who in the bcc: line?
Answers:
  1. A person you wish to openly inform goes in the cc: line, and the same person in the bcc: line.
  2. A person you wish to openly inform goes in the bcc: line, and the same person in the cc: line.
  3. 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.
  4. 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.
5. 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?
Answers:
  1. MS Powerpoint, MS Access
  2. Adobe Photoshop, MS Powerpoint
  3. MS Word, MS Excel
  4. MS Excel, MS PowerPoint
6. What is a ‘golden handshake’?
Answers:
  1. The welcome to the building of a new CEO.
  2. The last day in the office before the holidays.
  3. The common usage for a generous employment severance package when an executive loses his or her job through restructuring, redundancy or a scheduled retirement.
  4. The common usage for a series of re-hirings of past employees.
  5. c and d
7. Which of the following is the correct response when you are dealing with a client, and your boss enters the room?
Answers:
  1. Smile, stand up and politely introduce the client.
  2. Stand up and salute, standing to attention.
  3. Keep sitting down, but look up without smiling.
  4. Keep discussing business until your boss politely interrupts.
  5. a and d
8. Which of the following are considered bad manners while greeting a business visitor to your office?
Answers:
  1. Remaining seated while the visitor introduces himself/herself
  2. Not shaking hands, but simply saying hello with a smile
  3. Shaking hands from the shoulder rather than the elbow
  4. Shaking hands with gloves on, or forgetting to smile
  5. All of the above
9. With regard to emails, when is bcc: used?
Answers:
  1. 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.
  2. 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.
  3. When you want to send the same mail to several people and want to receive acknowledgments from each recipient.
  4. When you want to send the same mail to several people, but the mail does not support attachments.
10. What does the ‘glass ceiling’ refer to in a business context?
Answers:
  1. The internal ceiling above the boardroom, whether it is on the top floor or not.
  2. The roof of the company building, frequently constructed from glass to optimize the company’s public status for the surrounding area.
  3. The upper level of senior management or company executive positions which is traditionally hard to break through, for example, for women and/or minorities.
  4. The imaginary level above the CEO at which the company profits skyrocket.
11. 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?
Answers:
  1. E-mail the Regulatory Authority in charge of stopping spam in order to complain.
  2. E-mail the source of the emails asking them to stop them.
  3. Call over a computer expert to solve the problem.
  4. Look for a Remove From Mailing List link in the email.
12. What does ‘the bottom line’ commonly refer to in an office environment?
Answers:
  1. The line that appears at the bottom of a paper with the company letterhead.
  2. The lowest office floor in a building.
  3. The same as the dotted line.
  4. The basic controlling factor, notably the financial cost, regarding whether a task or project can be accomplished or not.
13. What is the person in charge of administering an office commonly called?
Answers:
  1. Office Assistant
  2. Full-time Manager
  3. Office Manager
  4. CEO
  5. None of the above
14. What is the normal length of notice period for quitting job in most professional offices?
Answers:
  1. Either 2 weeks or 1 month
  2. 2-3 months
  3. 1 week
  4. Up to 3 months, or longer
  5. None of the above
15. What is the best practice for ensuring that sensitive material to be destroyed does not leak out of the company building?
Answers:
  1. Always encrypt on computer disk, and shred any hard copies.
  2. Shred hard copies, save onto the file.
  3. Burn hard copies, save only once to the file.
  4. E-mail documents to colleagues, and then close the e-mail browser.
16. Consider the following sentence:
‘There are 20 new PC’s in the accounts department.’
Should there be an apostrophe in PC’s?
Answers:
  1. No
  2. Yes
  3. Not sure
  4. No idea
  5. None of the above
17. What information would the petty cash register contain?
Answers:
  1. Details of expenses on account of the administrative staff.
  2. Details of small expenses related to the running of the office.
  3. Details of expenses on account of electricity and water bills.
  4. Details of expenses worth less than $80.
18. When you are introducing a woman and are unsure of her marital status, which title should you use?
Answers:
  1. Ms.
  2. Miss
  3. Mrs.
  4. Madam
  5. None of the above
19. You are asked to call up senior executives of your company located in different continents to inform them about the proposed dates for an international sales meeting. What is the best time to call them up?
Answers:
  1. During the call recipient’s office hours
  2. After your office hours
  3. During your office hours
  4. Between 9:00 A.M. and 5:00 P.M.
  5. Any of the above
20. What is ‘outsourcing’?
Answers:
  1. Working outside the office, often from home.
  2. Freelancing work to workers outside the main office building, often to foreign workers for cheaper labor costs.
  3. A form of half working from home, half at the office.
  4. Leaving work early.
21. Which of the following are good office practices when creating documents such as letters, memos, company files etc?
Answers:
  1. Always save to hard drive and at least one back-up, such as a CD or thumb drive.
  2. Save to the hard drive and a back-up, if necessary.
  3. Save to the back-up first, and then the hard drive.
  4. Save once a day.
22. What is ‘commodity value’�an important business term of relevance to most office environments?
Answers:
  1. The value of all the office hardware, including computers and furniture.
  2. An economics term meaning the intrinsic value under optimal, often free-market conditions of the product the company sells or manufactures.
  3. The value of common decency between employees of a given office.
  4. The cost in petty cash of all company-expense dinners in a given month.
23. What is the appropriate response to discovering the printer is out of ink?
Answers:
  1. Force the printer to deliver the last drop of ink by turning it upside down, holding it carefully.
  2. Walk away and tell a fellow office worker, hoping he or she will take responsibility.
  3. Leave it to the next person.
  4. Replace the ink if the cartridge is available otherwise follow the office procedure for replacing or ordering the cartridges.
24. What does ‘Class A office space’ commonly refer to?
Answers:
  1. Office space on former sites of class A drug offenses.
  2. The lowest quality office buildings in a given area.
  3. The highest quality office space available in a given area.
  4. The highest quality office space for the least price.
25. What does the CTRL+V shortcut accomplish in Word 2007?
Answers:
  1. It makes the selected text appear in bold.
  2. It pastes the text that has already been copied.
  3. It converts the selected text into the next larger size of the same font.
  4. It applies italic formatting to the selected text.
  5. All of the above
26. Which of the following energy-saving practices can be used in an office without adversely affecting company productivity?
Answers:
  1. Use only one bathroom light during office hours
  2. Turn off lights and computers at the end of the day
  3. Turn off the computers between sending e-mails
  4. Use lower Watt light bulbs, especially in the emergency exits
  5. a and d
27. What is the best way to handle an angry colleague or client with a complaint?
Answers:
  1. 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.
  2. Show a little anger as a way of evening out the situation.
  3. Shout back, and then, later in the day, find a place to sulk, or time to complain to your own boss.
  4. Listen to their concerns, politely explain what you are able to do, and if they insist, shout back your own concerns and complaints.
28. Which of the following are not recommended when trying to improve working with others in an office environment
Answers:
  1. Talking when others are talking, and listening only occasionally.
  2. Being as consciously helpful as possible, and offering practical solutions.
  3. Changing the printer ink or cartridge when it runs out.
  4. None of the above
29. What is the benefit of e-mailing documents rather than always providing hard copies to individuals?
Answers:
  1. There is no benefit except that people can delete them more easily.
  2. The documents can potentially be edited online and re-circulated.
  3. The documents can be electronically forwarded, which saves stationery that may otherwise be used.
  4. b and c
30. Which of the following file formats relate to a graphic file or scanned image file?
Answers:
  1. JPEG
  2. VBP
  3. HTML
  4. GIF
  5. a and d
31. What is the difference between Microsoft Access and Microsoft Excel?
Answers:
  1. Access is mainly for spreadsheets and Excel is for databases
  2. Access is mainly for databases and Excel is for spreadsheets
  3. Access is mainly for databases and Excel is for word processsing
  4. Access is mainly for word processing and Excel is for spreadsheets, including digitial photograph editing
32. What is the most frequently used typeface and point size when creating Word documents?
Answers:
  1. Times New Roman, 12 point
  2. Times, 14 point
  3. Courier New, 12 point
  4. Courier New, 14 point
  5. All of the above
33. What is a ‘mouse potato'(a comic phrase in an office environment)?
Answers:
  1. The equivalent of a couch potato, but in terms of using a computer — i.e. someone who spends all their time at a computer.
  2. A virus or other harmful computer bug, such as a ‘trojan horse’.
  3. An office ornament that workers place on their desks to keep them motivated during office hours.
  4. b and c
34. What is very important to remember to do when entering an office business meeting at any level, especially when clients are there?
Answers:
  1. Bow slightly before your superiors or company executives.
  2. Take the coats from clients and drape them over your arm during the meeting.
  3. Turn OFF all cell phones, pagers and other electronic devices.
  4. Turn ON all cell phones, pagers and other electronic devices.
  5. a and c
35. What are the traditional office hours in the Western world, now much more flexible, though still adhered to in most offices?
Answers:
  1. 9 AM — 5 PM
  2. 6 AM — 6 PM
  3. 8 AM — 7 PM
  4. 10 AM — 8 PM
  5. None of the above
36. What is an office ‘memo circular’?
Answers:
  1. A simple message, usually delivered by e-mail or hard copy and sent to all office staff, updating everyone on new office procedures.
  2. A circular-shaped memo.
  3. A letter of introduction by a potential new client.
  4. A complaint letter to the CEO circulated to and signed by the entire company staff.
37. Traditionally, approximately how many pages should a business CV or resume have?
Answers:
  1. 1-3, preferably 2
  2. 1-5, but usually 2-3
  3. Just 1
  4. Exactly 2 and a half, and never more or less
  5. All of the above
38. Which of the following activities could possibly infect your computer with a virus?
Answers:
  1. Installing pirated Software from a CD.
  2. Downloading games and songs from the internet.
  3. Booting your computer with a ‘write protected floppy disk’.
  4. All of the above
39. In any office or business environment, what does the ‘opportunity success rate’ refer to?
Answers:
  1. The success of a business in dollar value minus the dollar value of previous attempts to make it a success.
  2. The number of won opportunities as a percentage of the number of won and lost opportunities.
  3. The number of lost opportunities as a percentage of the number of almost won opportunities.
  4. The opportunity costs divided by the so-called sunk costs.
40. What are the dimensions of an A4 size sheet of paper?
Answers:
  1. 216 mm x 279 mm
  2. 220 mm x 310 mm
  3. 215 mm x 295 mm
  4. 210 mm x 297 mm
  5. a and d
41. What does the abbreviation CEO stand for?
Answers:
  1. Company Executive Officer
  2. Communicate Especially On
  3. Corporate Exact Office
  4. Cheat Every One
  5. Chief Executive Officer
42. 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?
Answers:
  1. You talk to the foreign workers and tell them that they should complain to the Upper Management.
  2. You tell your supervisor that his misbehavior is inappropriate.
  3. Nothing, you prefer to keep quiet because everybody else is quiet.
  4. You complain to the Upper Management.
43. 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
Answers:
  1. Dr. Jones’s office, Doctor at sea, Doctor come quickly
  2. Doctor at sea, Doctor come quickly, Dr. Jones’s office
  3. Doctor come quickly, Dr. Jones’s office, Doctor at sea
  4. Dr. Jones’s office, Doctor come quickly, Doctor at sea
44. When a client visits the office and arrives early, what does office etiquette require you to do to handle the situation?
Answers:
  1. If you are free, allow the meeting to start early.
  2. Take their coat, offer them something to drink, and tell them you will be with them in a moment.
  3. Try and meet them as soon as possible.
  4. All of the above.
45. Which of the following are the important components of good interpersonal office skills?
Answers:
  1. Effectively translating and conveying information.
  2. Being able to accurately interpret other people’s emotions.
  3. Calmly arriving at resolutions to conflict.
  4. Avoiding gossip and being polite.
  5. All of the above
46. What does administration generally handle in an office environment?
Answers:
  1. Paperwork and accounts.
  2. Specifically, the hiring of new management and middle management.
  3. The efficient day-to-day running of the office, with regard to company files, communication, management of jobs such as overseeing hiring and firing and human resources, etc.
  4. Ensuring that the infrastructure of the building is regularly checked and modernized.
47. What is ‘commodity value’—an important business term of relevance to most office environments?
Answers:
  1. The value of all the office hardware, including computers and furniture.
  2. An economics term meaning the intrinsic value under optimal, often free-market conditions of the product the company sells or manufactures.
  3. The value of common decency between employees of a given office.
  4. The cost in petty cash of all company-expense dinners in a given month.
48. Which of the following are commonly used computer web browsers?
Answers:
  1. Mozilla, Guardian Website, The Times of London, MSN
  2. Expedia, Opodo, Student Universe, Godzilla
  3. Chrome, Explorer, Firefox
  4. Google, MSN, Yahoo, Ask
49. What common injury can result from too much concentrated typing over too little amount of time?
Answers:
  1. Leg injury
  2. Broken neck
  3. Blue hands
  4. Repetitive strain injury
  5. All of the above
50. 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?
Answers:
  1. Give the client the airway bill number and ask him to call up FEDEX about the status of the courier.
  2. Give the client the local number of FEDEX in Korea.
  3. Call FEDEX and ask them to speak directly to the customer.
  4. Track the packet on the FEDEX website and send the client a copy of the current status of the packet.
51. What two kinds of printers are commonly in use in most office environments?
Answers:
  1. Industrial and private
  2. Hewlett Packard and Brother
  3. Laser and ink-jet
  4. Black-and-white and color
  5. None of the above
 Question:* 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
Answer: • 2,3,1,5,4

Question:* What is 'flexi-time'?
Answer: • The flexible use of personal office hours, such as working an hour earlier one day, in order to leave an hour earlier another day.

Question:* Which of the following are proven methods of improving your office skills?
Answer: • All of the above

Question:* When replying to an e-mail, who do you place in the cc: line and who in the bcc: line?
Answer: • 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:* 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?
Answer: • MS Word, MS Excel

Question:* What is a 'golden handshake'?
Answer: • The common usage for a generous employment severance package when an executive loses his or her job through restructuring, redundancy or a scheduled retirement.

Question:* Which of the following is the correct response when you are dealing with a client, and your boss enters the room?
Answer: • Smile, stand up and politely introduce the client.

Question:* Which of the following are considered bad manners while greeting a business visitor to your office?
Answer: • All of the above

Question:* With regard to emails, when is bcc: used?
Answer: • 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.

Question:* What does the 'glass ceiling' refer to in a business context?
Answer: • The upper level of senior management or company executive positions which is traditionally hard to break through, for example, for women and/or minorities.

Question:* 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?
Answer: • Look for a Remove From Mailing List link in the email.

Question:* What does 'the bottom line' commonly refer to in an office environment?
Answer: • The basic controlling factor, notably the financial cost, regarding whether a task or project can be accomplished or not.

Question:* What is the person in charge of administering an office commonly called?
Answer: • Office Manager

Question:* What is the normal length of notice period for quitting job in most professional offices?
Answer: • Either 2 weeks or 1 month

Question:* What is the best practice for ensuring that sensitive material to be destroyed does not leak out of the company building?
Answer: • Always encrypt on computer disk, and shred any hard copies.

Question:* Consider the following sentence: 'There are 20 new PC's in the accounts department.' Should there be an apostrophe in PC's?
Answer: • No

Question:* What information would the petty cash register contain?
Answer: • Details of small expenses related to the running of the office.

Question:* When you are introducing a woman and are unsure of her marital status, which title should you use?
Answer: • Ms.

Question:* You are asked to call up senior executives of your company located in different continents to inform them about the proposed dates for an international sales meeting. What is the best time to call them up?
Answer: • During the call recipient's office hours

Question:* What is 'outsourcing'?
Answer: • Freelancing work to workers outside the main office building, often to foreign workers for cheaper labor costs.

Question:* Which of the following are good office practices when creating documents such as letters, memos, company files etc?
Answer: • Always save to hard drive and at least one back-up, such as a CD or thumb drive.

Question:* What is 'commodity value'�an important business term of relevance to most office environments?
Answer: • An economics term meaning the intrinsic value under optimal, often free-market conditions of the product the company sells or manufactures.

Question:* What is the appropriate response to discovering the printer is out of ink?
Answer: • Replace the ink if the cartridge is available otherwise follow the office procedure for replacing or ordering the cartridges.

Question:* What does 'Class A office space' commonly refer to?
Answer: • The highest quality office space available in a given area.

Question:* What does the CTRL+V shortcut accomplish in Word 2007?
Answer: • It pastes the text that has already been copied.

Question:* Which of the following energy-saving practices can be used in an office without adversely affecting company productivity?
Answer: • Turn off lights and computers at the end of the day

Question:* What is the best way to handle an angry colleague or client with a complaint?
Answer: • 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.

Question:* Which of the following are not recommended when trying to improve working with others in an office environment
Answer: • Talking when others are talking, and listening only occasionally.

Question:* What is the benefit of e-mailing documents rather than always providing hard copies to individuals?
Answer: • The documents can be electronically forwarded, which saves stationery that may otherwise be used.

Question:* Which of the following file formats relate to a graphic file or scanned image file?
Answer: • JPEG

Question:* What is the difference between Microsoft Access and Microsoft Excel?
Answer: • Access is mainly for databases and Excel is for spreadsheets

Question:* What is the most frequently used typeface and point size when creating Word documents?
Answer: • Times New Roman, 12 point

Question:* What is a 'mouse potato'(a comic phrase in an office environment)?
Answer: • The equivalent of a couch potato, but in terms of using a computer — i.e. someone who spends all their time at a computer.

Question:* What is very important to remember to do when entering an office business meeting at any level, especially when clients are there?
Answer: • Turn OFF all cell phones, pagers and other electronic devices.

Question:* What are the traditional office hours in the Western world, now much more flexible, though still adhered to in most offices?
Answer: • 9 AM — 5 PM

Question:* What is an office 'memo circular'?
Answer: • A simple message, usually delivered by e-mail or hard copy and sent to all office staff, updating everyone on new office procedures.

Question:* Traditionally, approximately how many pages should a business CV or resume have?
Answer: • 1-3, preferably 2

Question:* Which of the following activities could possibly infect your computer with a virus?
Answer: • Downloading games and songs from the internet.

Question:* In any office or business environment, what does the 'opportunity success rate' refer to?
Answer: • The number of won opportunities as a percentage of the number of won and lost opportunities.

Question:* What are the dimensions of an A4 size sheet of paper?
Answer: • 210 mm x 297 mm

Question:* What does the abbreviation CEO stand for?
Answer: • Chief Executive Officer

Question:* 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?
Answer: • You talk to the foreign workers and tell them that they should complain to the Upper Management.

Question:* 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
Answer: • Dr. Jones's office, Doctor at sea, Doctor come quickly

Question:* When a client visits the office and arrives early, what does office etiquette require you to do to handle the situation?
Answer: • All of the above.

Question:* Which of the following are the important components of good interpersonal office skills?
Answer: • All of the above

Question:* What does administration generally handle in an office environment?
Answer: • The efficient day-to-day running of the office, with regard to company files, communication, management of jobs such as overseeing hiring and firing and human resources, etc.

Question:* What is 'commodity value'—an important business term of relevance to most office environments?
Answer: • An economics term meaning the intrinsic value under optimal, often free-market conditions of the product the company sells or manufactures.

Question:* Which of the following are commonly used computer web browsers?
Answer: • Chrome, Explorer, Firefox

Question:* What common injury can result from too much concentrated typing over too little amount of time?
Answer: • Repetitive strain injury

Question:* 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?
Answer: • Track the packet on the FEDEX website and send the client a copy of the current status of the packet.

Question:* What two kinds of printers are commonly in use in most office environments?
Answer: • Industrial and private

1 Which of the following file formats relate to a graphic file or scanned image file?
Answers:
• JPEG
• VBP
• HTML
• GIF
• a and d
2. What does ‘the bottom line’ commonly refer to in an office environment?
Answers:
• The line that appears at the bottom of a paper with the company letterhead.
• The lowest office floor in a building.
• The same as the dotted line.
• The basic controlling factor, notably the financial cost, regarding whether a task or project can be accomplished or not.
3. When a client visits the office and arrives early, what does office etiquette require you to do to handle the situation?
Answers:
• If you are free, allow the meeting to start early.
• Take their coat, offer them something to drink, and tell them you will be with them in a moment.
• Try and meet them as soon as possible.
• All of the above.
4. What does ‘Class A office space’ commonly refer to?
Answers:
• Office space on former sites of class A drug offenses.
• The lowest quality office buildings in a given area.
• The highest quality office space available in a given area.
• The highest quality office space for the least price.
5. 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?
Answers:
• Give the client the airway bill number and ask him to call up FEDEX about the status of the courier.
• Give the client the local number of FEDEX in Korea.
• Call FEDEX and ask them to speak directly to the customer.
• Track the packet on the FEDEX website and send the client a copy of the current status of the packet.
6. Which of the following activities could possibly infect your computer with a virus?
Answers:
• Installing pirated Software from a CD.
• Downloading games and songs from the internet.
• Booting your computer with a ‘write protected floppy disk’.
• All of the above
7. What is ‘outsourcing’?
Answers:
• Working outside the office, often from home.
• Freelancing work to workers outside the main office building, often to foreign workers for cheaper labor costs.
• A form of half working from home, half at the office.
• Leaving work early.
8. 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
Answers:
• 5,4,3,2,1
• 3,2,1,4,5
• 3,5,4,1,2
• 2,3,1,5,4
• 3,1,5,2,4
9. When you are introducing a woman and are unsure of her marital status, which title should you use?
Answers:
 Ms.
• Miss
• Mrs.
• Madam
• None of the above
10. What two kinds of printers are commonly in use in most office environments?
Answers:
• Industrial and private
• Hewlett Packard and Brother
• Laser and ink-jet
• Black-and-white and color
• None of the above
11. What is the best way to handle an angry colleague or client with a complaint?
Answers:
• 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.
• Show a little anger as a way of evening out the situation.
• Shout back, and then, later in the day, find a place to sulk, or time to complain to your own boss.
• Listen to their concerns, politely explain what you are able to do, and if they insist, shout back your own concerns and complaints.
12. What does the ‘glass ceiling’ refer to in a business context?
Answers:
• The internal ceiling above the boardroom, whether it is on the top floor or not.
• The roof of the company building, frequently constructed from glass to optimize the company’s public status for the surrounding area.
• The upper level of senior management or company executive positions which is traditionally hard to break through, for example, for women and/or minorities.
• The imaginary level above the CEO at which the company profits skyrocket.
13. Which of the following are not recommended when trying to improve working with others in an office environment.
Answers:
• Talking when others are talking, and listening only occasionally.
• Being as consciously helpful as possible, and offering practical solutions.
• Changing the printer ink or cartridge when it runs out.
• None of the above
14. Consider the following sentence:
‘There are 20 new PC’s in the accounts department.’
Should there be an apostrophe in PC’s?
Answers:
• No
• Yes
• Not sure
• No idea
• None of the above
15. What is a ‘mouse potato'(a comic phrase in an office environment)?
Answers:
• The equivalent of a couch potato, but in terms of using a computer — i.e. someone who spends all their time at a computer.
• A virus or other harmful computer bug, such as a ‘trojan horse’.
• An office ornament that workers place on their desks to keep them motivated during office hours.
• b and c
16. 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?
Answers:
• You talk to the foreign workers and tell them that they should complain to the Upper Management.
• You tell your supervisor that his misbehavior is inappropriate.
• Nothing, you prefer to keep quiet because everybody else is quiet.
• You complain to the Upper Management.
17. Which of the following are good office practices when creating documents such as letters, memos, company files etc?
Answers:
• Always save to hard drive and at least one back-up, such as a CD or thumb drive.
• Save to the hard drive and a back-up, if necessary.
• Save to the back-up first, and then the hard drive.
• Save once a day.
18. What are the traditional office hours in the Western world, now much more flexible, though still adhered to in most offices?
Answers:
• 9 AM — 5 PM
• 6 AM — 6 PM
• 8 AM — 7 PM
• 10 AM — 8 PM
• None of the above
19. 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?
Answers:
• E-mail the Regulatory Authority in charge of stopping spam in order to complain.
• E-mail the source of the emails asking them to stop them.
• Call over a computer expert to solve the problem.
• Look for a Remove From Mailing List link in the email.
20. What is very important to remember to do when entering an office business meeting at any level, especially when clients are there?
Answers:
• Bow slightly before your superiors or company executives.
• Take the coats from clients and drape them over your arm during the meeting.
• Turn OFF all cell phones, pagers and other electronic devices.
• Turn ON all cell phones, pagers and other electronic devices.
• a and c
21. 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
Answers:
• Dr. Jones’s office, Doctor at sea, Doctor come quickly
• Doctor at sea, Doctor come quickly, Dr. Jones’s office
• Doctor come quickly, Dr. Jones’s office, Doctor at sea
• Dr. Jones’s office, Doctor come quickly, Doctor at sea
22. When replying to an e-mail, who do you place in the cc: line and who in the bcc: line?
Answers:
• A person you wish to openly inform goes in the cc: line, and the same person in the bcc: line.
• A person you wish to openly inform goes in the bcc: line, and the same person in the cc: line.
• 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.
• 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.
23. What is the normal length of notice period for quitting job in most professional offices?
Answers:
• Either 2 weeks or 1 month
• 2-3 months
• 1 week
• Up to 3 months, or longer
• None of the above
24. Which of the following energy-saving practices can be used in an office without adversely affecting company productivity?
Answers:
• Use only one bathroom light during office hours
• Turn off lights and computers at the end of the day
• Turn off the computers between sending e-mails
• Use lower Watt light bulbs, especially in the emergency exits
• a and d
25. What common injury can result from too much concentrated typing over too little amount of time?
Answers:
• Leg injury
• Broken neck
• Blue hands
• Repetitive strain injury
• All of the above
26. What is an office ‘memo circular’?
Answers:
• A simple message, usually delivered by e-mail or hard copy and sent to all office staff, updating everyone on new office procedures.
• A circular-shaped memo.
• A letter of introduction by a potential new client.
• A complaint letter to the CEO circulated to and signed by the entire company staff.
27. Which of the following are the important components of good interpersonal office skills?
Answers:
• Effectively translating and conveying information.
• Being able to accurately interpret other people’s emotions.
• Calmly arriving at resolutions to conflict.
• Avoiding gossip and being polite.
• All of the above
28. You are asked to call up senior executives of your company located in different continents to inform them about the proposed dates for an international sales meeting. What is the best time to call them up?
Answers:
• During the call recipient’s office hours
• After your office hours
• During your office hours
• Between 9:00 A.M. and 5:00 P.M.
• Any of the above
29. Which of the following are proven methods of improving your office skills?
Answers:
• Smiling and being appreciative of others, especially the clients.
• Actively listening to, even humoring people at times.
• Looking to resolve conflicts and bringing people together.
• Conveying what is expected in return as an appropriate response, and avoiding ambiguity.
• All of the above
30. Which of the following is the correct response when you are dealing with a client, and your boss enters the room?
Answers:
• Smile, stand up and politely introduce the client.
• Stand up and salute, standing to attention.
• Keep sitting down, but look up without smiling.
• Keep discussing business until your boss politely interrupts.
• a and d
31. What is the appropriate response to discovering the printer is out of ink?
Answers:
• Force the printer to deliver the last drop of ink by turning it upside down, holding it carefully.
• Walk away and tell a fellow office worker, hoping he or she will take responsibility.
• Leave it to the next person.
• Replace the ink if the cartridge is available otherwise follow the office procedure for replacing or ordering the cartridges.
32. What are the dimensions of an A4 size sheet of paper?
Answers:
• 216 mm x 279 mm
• 220 mm x 310 mm
• 215 mm x 295 mm
• 210 mm x 297 mm
• a and d
33. Which of the following are commonly used computer web browsers?
Answers:
• Mozilla, Guardian Website, The Times of London, MSN
• Expedia, Opodo, Student Universe, Godzilla
• Chrome, Explorer, Firefox
• Google, MSN, Yahoo, Ask
34. What is ‘flexi-time’?
Answers:
• The feeling when time slows down or speeds up at certain times of the day in an office environment.
• The flexible use of personal office hours, such as working an hour earlier one day, in order to leave an hour earlier another day.
• Occasionally moving the hands on the office clock so everyone can go home early now and then.
• Bringing an alarm clock to work that rings at the end of the day and at lunchtimes.
35. What is the person in charge of administering an office commonly called?
Answers:
• Office Assistant
• Full-time Manager
• Office Manager
• CEO
• None of the above
36. What does the CTRL+V shortcut accomplish in Word 2007?
Answers:
• It makes the selected text appear in bold.
• It pastes the text that has already been copied.
• It converts the selected text into the next larger size of the same font.
• It applies italic formatting to the selected text.
• All of the above
37. In any office or business environment, what does the ‘opportunity success rate’ refer to?
Answers:
• The success of a business in dollar value minus the dollar value of previous attempts to make it a success.
• The number of won opportunities as a percentage of the number of won and lost opportunities.
• The number of lost opportunities as a percentage of the number of almost won opportunities.
• The opportunity costs divided by the so-called sunk costs.
38. Which of the following are considered bad manners while greeting a business visitor to your office?
Answers:
• Remaining seated while the visitor introduces himself/herself
• Not shaking hands, but simply saying hello with a smile
• Shaking hands from the shoulder rather than the elbow
• Shaking hands with gloves on, or forgetting to smile
• All of the above
39. What is the difference between Microsoft Access and Microsoft Excel?
Answers:
• Access is mainly for spreadsheets and Excel is for databases
• Access is mainly for databases and Excel is for spreadsheets
• Access is mainly for databases and Excel is for word processsing
• Access is mainly for word processing and Excel is for spreadsheets, including digitial photograph editing
40. What does administration generally handle in an office environment?
Answers:
• Paperwork and accounts.
• Specifically, the hiring of new management and middle management.
• The efficient day-to-day running of the office, with regard to company files, communication, management of jobs such as overseeing hiring and firing and human resources, etc.
• Ensuring that the infrastructure of the building is regularly checked and modernized.
41. What information would the petty cash register contain?
Answers:
• Details of expenses on account of the administrative staff.
• Details of small expenses related to the running of the office.
• Details of expenses on account of electricity and water bills.
• Details of expenses worth less than $80.
42. 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?
Answers:
• MS Powerpoint, MS Access
• Adobe Photoshop, MS Powerpoint
• MS Word, MS Excel
• MS Excel, MS PowerPoint
43. What is the best practice for ensuring that sensitive material to be destroyed does not leak out of the company building?
Answers:
• Always encrypt on computer disk, and shred any hard copies.
• Shred hard copies, save onto the file.
• Burn hard copies, save only once to the file.
• E-mail documents to colleagues, and then close the e-mail browser.
44. Traditionally, approximately how many pages should a business CV or resume have?
Answers:
• 1-3, preferably 2
• 1-5, but usually 2-3
• Just 1
• Exactly 2 and a half, and never more or less
• All of the above
45. With regard to emails, when is bcc: used?
Answers:
• 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.
• 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.
• When you want to send the same mail to several people and want to receive acknowledgments from each recipient.
• When you want to send the same mail to several people, but the mail does not support attachments.
46. What is the benefit of e-mailing documents rather than always providing hard copies to individuals?
Answers:
• There is no benefit except that people can delete them more easily.
• The documents can potentially be edited online and re-circulated.
• The documents can be electronically forwarded, which saves stationery that may otherwise be used.
• b and c
47. What is ‘commodity value’—an important business term of relevance to most office environments?
Answers:
• The value of all the office hardware, including computers and furniture.
• An economics term meaning the intrinsic value under optimal, often free-market conditions of the product the company sells or manufactures.
• The value of common decency between employees of a given office.
• The cost in petty cash of all company-expense dinners in a given month.
48. What is a ‘golden handshake’?
Answers:
• The welcome to the building of a new CEO.
• The last day in the office before the holidays.
• The common usage for a generous employment severance package when an executive loses his or her job through restructuring, redundancy or a scheduled retirement.
• The common usage for a series of re-hirings of past employees.
• c and d
49. What is the most frequently used typeface and point size when creating Word documents?
Answers:
• Times New Roman, 12 point
• Times, 14 point
• Courier New, 12 point
• Courier New, 14 point
• All of the above
50. What does the abbreviation CEO stand for?
Answers:
• Company Executive Officer
• Communicate Especially On
• Corporate Exact Office
• Cheat Every One
• Chief Executive Officer
51. What is ‘commodity value’-an important business term of relevance to most office environments?
Answers:
• The value of all the office hardware, including computers and furniture.
• An economics term meaning the intrinsic value under optimal, often free-market conditions of the product the company sells or manufactures.
• The value of common decency between employees of a given office.
• The cost in petty cash of all company-expense dinners in a given month.


74 Answered Test Questions:

1. Which of the following axis settings are available for the appearance of data bars for negative values in Microsoft Excel 2010?
Answers: 
• Automatic
• Cell midpoint
• Cell right
• Cell left
2. Which of the following is true regarding Microsoft Excel 2010 Web App?
Answers: 
• It is possible to work with sparklines and slicers on an Excel Web Access page after publishing an Excel workbook to a SharePoint library.
• It is possible to view a workbook, as well as comments contained in it, in the browser view in Excel Web Access.
• Changing data types is allowed while using the edit capability of a published workbook in Excel Web Access.
• A shared workbook can be loaded in the browser.
3. Which of the following statements regarding images in Microsoft Excel 2010 are true?
Answers: 
• Microsoft Excel 2010 validates images which are in the form of external and active content.
• Microsoft Excel 2010 provides for changing the sharpness and contrast of images but not changing their transparency.
• Microsoft Excel 2010 supports 3D rotation of images.
4. 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?
Answers: 
• It will select the whole sheet, having the same effect as that of Ctrl+A.
• It will close and save this particular worksheet of the workbook.
• Nothing will happen.
• It will hide this particular worksheet.
5. Which of the following types of worksheets will not load in Microsoft Excel Services?
Answers: 
• Worksheets with ActiveX controls
• Worksheets with tables
• Worksheets with hyperlinks
• Worksheets with Organization Charts and Diagrams
• All of the above
6. Why would you use content controls in a document?
Answers: 
• To get information from another source and have it appear at a specific place in a document.For example, the customer data automatically appears when you create a new invoice.
• To create a document and restrict what people can do with it. For example, you create a document that contains legal language, and you want to ensure people don't accidentally change or delete any of its text.
• To create structured regions of a document that people fill out. For example, the cover page of the proposal can't be changed except by filling out the title and author.
• All of the above
• None of the above
7. Which of the following actions CANNOT be performed by the user on the Business Contact Manager database?
Answers: 
• Update records
• Create new records
• Delete records permanently
• Move records to the Deleted Items folder
8. If a table cell is vertically split into two separate cells using the Draw Table option, any existing text in the cell will be split up and text will appear in both of the two newly created cells .
Answers: 
• True
• False
9. 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?
Answers: 
• Fill color, More Fill Colors
 Background Color
• Texture
• Pattern
10. 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:
Answers: 
• "Add to Quick Style List" in the Styles pane.
• "New documents based on this template" under modify style option.
• Copy the style to each document manually each time you want to use it.
11. Which of the following delegate permission levels allows you to change and delete the items that the manager created?
Answers: 
• Author
• Editor
• Reviewer
12. What is one way to ensure that the sound icon doesn't show in the presentation?
Answers: 
• By choosing Hide During Show from the Audio Tools Playback tab of the Ribbon
• By applying a transparent picture fill effect to the sound icon on the slide
• By clicking the Sound Options Dialog Launcher on the Ribbon and checking Hide audio icon during slide show
• All of the above
13. Which of the following is INCORRECT regarding setting of passwords in Microsoft Outlook 2010?
Answers: 
• 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.
• If you are running Outlook with a Microsoft Exchange account, your data for that account, including password access, is automatically managed by Microsoft Exchange.
• You can set a password for individual folders within the .pst.
• None of the above
14. 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?
Answers: 
• Office Database connections
• Online Analytical Processing (OLAP) Queries
• Online Analytical Processing (OLAP) Cube Files
15. With which chart type(s) is the "Depth Gridlines" option available?
Answers: 
• Bubble chart
• Line chart
• True 3D chart
• All of the above
16. Which of the following tag is not available in Microsoft Outlook 2010?
Answers: 
• Unread/read
• Follow Up
• Categorize
• Show in Favorites
17. By default, when you paste a chart from Excel into PowerPoint 2007, is it linked or embedded?
Answers: 
• It is linked
• It is embedded
18. Below are two statements regarding Breaks in Microsoft Word 2010.

Statement X: Text Wrapping Page Break separates text around objects on web pages, such as caption text from body text.
Statement Y: Continuous Section Break inserts a section break and starts the new section on the next page.

Which of the following options is correct?
Answers: 
• Statement X is correct. Statement Y is incorrect.
• Statement X is incorrect. Statement Y is correct.
• Both Statements X and Y are correct.
• Both Statements X and Y are incorrect.
19. Which of the following is not a category of transition?
Answers: 
• Subtle
• Exciting
• Dynamic Content
• Emphasis
20. 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?
Answers: 
• 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.
• By opening the .thmx file with Microsoft Word 2010 and pasting the complete report text into it.
• Dave's Boss is wrong. No such arrangement is possible in Microsoft Word 2010.
• 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.
21. How can you remove duplicate emails present in a particular folder?
Answers: 
• By using the Clean Up Folder option.
• By repeatedly using the Send/Receive mails option.
• By applying filtration of the email according to groups, in a particular folder.
• By sorting the emails received in a particular folder.
22. How do you turn off the controls that show in the lower left corner of the screen during a slide show?
Answers: 
• Right-click the controls in the slide show and choose Don't Show
• Choose the menu Tools -> Options and uncheck Show Popup Toolbar on the View tab
• Choose the menu File -> Options -> Advanced and select Show Popup Toolbar
• Press F1 during the slide show
23. You are a financial consultant to multiple clients and you made an investment model for them. Now you want to find out how investment rates change under different market conditions. Which of the following Microsoft Excel 2010 What-if analysis tools will you use to study such conditions?
Answers: 
• Scenarios
• Data tables
• Goal Seek
24. In Microsoft Excel 2010, The LOOKUP function returns a value either from a one-row or one-column range or from an array. Which of the following statements are true regarding the LOOKUP function in Microsoft Excel 2010?
Answers: 
• lookup_value is an optional argument of the LOOKUP function in Microsoft Excel 2010 when the vector form is used.
• The values in the array used by the LOOKUP function in Microsoft Excel 2010 must be in the ascending order.
• If the array used by the LOOKUP function in Microsoft Excel 2010 contains more columns than rows, then LOOKUP searches for the value of lookup_value in the first column.
• If the array used by the LOOKUP function in Microsoft Excel 2010 contains more rows than columns, then LOOKUP searches for the value of lookup_value in the first column.
25. The image given above is that of the Recording toolbar, which appears when you Rehearse Timings. What does the part of the toolbar marked 'A' in the image refer to?
Answers: 
• It displays the slide time.
• It displays the total presentation time.
• It displays the time taken by the first slide.
• None of the above
26. 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?
Answers: 
• The red triangles represent the comment associated.
• The red triangles signify an associated data validation control.
• The red triangles represent the tracking of the cell.
• The red triangles signify that the cell is a hidden cell.
27. 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.
Answers: 
• True
• False
28. Which of the following are included in a digitally signed e-mail message?
Answers: 
• Certificate
• CAPTCHA image
• Public key
• Sender's full name
29. 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?
Answers: 
• Ignore
• Clean Up
• Delete
30. Which of the following methods will you use to insert a hyperlink in a message in Microsoft Outlook 2010, if the format of the mail is set to Rich Text?
Answers: 
• Type the hyperlink in the body of the message.
• Drag a hyperlink into the body of the message.
• Click on the Insert tab-> Go to the Links group-> Add Hyperlink.
• Any of the above methods can be used.
31. If you were writing a book and wanted each chapter to start on the right page, which Section Break would you use to begin each chapter?
Answers: 
• Even Page
• Odd Page
• Continuous
32. Which standard form is used to record actions which relate to specific contacts and put the action in a Timeline view?
Answers: 
• Post
• Journal Entry
• Appointment
• Task Request
33. Which of the following areas in the Microsoft Excel 2010 PivotTable Field List, calculates the aggregates of columns?
Answers: 
• Report Filter
• Row Labels
• Values
34. If I do not want the contents of one of my fields to automatically update, I would have to do which of the following?
Answers: 
• Lock the field.
• Protect the field.
• Make the field hidden.
• Turn field shading off.
35. Consider the following scenario:

A table cell contains text. You place your cursor in that cell and split it into two columns. The resultant text will:
Answers: 
• be spread across both cells.
• be deleted.
• remain intact in the first cell and the second cell will be empty.
36. How will you read comments that reviewers have added to your presentation?
Answers: 
• On the View tab, in the Show/Hide group, click on Show Comments.
• On the Review tab, in the Comments group, click on Show Markup.
• Both a and b
• None of the above
37. Which of the following animation Effect Options will you choose when you want the SmartArt diagram to animate piece by piece?
Answers: 
• One by one
• As one object
• Dim after animation
• By 1st Level Paragraphs
38. What is one thing the Compress Pictures feature does?
Answers: 
• Changes all pictures from color to black and white
• Decreases the contrast of all pictures in the presentation
• Permanently deletes cropped areas of pictures
• Condenses the pictures to one area of the slide
39. Which of the following is NOT an option when inserting a Cross-reference?
Answers: 
• Numbered item
• SmartArt
• Heading
• Equation
• Table
40. Refer to the image above and identify which Home tab group these commands belong to?
Answers: 
• Move
• Quick Steps
• Respond
• Tags
41. What is the purpose of time stamping a digital signature in Microsoft Excel 2010?
Answers: 
• It helps you mitigate integrity threats.
• It ensures that digital signatures remain valid and legally defensible even if the certificate that is used to sign the document expires.
• It enables you to specify cryptographic settings for encrypting documents.
• It is a security tool that enables users to designate safe documents.
42. In MS Excel when your cursor is in the last cell of a table, what does Tab key do?
Answers: 
• Adds a row at the bottom of the table
• Adds a row at the top of the table
• Adds a column to the right of the current cell
• Places your cursor on the next object on the slide
43. Suppose you want to use the Translate command to work with the text. Where can you locate it on the Ribbon?
Answers: 
• In the Insert tab
• In the Design tab
• In the View tab
• In the Review tab
44. Which of the following types of tabs is displayed in the tab row when an object, such as an image, is selected or highlighted in the application workspace, in Microsoft Outlook 2010?
Answers: 
• Standard ribbon tabs
• Modal tabs
• Contextual tabs
45. Which of the following statements is not true regarding offline cube files in Microsoft Excel 2010?
Answers: 
• An offline cube file stores data in the form of an OLAP cube.
• The file format for an offline cube file is .ocf.
• An offline cube file allows you to work with PivotTable and PivotChart reports even when the server is unavailable.
46. To insert a new citation to a specific book in a Microsoft Word 2010 document, you should select:
Answers: 
• References" > "Style".
• References" >"Insert Citation" >"Add New Source.
• References" >"Insert Citation" >"Add New Placeholder.
• None of the above
47. You customized the navigation pane with a lot of folders and shortcuts but now you want to remove all of them. What command line switch would you use with outlook.exe to remove the folders you added?
Answers: 
• /profiles
• /resetfolders
• /resetnavpane
• /recycle
48. How would you write on the slides during a slide show?
Answers: 
• 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.
• On the Slide Show tab, in the Set Up group, select a pen and then drag it to write.
• 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.
• All of the above
49. 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?
Answers: 
• Opportunity
• Marketing Activity
• Business Project
• Business Contact
50. The default chart colors are determined by what?
Answers: 
• Slide Design Effects
• Slide Background Graphics
• Slide Fill Shading
• Slide Color Scheme
51. How would you assign a macro to a graphic?
Answers: 
• On the Developer tab, in the Code group, click on Macros.
• 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.
• 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.
• You can use any of the above three techniques.
• You cannot assign a macro to a graphic.
52. 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?
Answers: 
• It will shift the message to the Spam folder.
• It will disable all the links in the e-mail.
• It will disable the Reply and Reply All commands.
• It will delete the e-mail.
53. In MS 2010 PowerPoint, how would you crop a picture to an exact set of dimensions?
Answers: 
• 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.
• 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.
• Both a and b
• None of the above
54. What are the benefits of digitally signing an e-mail in Microsoft Excel 2010?
Answers: 
• Digital signatures help authenticate the source of the messages.
• 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.
• Digitally signed e-mails meet legal requirements for admissibility and authenticity.
• All of the above.
55. Which of the following describes the outcome of double-clicking on a pivot report value of a PivotTable in Microsoft Excel 2010?
Answers: 
• Excel displays data corresponding to the pivot report value on the same sheet.
• Excel creates a new sheet with data corresponding to the pivot report value.
• Excel creates a new workbook with data corresponding to the pivot report value.
56. Suppose you have created a report in Excel named 'report.xlsx'. Now you want your team members should be able to see the report remotely on a web browser, and edit the report, as desired. Also it is required that the previous versions of the report are maintained to protect against any loss of data. Which of the following options is the most suitable one to deploy this report?
Answers: 
• Share 'report.xlsx' by saving it to SkyDrive.
• Share 'report.xlsx' by saving it to a SharePoint site.
• Share 'report.xlsx' by sending it through email.
57. How would you add a logo to all the slides in a presentation?
Answers: 
• In the Normal editing View, paste the logo onto every slide in the presentation.
• In the Slide Master View, add the logo to the slide master and the title slide layout.
• In the Slide Master View, add the logo to the blank slide layout.
• None of the above
58. In Microsoft Word 2010, "Keep lines together" paragraph formatting:
Answers: 
• works well for paragraphs within a table if "Allow row to break across pages" is also selected.
• automatically enables the text rows to break across pages.
• does not work for paragraphs within a table if "Allow row to break across pages" is also selected.
• always works for paragraphs within a table.
59. Which of the following defines the correct purpose of using a poster frame image?
Answers: 
• To add still image introduction to the video
• To add visual effect to the narration
• To insert a picture on any part of the screen
• To create or edit a presentation based on a set of pictures
60. You want to add an image as the first character in your paragraph. Which type of text wrapping treats your graphic as if it were a character?
Answers: 
• Through
• Square
• In Front of Text
• In Line with Text
61. Which among the following settings is the default macro security setting?
Answers: 
• Disable all macros without notification.
• Disable all macros except digitally signed macros.
• Disable all macros with notification.
• Enable all macros.
62. What does the Compare tool do?
Answers: 
• Compares changes in two presentations
• Compares one image to another to indicate differences
• Compares file size
• Compares presentations for backward compatibility
63. Which among the following chart types do not have axes?
Answers: 
• Bar charts
• XY (Scatter) charts
• Doughnut charts
• Area charts
64. Format Painter will not normally work with pictures in which the text wrapping is set to:
Answers: 
• Square
• Behind Text
• In Front of Text
• In Line with Text
65. Which level of junk e-mail protection available in Microsoft Outlook 2010 will you apply, if you want all such e-mails to be treated as junk whose senders are neither on your Safe Senders List nor on your Safe Recipients List?
Answers: 
• No Automatic Filtering
• Low
• High
• Safe Lists Only
66. Which picture format maintains transparency in MS 2010 Powerpoint?
Answers: 
• .png
• .gif
• .jpg
• .wmf
67. How do you insert a new slide master into a presentation?
Answers: 
• In Master View, click the Insert Layout button
• In Master View, click the Insert Slide Master button
• In Slide Sorter View, click the Insert Slide Design button
• In Normal editing View, click the Insert Slide Design button
68. In the Customize Ribbon dialog, choosing Reset All Customizations does what?
Answers: 
• It restores the Ribbon to the default settings.
• It restores the Quick Access Toolbar to the default settings.
• It restores both the Ribbon and the Quick Access Toolbar to the default settings.
69. How many items can be maintained on the clipboard at one time?
Answers: 
• One
• Up to 24
• Unlimited
• Up to 100
70. You added a custom tab in the Microsoft Excel Ribbon and exported this Ribbon Toolbar customization into a file named 'custom.exportedUI'. After a few days, you import this Ribbon Toolbar customization file back to Microsoft Excel 2010. What will happen to the prior Ribbon Toolbar customizations made during this period?
Answers: 
• All prior customizations will be retained.
• All prior customizations will be merged.
• All prior customizations will be lost.
71. How do you repair a Microsoft Outlook 2010 .pst file if it gets damaged?
Answers: 
• By using the last backup .pst file.
• By scanning the .pst file with scanpst
• By re-logging into the mail account.
• The file cannot be repaired.
72. 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?
Answers: 
• Info
• Open
• Options
• None of these
73. 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?
Answers: 
• He sets the Line Spacing on the formatting toolbar to 1.0.
• 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.
• He uses the Shift and Enter keys at the same time to create a new paragraph.
• 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.
74. In the given screenshot, the contents of the 'Name of User' column have been oriented at an angle. How is this done?
Answers: 
• By using the 'Orientation' button in the alignment group of the 'Home' tab.
• By using the 'Format Cells' in the context menu.
• By using the 'Orientation' button on the 'Page Layout' tab.
• By using the 'WordArt' button on the 'Insert' tab.

3 NOT Answered Yet Test Questions:

(hold on, will be updated soon)
75. What view must be used when inserting a subdocument?
Answers: 
• Print Layout
• Web Layout
• Outline
• Full Screen Reading
76. Which among the following command-line switches starts up Microsoft Outlook 2010 with the Reading Pane turned off?
Answers: 
• /noextensions
• /nocustomize
• /nopreview
• /profiles
77. For which of the following Business Contact Manager record types is it mandatory to be linked to an Account or Business Contact record?
Answers: 
• Marketing Activity
• Project Task
• Opportunity
• Business Project

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 (Answer)
    d.     Google, MSN, Yahoo, Ask 

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


Comments

  1. Just got my check for $500.

    Sometimes people don't believe me when I tell them about how much you can earn by taking paid surveys online...

    So I took a video of myself actually getting paid over $500 for filling paid surveys to set the record straight once and for all.

    ReplyDelete
  2. Get daily suggestions and methods for generating THOUSANDS OF DOLLARS per day FROM HOME totally FREE.
    JOIN FOR FREE

    ReplyDelete

Post a Comment

Popular posts from this blog

Freelancer Wordpress Exam Answers 2016

How To Build Backlinks in Minute For FREE Easy Method 100% Working