MS Office Word Basics

MS Office

Word Documents

Creating a Word Document

• To create a new Word document, open Word and click on the "File" tab, then select "New" to open a blank document.
• You can also use the keyboard shortcut Ctrl+N to create a new document.
• Word documents can be saved in various formats, including .docx, .doc, and .rtf.

Basic Formatting

• Font styles: Arial, Calibri, Times New Roman, etc.
• Font sizes: 8, 10, 12, 14, etc.
• Alignment: Left, Center, Right, Justify
• Paragraph spacing: Before, After, Line spacing

Editing and Revising

• Cut, Copy, Paste: Ctrl+X, Ctrl+C, Ctrl+V
• Undo and Redo: Ctrl+Z, Ctrl+Y
• Find and Replace: Ctrl+F, Ctrl+H
• Track Changes: allows multiple users to collaborate on a document and track changes made

Excel Formulas

Basic Arithmetic Operations

• Addition: =A1+B1
• Subtraction: =A1-B1
• Multiplication: =A1*B1
• Division: =A1/B1

Functions

• SUM: =SUM(A1:A10) adds up the values in cells A1 through A10
• AVERAGE: =AVERAGE(A1:A10) calculates the average of the values in cells A1 through A10
• COUNT: =COUNT(A1:A10) counts the number of cells in the range A1:A10 that contain numbers

Cell References

• Relative references: =A1 refers to the cell A1
• Absolute references: =$A$1 refers to the cell A1 and does not change when the formula is copied
• Mixed references: =A$1 refers to the cell A1 and changes only the column when copied, =$A1 refers to the cell A1 and changes only the row when copied

MS Office

Word Documents

Creating a Word Document

• Opening a new Word document can be done by clicking on the "File" tab and selecting "New" or using the keyboard shortcut Ctrl+N.
• Word documents can be saved in various formats, including .docx, .doc, and .rtf.

Basic Formatting

• Various font styles are available, including Arial, Calibri, and Times New Roman.
• Font sizes range from 8 to 14 and more.
• Alignment options include Left, Center, Right, and Justify.
• Paragraph spacing can be adjusted before, after, and between lines.

Editing and Revising

• Cut, Copy, and Paste can be done using Ctrl+X, Ctrl+C, and Ctrl+V respectively.
• Undo and Redo can be accessed using Ctrl+Z and Ctrl+Y respectively.
• Find and Replace can be accessed using Ctrl+F and Ctrl+H respectively.
• Track Changes allow multiple users to collaborate on a document and track changes made.

Excel Formulas

Basic Arithmetic Operations

• The formula for addition is =A1+B1.
• The formula for subtraction is =A1-B1.
• The formula for multiplication is =A1*B1.
• The formula for division is =A1/B1.

Functions

• The SUM function adds up values in a range, e.g., =SUM(A1:A10).
• The AVERAGE function calculates the average of values in a range, e.g., =AVERAGE(A1:A10).
• The COUNT function counts the number of cells in a range that contain numbers, e.g., =COUNT(A1:A10).

Cell References

• Relative references refer to a cell's location, e.g., =A1.
• Absolute references refer to a fixed cell location, e.g., =$A$1.
• Mixed references can refer to a fixed row or column, e.g., =A$1 or =$A1.

Excel Formulas

Types of Formulas

• Arithmetic formulas perform calculations using numbers and operators, such as addition, subtraction, multiplication, and division.
• Comparison formulas compare values using operators, like equal to, not equal to, greater than, and less than.
• Text formulas manipulate text strings, including converting to upper or lower case, and extracting substrings.
• Logical formulas evaluate conditions using functions like IF, AND, OR, and NOT, and return a value based on the condition.
• Array formulas perform calculations on arrays of values, such as summing or averaging a range of cells.

Formula Operators

Arithmetic Operators

• + is used for addition.
• - is used for subtraction.
• * is used for multiplication.
• / is used for division.
• % is used for modulus (remainder).

Comparison Operators

• = is used to test if values are equal.
• `` is used to test if values are not equal.
• > is used to test if one value is greater than another.
• = is used to test if one value is greater than or equal to another.
• < is used to test if one value is less than another.
• = is used to test if one value is less than or equal to another.