MICROSOFT OFFICE & MS WORD

1. Microsoft Office (MS-Office) Basics

Microsoft Office is a popular software package created by assembling various types of software meant primarily for office and school environments.

Invented By: Microsoft Company (USA).
Invention Year: 1988.
First Edition Released: 1990.
Initial Software Included: MS-Word, MS-PowerPoint, and MS-Excel.
Later Additions: MS-Access (Database), MS-Picture Manager, Spell Checker, VBA Scripting Language, and MS-Outlook.
Mobile Versions: A mobile version named MS-OFFICE Mobile is available for Android, iPhone, and Windows phones.

Classification of MS-Office Software Packages

The five major software applications included in MS-Office are classified as follows:

Software Name	Type of Software	Primary Purpose
MS-Word	Word Processing Software	Creating and editing documents.
MS-Excel	Tabular Data Formatting Software	Managing tabular data and calculations.
MS-PowerPoint	Presentation Software	Creating slides and presentations.
MS-Access	Database Management Software	Managing and storing databases.
MS-Outlook	E-mail Client	Managing emails and communications.

2. Microsoft Word (MS-Word)

Microsoft Word is an essential word processing software found inside almost all MS-Office packages. It is used to create, modify, format, and print documents.

Key Features:

Allows creation of highly attractive documents by inserting pictures, graphics, and text styles.
Contains numerous tools capable of creating and editing even very small documents (under 45kb in size).

Historical Timeline of MS-Word

1983: The first Word Processing Software was created for the MS-DOS operating system.
1985: A graphical version of Microsoft Word was developed for the Mac Operating System.
1990: Added to the first edition of the MS-Office package.

3. How to Start MS-Word

There are three primary methods to open MS-Word on a computer:

Using Run Command: Click the 'Start' button on the taskbar $\rightarrow$ Click 'Run' $\rightarrow$ Type Winword in the text box $\rightarrow$ Press the Enter key.
Desktop Shortcut: Double-click the Microsoft icon available directly on the desktop.
Start Menu Navigation: Click 'Start' $\rightarrow$ 'All Programs' $\rightarrow$ 'MS-Office' $\rightarrow$ Select 'MS-Word'.

4. Components of the MS-Word Window

When you open MS-Word, the screen consists of several distinct parts and toolbars.

A. Title Bar

The topmost ribbon (strip) on the MS-Word document screen.
It displays the name of the file and the name of the software in use.

Buttons on the Title Bar:

Button Name	Symbol	Function
Minimize	Dash (-)	Temporarily hides the window, turning it into a button on the taskbar. The file remains active and does not close.
Maximize / Restore	Square ($\square$) / Rectangles	Maximize makes the window full screen. When full, it turns into a 'Restore' button (pair of small rectangles) to return the window to its previous size.
Close	Cross (x)	Used to permanently close an open file.

B. Standard Toolbar

Contains basic tools for file and text-related tasks.
Examples: Opening a new file, opening an old file, and saving a file.

C. Ribbon & Tabs

Ribbon: A strip located just below the Title Bar at the top of the screen. It holds a panel of commands needed to perform tasks. This ribbon can also be minimized.
Tabs: Buttons placed on the menu bar of the ribbon. They are used to edit characters, change document layouts, preview pages, and insert graphs/pictures.

Key Tabs and Their Functions:

1. Home Tab Contains essential formatting options including:

Clipboard: Contains Cut, Copy, and Paste options. Cut or copied data is stored in the clipboard to be pasted elsewhere.
Font: Used for altering font size, style, color, bolding, italicizing, and underlining.
Paragraph: Used for adding bullets or numbering to lines, and indenting. (Note: This toolbar is also known as the Formatting Toolbar).
Styles: Used to change the text style of the document.
Editing: Used to find specific characters or words, and replace them with others.

2. Insert Tab Contains options to add external elements to the document:

Available Options: Pages, Tables, Illustrations, Links, Header and Footer, Text, and Symbols.
Pages Option: Used to insert a cover page, insert a blank page, or break a page in the middle.
Tables: Used to create and insert different types of tables.
Illustrations: Used to insert Pictures, Clip Art, Shapes, SmartArt, Charts, etc..
Links: Used for creating Hyperlinks, Bookmarks, and Cross-references.
Header & Footer: Used to add repeating headers (at the top) and footers (at the bottom) of a page.
Text Options: Used to insert Text Boxes, WordArt, Date & Time, and various objects.
Symbols: Used to insert special characters and symbols into the document.

B. Other Important Tabs

Tab Name	Primary Uses
Page Layout Tab	Used to apply Themes, set the page Background, and adjust Paragraph settings.
Review Tab	Used to run Spelling and Grammar checks, consult the Dictionary/Thesaurus, Translate text, and protect the document.
View Tab	Used to change page views (Print Layout, Full Screen Layout), manage Macros, and Split the window.

6. Key Components of the MS-Word Workspace

A. Ruler

Rulers appear at the top and the left side of the document window. They are used to view and set the horizontal and vertical alignment (margins) of text.

Horizontal Ruler: Indicates the width of the document. It shows the distance between the text and the left/right page edges, and is used to set the Left and Right margins.
Vertical Ruler: Indicates the height of the document. It shows the distance between the text and the top/bottom page borders, and is used to set Top and Bottom margins.

B. Status Bar

Located at the bottom of the window.
Displays critical document information such as the current page number, total pages, current template, column number, and line number.

C. Work Area (Workplace)

The rectangular central area of the window where typing, editing, and picture insertion happen.

D. Cursor (Insertion Pointer)

A blinking line that indicates the starting point for text entry.
Whatever text you type or objects you insert will appear exactly where the cursor is positioned.

7. Major Features of MS-Word

Microsoft Word is highly popular because it is user-friendly, even for beginners. Its key features include:

Text Editing: Allows you to easily type, edit, modify, or delete text. Cut or copied text is temporarily stored in the Clipboard until it is pasted.
Format Text: Text appearance can be heavily customized using different styles, designs, and fonts.
Indentation: Allows you to increase or decrease the gap between the page boundaries (margins) and the text.
Page Orientation: Supports two orientations for printing:
- Horizontal (Landscape)
- Vertical (Portrait)
Find and Replace: You can easily search for a specific character or word and automatically replace it with new text.
Spell Check: An automatic feature that detects and corrects spelling and grammatical errors.
Thesaurus: A comprehensive built-in dictionary that provides synonyms for various words.
Bullets and Numbering: Helps create sequential lists using bullets (special symbols) or numbers (counting numbers, Roman numerals, English alphabets).
Mail-Merge: A powerful feature used to send the same letter to multiple recipients by combining a "Main Document" with a "Data File / Source". It is also used to print address labels for envelopes.
Graphics: Provides a drawing toolbar to easily draw shapes like circles, rectangles, triangles, and lines.
Object Linking and Embedding (OLE): A program integration technology that allows users to share and display external objects (like charts, equations, and video clips) inside the Word document.
Scroll Bars: Used to navigate the document:
- Horizontal Scroll Bar: Moves the page left and right (located above the status bar).
- Vertical Scroll Bar: Moves the page up and down (located on the right side of the screen).

8. Essential MS-Word Shortcut Keys

Shortcut keys allow for quick execution of commands, making document editing significantly faster. They are categorized based on their respective toolbars.

A. Standard Toolbar Shortcuts

These shortcuts are primarily used for general file management and editing commands.

Command / Tool Name	Shortcut Key	Description
New	`Ctrl + N`	Creates a new blank document.
Open	`Ctrl + O` or `Ctrl + F12`	Opens an already existing/saved document.
Save	`Ctrl + S` or `Shift + F12`	Saves the currently active document.
Save As	`F12`	Saves a document with a new name or in a new location.
Select All	`Ctrl + A`	Selects all the contents present on the page.
Print	`Ctrl + P` or `Ctrl + Shift + F12`	Prints the active document.
Print Preview	`Ctrl + F2`	Displays a preview of the page before printing.
Spelling	`F7`	Opens the spell-check feature for the active document.
Find, Replace & Go To	`F5`	Opens the Find, Replace, and Go To dialogue window.
Cut	`Ctrl + X`	Cuts the selected text/object and stores it in the clipboard.
Copy	`Ctrl + C`	Copies the selected text/object and stores it in the clipboard.
Paste	`Ctrl + V` or `Shift + Insert`	Pastes the cut or copied content from the clipboard to a selected location.
Undo	`Ctrl + Z`	Cancels the previously given command.
Redo	`Ctrl + Y`	Re-applies the command that was canceled by Undo.

B. Formatting Toolbar Shortcuts

These shortcuts are used to modify the appearance and alignment of the text.

Command / Tool Name	Shortcut Key	Description
Style	`Ctrl + Shift + S`	Changes the style of the selected text or font.
Font	`Ctrl + Shift + F`	Changes the font face and size of the selected portion.
Font Size	`Ctrl + Shift + P`	Changes only the font size of the selected portion.
Bold	`Ctrl + B`	Makes the selected text or word bold (thicker letters).
Italic	`Ctrl + I`	Makes the selected text or word italicized (slanted).
Underline	`Ctrl + U`	Draws a line underneath the selected text or word.
Align Left	`Ctrl + L`	Aligns the paragraph or words to the left margin.
Centre	`Ctrl + E`	Centers the paragraph or words in the middle of the page.
Align Right	`Ctrl + R`	Aligns the paragraph or words to the right margin.
Justify	`Ctrl + J`	Aligns the paragraph evenly along both the left and right margins.

9. Introduction to Microsoft Excel (MS-Excel)

MS-Excel is a powerful electronic spreadsheet program used extensively for data management and numerical analysis.

Key Uses & Features:

Organizing data and performing complex calculations.
Reaching business or analytical decisions.
Generating reports that display graphical representations of data.
Publishing organized data to the web and accessing real-time data.
Functions as a database to store and search related data using specific patterns.
Allows the insertion of photographs, drawings, clip art, and logos imported from other programs.

Historical Background:

1985: The first version of MS-Excel was created by Microsoft for the Mac OS (Operating System).
1990: It was bundled and combined with the first edition of the MS-OFFICE software package.

Structure of a Spreadsheet

A spreadsheet (also known as a Worksheet) is heavily used for accounting purposes, creating budgets for mathematical tasks, and generating bills.

Cells: The worksheet is made up of a massive collection of individual boxes called cells.
Rows (Horizontal): These are lines running left to right. They are identified sequentially by Numbers (e.g., 1, 2, 3...).
Columns (Vertical): These are lines running top to bottom. They are identified by Alphabetical Letters (e.g., A, B, C...).

Exam Fact: Other popular alternative spreadsheet programs include Snowball, Lotus 1-2-3, and Apple Numbers.

10. How to Start MS-Excel

You can launch MS-Excel on a computer using any of the following three methods:

Desktop Shortcut: Double-click the MS-Excel shortcut icon available on the desktop.
Start Menu: Click Start $\rightarrow$ All Programs $\rightarrow$ MS-OFFICE $\rightarrow$ Select Microsoft OFFICE Excel 2007.
Run Command: Click the Start button $\rightarrow$ Click 'Run' $\rightarrow$ Type Excel in the run text box $\rightarrow$ Press the Enter key.

11. Components of the MS-Excel Window

When MS-Excel is opened, its interface consists of various elements:

Title Bar: The uppermost bar of the Excel window that displays the name of the active workbook/application. (Additional components will follow in the next sections).

A. Ribbon & Tabs

Ribbon: A panel located at the top of the window, just below the Title Bar. It contains commands needed to perform tasks and is divided into various tabs. The ribbon can also be hidden/minimized.
Tabs: The buttons located on the menu bar below the Title Bar are called tabs. Examples include Home, Insert, Page Layout, Formula, Data, Review, and View.

Important Commands Found in Tabs:

Clipboard: Contains commands to Cut, Copy, and Paste data or text. Cut or copied data is temporarily stored here to be pasted elsewhere.
Alignment: Used to change the text alignment (Vertical or Horizontal) inside a cell. Includes features like Wrap Text (moving to the next line within the same cell if text overflows), Merge (combining two or more cells), and fitting text into a single cell.
Table: Used to define a group of cells as a table, making it easier to filter and sort data. It is also used to create Pivot Tables or Charts, which help summarize and organize complex data.
Function Library: Contains built-in functions used for calculations, such as Mathematical, Logical, and Trigonometric functions.
- Examples: SUM(), AND, IF, LOOKUP, AVG, DATE.
Macros: Used to record and define a "Sequence of Actions." Once defined, this sequence can be run repeatedly across multiple documents to automate specific tasks.

B. Status Bar

Located at the very bottom of the screen, just above the Windows taskbar.
Displays information about the currently open worksheet, such as page number, view shortcuts, and the zoom slider.

C. Formula Bar

Located directly below the ribbon, consisting of two main parts:
1. Name Box: Displays the reference (address) of the currently active cell.
2. Formula Area: Used to type or display formulas for calculations. It also displays the actual content of the currently active cell.

12. Important Facts Related to Spreadsheets

A spreadsheet is a software tool designed to enter, calculate, manipulate, and analyze groups of numbers.

Key Definitions & Concepts:

Cell: A container formed by the intersection of rows and columns. It holds numbers, text (labels), and formulas.
Worksheet (or Sheet): An array (collection) of cells. Data is displayed here in tabular form.
Workbook: A main Excel document that contains one or more worksheets.
Rows: Horizontal lines identified by numbers (1, 2, 3...).
Columns: Vertical lines identified by letter groups (A, B, C... AA, AB... Z).
Cell Pointer: The boundary/highlight that indicates which cell is currently active.
Formula: An equation used to calculate a value in a cell. Note: Every formula must start with an equals sign (=).
Cell Address: Represents the intersection of a column letter and a row number (e.g., C5 means Column C and Row 5).

13. MS-Excel Charts

Charts are used for the graphical and pictorial presentation of worksheet data.

Dynamic Nature: A key feature of Excel charts is that if you modify the base data, the chart updates automatically to reflect the changes.

A. Types of Charts

Excel offers 6 primary types of charts:

Column Chart
Bar Chart
Line Chart
Area Chart
Pie Chart
XY or Scatter Chart

B. Elements of a Chart

Element Name	Description
Chart Area	The entire rectangular bounding box that contains the chart and all its elements.
Plot Area	The specific area where data is graphically plotted. In 2D charts, it is surrounded by axes; in 3D charts, it is surrounded by walls and a floor.
Chart Title	The heading of the chart that explains what the chart represents.
Axes	Generally, a chart has two axes: X-Axis (Horizontal/Category Axis) and Y-Axis (Vertical/Value Axis).
Axis Title	Titles given to the X, Y, and Z axes to explain what their values mean.
Data Series	The collection of values you want to show on the chart (e.g., Sales and Purchases shown as different colored columns).
Grid Lines	Background lines that help identify the level/value of the data series. Includes Major (main levels) and Minor (smaller levels) grid lines. X-axis grid lines are vertical, Y-axis grid lines are horizontal.
Legends	Indicators that explain the meaning of different colors, columns, lines, or points used in the chart. Can be placed anywhere (top, bottom, left, right).
Data Labels	The actual data values displayed right next to the corresponding column, line, or mark on the chart.
Data Table	A simple table often placed in the corner of the chart, displaying all data series values.

14. Essential MS-Excel Shortcut Keys

Shortcut keys help speed up data entry and spreadsheet formatting.

Shortcut Key	Description (Function)
F2	Used to edit the currently selected cell.
F5	Used to go to a specific cell.
F7	Used to check spelling in selected text or document.
Ctrl + Shift + ;	Used to enter the current time.
Ctrl + ;	Used to enter the current date.
Alt + Shift + F1	Used to insert a new worksheet.
Shift + F3	Opens the Excel Formula Window.
Shift + F5	Opens the Search Box.
Ctrl + F10	Maximizes the currently selected worksheet window.
Ctrl + F6	Used to switch from one open workbook/window to another open workbook/window.

15. Important MS-Excel Shortcut Keys & Formatting Commands

In addition to general shortcuts, MS-Excel uses specific key combinations for quick formatting and navigation.

A. Navigation & General Shortcuts

Shortcut Key	Description (Function)
Ctrl + Page Up / Page Down	Used to move between different worksheets within the same Excel document.
Ctrl + Tab	Used to move between two different open Excel files.
Ctrl + Space	Selects the entire Column.
Shift + Space	Selects the entire Row.
Alt + =	Creates an AutoSum formula to add all data in the selected cells.
Ctrl + '	Inserts the previously selected cell's data into the currently selected cell.

B. Number Formatting Shortcuts

Shortcut Key	Applied Format
Ctrl + Shift + !	Formats numbers in Comma format.
Ctrl + Shift + $	Formats numbers in Currency format.
Ctrl + Shift + #	Formats numbers in Date format.
Ctrl + Shift + @	Formats numbers in Time format.
Ctrl + Shift + %	Formats numbers in Percentage format.

16. Key Facts to Know About MS-Excel

Default Sheets: By default, a newly created workbook in MS-Excel contains exactly 3 worksheets.
Active Cell: The specific cell where you are currently working or typing is called the Active Cell.
File Extension: MS-Excel files are saved with the .xls format/extension.
Illustrations Group: Used to insert pictures, clip art, shapes, and SmartArt into the worksheet.
Absolute Reference ($): The dollar sign ($) is used to lock a cell's location to a fixed position in a formula.
Chart Wizard: A built-in tool used to easily create charts in MS-Excel.
Embedded Chart: A type of chart that is drawn directly onto an already existing worksheet.
Specific Charts:
- Stacked Bar Column: Shows the relationship of individual items to the whole.
- Scatter Chart: Compares pairs of values.

17. Microsoft PowerPoint (MS-PowerPoint)

Microsoft PowerPoint is a professional presentation graphics software developed by Microsoft, included as part of the MS-Office package.

Primary Uses:

Easily and quickly creates, edits, sorts, and helps you practice presentations.
Provides flexibility to make presentations informal by adopting transparency, or electronic by connecting to a personal computer.
Allows the creation of Dynamic presentations featuring multimedia elements like movies and pictures.

A. How to Start MS-PowerPoint

Desktop Shortcut: Double-click the MS-PowerPoint icon on the desktop.
Start Menu: Click Start $\rightarrow$ All Programs $\rightarrow$ Microsoft Office $\rightarrow$ Select Microsoft Power Point.

B. Core Components of PowerPoint

Component	Description
Slide	Every single page of a presentation is called a slide. Each slide is created to present a specific point or topic.
Speaker's Notes	Information provided to remind the speaker of certain points during the presentation. These are usually printed on paper and are not visible on the slide during the show.
Presentation File	A specific file containing all the slides for a particular topic. The file extension is usually .PPT (e.g., Proj1.PPT).
Master Slide	A primary slide containing information or design elements that are automatically applied to every slide in the presentation.

C. Major Features of PowerPoint

Slide Transition: The visual effect or manner in which the next slide appears after the previous one during a presentation.
Animation Effects: Adding movement, sound, or controlling how various elements (text/images) appear on a single slide.
Slide Title: A specific name given to identify a slide.
Sub Title: A title used within the main title that briefly describes the slide's data and highlights its central focal point.
Notes Pages: Found in the View menu, this allows the presenter to add and edit speaker notes.
Slide Pane: The workspace area where everything is written and edited on a slide.

18. PowerPoint Views

PowerPoint offers several viewing modes to help fill, edit, view, and correctly sequence slide information.

Normal View: The primary view for writing and editing. It divides the screen into three panes. The left side is the "Slide Pane" which contains two tabs:
- Outline Tab: Shows text, titles, and main points. It is best for typing, editing, and arranging text.
- Slides Tab: Shows small thumbnail versions of all slides. Clicking one opens it in a larger format on the right side for editing pictures and colors.
Slide Sorter View: Displays all slides of the presentation together in a small (thumbnail) format, including text and graphics. It is used to easily drag and drop slides to arrange them in any desired order.
Slide Show View: Hides all other PowerPoint elements and displays a single slide in full screen. This view shows the slides sequentially with all applied effects and animations exactly as the audience will see them.

19. Microsoft Access (MS-Access)

Microsoft Access is a Database Management System (DBMS).

Key Concepts:

It combines the relational Microsoft Jet Database Engine with a graphical user interface (GUI) and software development tools.
Primary Use: Software developers use MS-Access to develop Application Software.
It supports Object-Oriented Programming (OOP) for applications, ActiveX data objects, and other ActiveX components.

20. Elements of MS-Access

To perform any task in MS-Access, the following core elements are used:

A. Field Name

A label that indicates what specific type of information or data will be stored in that field.
Rule: A field name must be Unique within a table. It is also referred to as a Field Identity.

B. Field Type / Data Type

Defines exactly what kind of data can be stored in a field (e.g., only text, only numbers, or a combination of both).
The default size for a data type in MS-Access is 50.

MS-Access Data Types & Sizes:

Data Type	Field Length / Size
Text	0 - 255 characters
Memo	0 - 65,535 characters
Date/Time	8 bytes
Number	1, 2, 4, or 8 bytes
Currency	8 bytes
Auto Number	4 bytes
Yes/No	1 bit (0 or 1)
OLE Object	Up to 1 GB
Hyperlink	2048 characters in each part

C. Other Important Table Elements

Field Length: Refers to the maximum number of characters that can be stored in a single field.
Primary Key: A special key used to uniquely identify a record. Exam Fact: If a field is set as a Primary Key, it cannot be left empty (null).
Validation Rule: A feature used for validity checking. It verifies the validity of data before it is entered into a field. If the data is invalid, it prints an error message.
Filtering Data: A function that displays only the specific records from a table that meet a given set of conditions (criteria).
Attributes: The properties of a record used to identify and organize it systematically.

D. Relationships

Relationships define the connection or differences between two or more tables. They are divided into three types:

One to One
One to Many
Many to Many

21. MS-Access Views

MS-Access provides two primary types of views used to create tables and configure their columns/fields:

View Type	Purpose & Features
Data Sheet View	Used to display, enter, and edit data within the database. You cannot change the core structure of the database here, but you can set column names and add new columns.
Design View	Used to design a new table or modify the design of an existing one. This is where you set Field Names, Data Types, and assign keys (like the Primary Key or Candidate Key).

22. Microsoft Outlook

Microsoft Outlook is a Personal Information Manager and E-mail Communication software developed by Microsoft, included in the MS-Office suite.

Key Uses & Features:

Primary Function: Primarily used as an Email Client to send and receive emails.
Built-in Tools: Includes a Calendar, Task Manager, Contact Manager, Note-making tool, Journal, and Web Browsing capabilities.
Usage Modes:
- It can be used entirely as a Stand Alone Application.
- In an organization with multiple users, it is highly beneficial to pair it with Microsoft Exchange Server and Microsoft SharePoint Server.

23. Important Facts to Know (Exam Pointers)

File Extension: The default file format for modern MS-Access databases is .accdb.
Memo Data Type limits: The Memo data type is used to store very large amounts of text, but it strictly stores Textual data only.
OLE Object Full Form: Stands for Object Linking and Embedding. It is used to store external objects like video clips, pictures, and Word documents directly into the database.
Storage Byte Rule: Storing a single character in a database requires exactly 1 byte of memory.
Validation Failure: If a Validation Rule is not satisfied by the user's input, the system will display Validation Text (an error message).

📚 Summary / Revision Notes (Quick Takeaways)

Origin: MS-Office was created by Microsoft in 1988; First version released in 1990.
Core Software: Word (Word processing), Excel (Data/Tables), PowerPoint (Presentations), Access (Databases).
Run Command: Type Winword in the run dialog box to quickly open MS-Word.
Title Bar: Topmost bar; shows file name; houses Minimize (-), Maximize/Restore ($\square$), and Close buttons.
Clipboard: Temporarily stores text that you Cut or Copy so you can Paste it later.
Home Tab vs. Insert Tab: Home Tab is for formatting text (font, paragraphs, styles). Insert Tab is for adding elements (blank pages, tables, headers/footers).

First Release: MS-Word was initially released in 1983 as "Multi-Tool Word" for the Xenix System.
Default File Name: Whenever you open a new file, MS-Word automatically names it Document1.
File Formats: MS-Word files are saved with .doc or .docx extensions.
Default Alignment: According to the text, the default alignment for a paragraph in MS-Word is Centred.
Office Logo Button: Located at the top-left edge of the MS-Office window, this button provides quick access to core functions like Open, Close, Save, and Print.
Important Shortcut: Pressing Ctrl + Home instantly moves the cursor to the very beginning of the document.

Crucial Shortcuts:
- F12 for Save As.
- F7 for Spell Check.
- F5 for Find, Replace & Go To.
- Ctrl + E for Center Alignment.
- Ctrl + J for Justify Alignment.
Excel History: First launched in 1985 for Mac OS; merged into MS-Office in 1990.
Spreadsheet Layout: Organized into Horizontal Rows (denoted by numbers 1, 2, 3) and Vertical Columns (denoted by letters A, B, C).
Alternative Spreadsheets: Lotus 1-2-3, Apple Numbers, and Snowball.
Run Command: Type Excel in the Run window to launch MS-Excel instantly.

Worksheet vs. Workbook: A worksheet is a single page of cells, while a workbook is the entire file containing multiple worksheets.
Cell Address Format: Always Letter then Number (e.g., C5). Rows are numbers, Columns are letters.
Formulas: Must always begin with an equals (=) sign.
Name Box: Crucial for quickly seeing the address of the active cell (located to the left of the formula bar).
Important Excel Shortcuts:
- Ctrl + ; for Current Date.
- Ctrl + Shift + ; for Current Time.
- F2 to Edit a cell.
Chart Basics: X-Axis is the horizontal Category axis, and Y-Axis is the vertical Value axis. A chart updates immediately when its source data is altered.

Excel Formats: Learn the Ctrl + Shift + [Symbol] patterns. ! = Comma, $ = Currency, # = Date, @ = Time, % = Percentage.
Important Excel Facts: A new workbook has 3 default sheets. A $ symbol makes a cell reference absolute (locked).
PowerPoint Definitions:
- Slide: A single page of a presentation.
- Master Slide: Affects the layout of all slides.
- Transition: The effect between two different slides.
- Animation: The effect on elements within one slide.
Max Zoom: PowerPoint can be zoomed to a maximum of 400%.
Triggers & Multimedia: A Trigger is an object that performs a specific action when clicked. Supported multimedia formats include .gif, .bmp, .png, .wav, .mid.
MS-Access: Simply remember it as the Database Management System used to build application software.

Primary Key Rule: Uniquely identifies records; cannot be left blank.
MS-Access Views: Use Design View to build the table structure/keys. Use Data Sheet View to enter or edit the actual data inside it.
Data Size Limits: Text = 255 chars max; Memo = 65,535 chars max; OLE Object = up to 1 GB.
Relationships Classification: One-to-One, One-to-Many, Many-to-Many.
Outlook: It is MS-Office's official Email Client and Personal Information Manager (features calendars and task managers).
Important Extension: MS-Access uses .accdb files.
OLE Object: Remember "Object Linking and Embedding" – used for media like videos and pictures in Access.

Numeric