Office 2007 Quiz - The Answers

As promised here are the answers to the Office 2007 quiz I posted last week. As before, bear in mind that the questions and answers were written 12 months ago at the launch of Office 2007. I've skimmed through them to see if any answers may have changed since that time and have only spotted one (question 9). If you see any others feel free to point them out.

Now, honestly, did anyone get 40/40 without the help of a search engine? I think some of these are tough.

Number

Question

Answer

1

The toolbar in Office 2007 is known as what?

The Ribbon / Fluent Ribbon

2

What is the name of the new peer-to-peer based collaboration tool in Office 2007?

Groove

3

Which Microsoft Office product allows you to quickly build forms that link to XML backends?

InfoPath

4

In what year was the Microsoft Office version prior to 2007 released (Windows Version)?

2003 (Note that a Mac version was released in 2004)

5

What is the name of the toolbar that provides quick access to your most commonly-used Office commands? (clue: the answer is in the question)

Quick Access Toolbar

6

How many SmartArt graphics are included in Microsoft Word 2007?

More than 80

More than 100

More than 500

More than 1000

More than 100

7

What is the new file extension for an Excel spreadsheet saved using the default file format?

.xlsx

8

True or False: The default file formats for Word, Excel and Powerpoint are now XML files that are zipped automatically

True

9

What is the name of the primary tool for developing solutions built on Microsoft Office?

Visual Studio Tools for Office (or “Visual Studio Tools for the Microsoft Office System”)

[Update 2008: The correct answer today would be Visual Studio 2008]

10

How many rows can Excel 2007 support?

1 million

10 million

100 million

Unlimited

1 million

11

How many columns can Excel 2007 support?

5,000

10,000

13,000

16,000

16,000

12

When was the 2007 Microsoft Office system released to manufacturing (RTM’d)?

6 November 2006 (or just “November 2006” will do)

13

How many products are included in Microsoft Office Basic 2007?

3

(Word, Excel and Outlook)

14

What is the recommended product to use for sharepoint site development?

Sharepoint designer

15

Which Microsoft Office 2007 server product allows you to interact with InfoPath forms via a web browser?

Office Forms Server 2007 (or just “Forms Server”)

16

True or False: Microsoft Office Sharepoint Server 2007 runs on 64-bit versions of Microsoft Windows?

True

17

True or False: Microsoft Entourage is an e-mail client and personal information manager developed by Microsoft for Mac OS 8.5 and higher

True

18

True or False: Microsoft Word was originally called “Multi-Tool Word” and developed for the Xenix operating system

True

19

Which Microsoft Office product allows you to connect SharePoint to the line of business applications and surface that data through web parts, lists and search

Business Data Catalog

20

PowerPoint was originally developed by which failing Silicon Valley company in the mid Eighties?

Forethought

21

True or False: The user can change the default file format for Office 2007 to use the older (Office 2003) formats as default

True

22

What is the absolute minimum amount of RAM officially supported for Office Basic 2007? 64MB

256MB

512MB

1GB

256MB

23

Which of these Office 2007 products does not have the new-look menus and toolbars?

Word 2007

Excel 2007

Outlook 2007

Access 2007

Outlook 2007

24

Which Microsoft executive is the original creator of Lotus Notes?

Ray Ozzie

25

True or False: Office 2007 is the first version of Microsoft Office that supports XML

False

26

Which Microsoft Office product allows you to process Excel documents on a server and present spreadsheets via a web browser?

Excel Server

27

What does the abbreviation MOSS stand for in the context of Microsoft Office?

Microsoft Office SharePoint Server

28

Which .NET Framework 3.0 technology is used as the workflow engine for Microsoft Office SharePoint Server?

Windows Workflow Foundation (or just “WF”)

29

True or False: Microsoft Office Open XML is an ECMA International standard

True

30

What was the codename of the 2007 Microsoft Office System?

Office 12

31

What year was Microsoft Office first released?

1985

1989

1991

1993

1989

32

Which three products were included in the first ever “non pro” version of Microsoft Office?

Excel, Word, PowerPoint.

(The Pro version additionally included Access and Schedule+)

33

In what year will mainstream support for Office 2003 end?

2007

2008

2009

 

2009

34

True or False: On versions of Microsoft Office before 2003, the Save Icon's floppy disk had the shutter on the wrong way around

True

35

What was the codename for Microsoft Office PerformancePoint Server 2007?

Biz#

36

In what year did Microsoft acquire Seattle-based Visio Corp for US$1.5 billion in stock?

2000 (actual date 7 Jan 2000)

37

True or False: Microsoft acquired the original version of Excel from a small startup company in 1983

False (Excel was developed in-house at Microsoft)

38

Which was the first version of Microsoft Office to include OneNote?

2003

39

True or False: Microsoft Office was released for the Apple Macintosh operating system before it was released on Windows

True (First Mac version 1989, first Windows version 1990)

40

In what year did Microsoft acquire Groove Networks?

2005