Scribd
Upload
12 views

Notes of Ms-Excel

Uploaded by

Kartikay Jain
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
12 views

Notes of Ms-Excel

Uploaded by

Kartikay Jain
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 3

Notes of Ms-Excel

1. Workbook

A workbook is a file that contains one or more worksheets, typically in spreadsheet software
like Microsoft Excel or Google Sheets. It's like a folder containing multiple sheets where data
is organized and stored.

2. Worksheets

A worksheet is a single spreadsheet page within a workbook. It's made up of rows and
columns where you can input data, perform calculations, and analyze information.

3. Data Types

Common data types in spreadsheets include:

• Text: Alphanumeric characters.


• Numbers: Numeric values for calculations.
• Date/Time: Values representing dates or times.
• Boolean: True or False values.

4. Operators

• Arithmetic Operators: Used for basic calculations (+, -, *, /, %).


• Comparison Operators: Compare two values (=, >, <, >=, <=, <>).
• Logical Operators: Used in logical functions (AND, OR, NOT).

5. Cell Formats

• General: Default format for any type of data.


• Number: Displays numbers with specified decimal places.
• Currency: Formats numbers as currency (e.g., $100.00).
• Percentage: Converts numbers into percentage values.
• Date/Time: Formats cells to display date and time.

6. Freeze Panes

Freeze Panes allows you to lock specific rows or columns in place so that they remain
visible as you scroll through the worksheet. This is useful for keeping headers in view while
working with large datasets.

7. Editing Features

• Copy/Paste: Duplicate data from one cell to another.


• Cut/Paste: Move data from one location to another.
• Find/Replace: Search for specific content and replace it.
• Undo/Redo: Reverse or reapply actions.
8. Formatting Features

• Font Size and Style: Change the appearance of text (bold, italics).
• Borders and Shading: Apply borders and background colors to cells.
• Text Alignment: Align text vertically or horizontally within a cell.
• Cell Styles: Predefined formats that can be applied to cells.

9. Creating Formulas

Formulas are mathematical expressions used to perform calculations on data. They begin
with an equal sign (=) and may include numbers, cell references, operators, and functions
(e.g., =A1+B1).

10. Using Formulas

Formulas can be used for tasks like adding, subtracting, multiplying, or averaging numbers in
cells, as well as more complex calculations like financial modeling or statistical analysis.

11. Cell References

• Relative References: Adjust automatically when copied (e.g., A1).


• Absolute References: Do not change when copied (e.g., $A$1).
• Mixed References: Combination of relative and absolute references (e.g., A$1 or
$A1).

12. Replication

Replication is the process of copying a formula or data from one cell to another. This can be
done using the fill handle (dragging the small box at the corner of a cell) or copy-paste
functions.

13. Sorting

Sorting allows you to rearrange data based on specific criteria, such as sorting numbers in
ascending or descending order, or arranging text alphabetically.

14. Filtering

Filtering is used to display only the data that meets certain criteria. For example, you can
filter a list to show only rows where a particular column has a value greater than a specific
number.

15. Functions

Functions are predefined formulas that simplify complex calculations. Common functions
include:

• SUM(): Adds numbers.


• AVERAGE(): Calculates the average.
• IF(): Returns one value if a condition is true and another if it's false.
• VLOOKUP(): Searches for a value in a table.

16. Charts & Graphs

Charts and graphs are visual representations of data, making it easier to identify trends and
patterns. Common types include:

• Bar Chart: Displays data with rectangular bars.


• Pie Chart: Shows proportions of a whole.
• Line Chart: Represents data points connected by a line, showing trends over time.

You might also like