Microsoft Office, usually called MS Office, is a very popular set of application software developed by Microsoft. It is a suite, which means a collection of programs that work together. MS Office helps us do office and school work easily, such as writing documents, making calculations, and preparing presentations.
In this chapter, we will learn about the main programs of MS Office: MS Word for writing, MS Excel for calculations, and MS PowerPoint for presentations. We will understand the parts of each program's window and learn how to do basic tasks in each one. By the end of this chapter, you will be able to create a simple document, make a simple spreadsheet, and build a simple presentation.
MS Office is a package of application software made by Microsoft. It is used in schools, offices, and homes all over the world. The most common programs in MS Office are:
MS Office programs share many common features. They all have a ribbon at the top with tabs like Home, Insert, and Review. They all let us open, save, and print files. Because they work together, we can copy a table from Excel and paste it into a Word document, or copy a chart from Excel into a PowerPoint slide.
MS Word is a word processor. It is used to type, edit, and format text. We use it for letters, essays, reports, stories, and many other documents.
A Word document is stored as a file with the extension .docx. The main window of Word has:
Ribbon and Tabs: At the top of the window there is the ribbon, which has tabs such as Home, Insert, and Design. The Home tab has the most common commands like bold, italic, and underline.
Ruler: The ruler helps us see and set the margins of the page.
Text area: This is the large white area where we type our text. A blinking vertical line called the cursor shows where the text will appear.
Status bar: The bar at the bottom shows the page number and the word count.
Some common tasks in Word are: - Selecting text: We drag the mouse over text to select it. - Formatting: We can make text bold, italic, or underlined using the Home tab. - Changing font: We can change the style, size, and colour of the text. - Saving: We click File and then Save to keep our document. - Printing: We click File and then Print to get a paper copy.
MS Excel is a spreadsheet program. It is used to store numbers in tables and to do calculations automatically. It is very useful for marks lists, budgets, and any work involving numbers.
An Excel file is called a workbook, and it is saved with the extension .xlsx. A workbook is made of many sheets, which are like pages. Each sheet is made of rows and columns.
Rows: The horizontal lines of cells, numbered 1, 2, 3 and so on.
Columns: The vertical lines of cells, named A, B, C and so on.
Cell: The box where a row and a column meet. A cell has an address made of its column letter and row number. For example, the cell where column A and row 1 meet is called A1.
The magic of Excel is its formulas. A formula is an instruction that makes Excel calculate an answer. Every formula begins with the equals sign (=). For example, if we want to add the numbers in cells B2 and B3, we write =B2+B3 in another cell and press Enter, and Excel shows the sum. This automatic calculation saves a lot of time and avoids mistakes.
MS PowerPoint is a presentation program. It is used to create slides that show information on a screen. Teachers use PowerPoint to teach lessons, and students use it for project presentations.
A PowerPoint file is saved with the extension .pptx. A presentation is made of many slides. Each slide can hold text, pictures, charts, and videos.
The main parts of the PowerPoint window are:
Slides pane: On the left, we see small pictures of all the slides.
Slide area: In the centre, we see the current slide where we are working.
Placeholders: Boxes on a slide where we can type a title, text, or insert a picture.
To create a presentation, we choose a design, add slides, type the content, and then show it. To show a presentation, we press the F5 key to start the slide show from the beginning. We can add effects like animations and transitions to make slides attractive, but we should not use too many, as they can distract the audience.
All MS Office programs share some common tasks:
Opening a file: We click File and then Open, or press Ctrl + O, to open an existing file.
Saving a file: We press Ctrl + S or click File and then Save. It is wise to save our work often so that we do not lose it.
New file: We click File and then New to create a blank document, workbook, or presentation.
Printing: We press Ctrl + P or click File and then Print.
Undo: We press Ctrl + Z to undo a mistake, and Ctrl + Y to redo it.
Copy, cut, and paste: We use Ctrl + C to copy, Ctrl + X to cut, and Ctrl + V to paste selected text or objects.
Formatting means making text look neat and attractive. In MS Word we can:
A neatly formatted document is easy to read and looks professional. Good formatting, clear headings, and correct spelling make a document impressive.
The true power of MS Office is that its programs work together. A student can make a chart in Excel, copy it, and paste it into a report in Word. The same chart can be added to a PowerPoint slide for a class presentation. Tables, pictures, and charts can move freely between the programs.
MS Office also allows us to check spelling, add images, create tables, and print our work neatly. Because it is used in almost every office, learning MS Office at school prepares us for the future workplace.
| Program | Purpose | File Extension |
|---|---|---|
| MS Word | Typing and editing text documents | .docx |
| MS Excel | Calculations and data tables | .xlsx |
| MS PowerPoint | Slide presentations | .pptx |
| Shortcut | Function |
|---|---|
| Ctrl + S | Save the file |
| Ctrl + C | Copy |
| Ctrl + V | Paste |
| Ctrl + X | Cut |
| Ctrl + Z | Undo |
| Ctrl + P |
In this chapter, we learned about MS Office, a suite of application software used all over the world. We studied MS Word, a word processor for typing and formatting text documents; MS Excel, a spreadsheet program for storing numbers and doing automatic calculations with formulas; and MS PowerPoint, a program for creating slide presentations. We learned the parts of each program's window and important shortcuts that make our work faster. We also discovered that MS Office programs work together, allowing us to move charts, tables, and pictures between them. MS Office is a powerful set of tools that helps us in school, at home, and in the office, and mastering it is a valuable skill for life.