Microsoft Office and Open Office: Office Suite Applications

An error occurred trying to load this video.

Try refreshing the page, or contact customer support.

Coming up next: Desktop Publishing & Word Processing Software: MS Word, InDesign & WordPerfect

You're on a roll. Keep up the good work!

Take Quiz Watch Next Lesson
Your next lesson will play in 10 seconds
  • 0:05 Typical Software Use
  • 2:10 Benefits
  • 3:29 Different Office Suites
  • 5:05 Lesson Summary
Save Save Save

Want to watch this again later?

Log in or sign up to add this lesson to a Custom Course.

Log in or Sign up

Speed Speed

Recommended Lessons and Courses for You

Lesson Transcript
Paul Zandbergen

Paul is a GIS professor at Vancouver Island U, has a PhD from U of British Columbia, and has taught stats and programming for 15 years.

Expert Contributor
Christianlly Cena

Christianlly has taught college physics and facilitated laboratory courses. He has a master's degree in Physics and is pursuing his doctorate study.

Office suite software is a collection of commonly used applications. It typically includes word processing, spreadsheet, presentation and database software. Learn how these applications work together to increase productivity in this video lesson.

Typical Software Use

Consider yourself working in the marketing department of a large organization. You are the manager of one of the units in the department, and your unit is responsible for updating sales reports. Let's look at how you spend a typical day.

Throughout the day you use your e-mail. In the morning, you receive an e-mail from one of your staff members - she is working on a quarterly report and needs your feedback. You open up the report in your word processor software, add some comments and then send the report back to her. A little bit later, you get a phone call alerting you that the new sales figures have been updated. You open up your database software to check the latest numbers. You take last week's data and export it to spreadsheet software to make a graph of the trend in sales of selected products.

You have a meeting later in the day, and so you copy and paste the new graph into your presentation software to prepare a slideshow so you can share your sales analysis. Back in your office after the meeting, you type up your meeting notes in your word processing software, include the graph from the spreadsheet software and send this all around to the staff. It was another fine day at the office.

The various types of software that you have used each have their own specific functionality. However, they are often used in combination and it makes sense to bundle them in an office suite or productivity suite. An office software suite is a collection of software applications that are distributed together and are designed to interact with each other. Applications typically included in a software suite are word processing, spreadsheet, presentation, and database software.

Many other software applications can be bundled into an office suite - for example illustration software, photo editing software, software to create diagrams, collaborative software tools, and several others. However, these are less common and whether they are included or not depends on the type of office suite.


There are a number of benefits to using an office suite instead of a series of independent software applications:

  • The various software applications have a similar interface. This makes it easier to learn the software and to switch between them.
  • The software is designed to work together. This makes it easier to insert documents of one type into another. For example, if you can copy a graph from a spreadsheet into a presentation, you are still able to edit the graph because the programs are linked.
  • The cost of an office suite is often much less than the sum of the various applications combined.

Typically, when an organization adopts office suite software, most employees will end up using the software from the same company. This can reduce training costs and facilitate sharing of documents. Remember the example where you open a report written by one of your staff members, added some comments on it and then returned it to her? That's a lot easier if you are both using the same software.

To unlock this lesson you must be a Member.
Create your account

Additional Activities

Modified True or False Exercise on Office Suite Applications


Test your knowledge of the lesson on office suite applications such as Microsoft Office and Open Office by determining whether the following statements are true or false. For this activity, print or copy this page on a piece of paper. Write TRUE if the statement is valid and FALSE if otherwise on the blank space provided. If the statement is FALSE, write down the word or phrase that makes it wrong.

__________1. Office suite software is a collection of commonly used applications that includes stand-alone video and audio editing features.

__________2. Using the same office software typically reduces training costs and facilitates sharing of documents.

__________3. The software as a service approach requires local installation, with the software readily accessible online using only an internet browser.

__________4. Google Docs also makes it possible to work with your document on a mobile phone with the Android operating system.

__________5. Local installation refers to the most common way of installing software on the hard drive of a local computer.

__________6. Office suites have built-in tools to convert and open documents of different formats.

__________7. The various office software applications have a distinct interface.

__________8. Using a series of independent software applications is more beneficial compared to an office suite.

__________9. OpenOffice is an open source office suite that is basically free.

__________10. iWork by Apple is another office suite application, which includes Database, Pages, Numbers, and Keynote.

Answer Key

1. FALSE, stand-alone video and audio editing features


3. FALSE, requires




7. FALSE, distinct

8. FALSE, more beneficial


10. FALSE, Database

Register to view this lesson

Are you a student or a teacher?

Unlock Your Education

See for yourself why 30 million people use

Become a member and start learning now.
Become a Member  Back
What teachers are saying about
Try it risk-free for 30 days

Earning College Credit

Did you know… We have over 200 college courses that prepare you to earn credit by exam that is accepted by over 1,500 colleges and universities. You can test out of the first two years of college and save thousands off your degree. Anyone can earn credit-by-exam regardless of age or education level.

To learn more, visit our Earning Credit Page

Transferring credit to the school of your choice

Not sure what college you want to attend yet? has thousands of articles about every imaginable degree, area of study and career path that can help you find the school that's right for you.

Create an account to start this course today
Try it risk-free for 30 days!
Create an account