Scribd
Upload
3 views4 pages

Working With Data on Excel Notes

The document provides an overview of Excel's components, including the title bar, tabs, and formula bar, as well as explanations of cell addresses, ranges, and naming conventions. It details various operators, the order of precedence in calculations, and common errors in formulas. Additionally, it introduces types of cell references and examples of built-in functions available in Excel.

Uploaded by

khathuriamohit87
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
3 views4 pages

Working With Data on Excel Notes

The document provides an overview of Excel's components, including the title bar, tabs, and formula bar, as well as explanations of cell addresses, ranges, and naming conventions. It details various operators, the order of precedence in calculations, and common errors in formulas. Additionally, it introduces types of cell references and examples of built-in functions available in Excel.

Uploaded by

khathuriamohit87
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/ 4

Working with Data on Excel - Notes

■ Components of Excel Window


1 Title bar – Shows file name
2 Tabs – Contain groups of commands (Home, Insert, etc.)
3 Name box – Shows cell address
4 Formula bar – Displays formulas
5 Active cell – Currently selected cell
6 Row header – Numbers (1, 2, 3…)
7 Column header – Letters (A, B, C…)
8 Sheet tab – Different sheets in a workbook

■ Cell Address & Cell Range


• A cell address is a combination of column letter + row number (Example:
B3).
• A cell range is a group of selected cells. Example: A1:C5.

■ Naming a Range
Ways to name a range:
1. Using Name Box → Select range and type name
2. Using Dialog Box → Formulas → Define Name → Enter name → Select
scope
1 First character must be a letter, backslash (\), or underscore (_)
2 Maximum length = 255 characters
3 Cannot be the same as a formula name
4 No spaces allowed
■ Operators in Excel
1. Arithmetic Operators
1 + (Addition) → =A2+B2
2 - (Subtraction) → =B3-C2
3 * (Multiplication) → =B4*5
4 / (Division) → =D6/C2
5 ^ (Exponent) → =D3^2
2. Comparison Operators
1 = (Equal to)
2 > (Greater than)
3 < (Less than)
4 >= (Greater than or equal to)
5 <= (Less than or equal to)
6 <> (Not equal to)
3. Text Operator
& → Joins text (Example: =A2&B2;)
4. Reference Operators
1 : (Range operator) → A1:A5
2 , (Union operator) → SUM(A1:A4, C1:C4)
3 (space) (Intersection operator) → Common cells in two ranges

■ Order of Precedence
1 1. Colon (:), space, comma
2 2. Percentage (%)
3 3. Exponent (^)
4 4. Multiplication (*) and Division (/)
5 5. Addition (+) and Subtraction (-)
6 6. Relational operators (=, <, >, <=, >=, <>)
■ Formulas
• A formula is an expression that performs operations on cell references.
Steps:
1 Select the cell for result
2 Type = followed by cell references and operators
3 Press Enter

Common Errors in Formulas:


1 ##### → Column too narrow
2 #DIV/0! → Division by zero/empty cell
3 #NAME? → Function not recognized
4 #VALUE! → Wrong data type
5 #REF! → Invalid reference
6 #NUM! → Invalid numeric values

■ Types of Cell References


1. Relative → Example: A1 (changes when copied)
2. Absolute → Example: $A$1 (does not change when copied)
3. Mixed → Example: $A1 or A$1 (partly fixed)

■ Functions
• A function is a predefined formula in Excel starting with '='.
• Examples of built-in functions:
1 SUM() → Adds values
2 AVERAGE() → Finds average
3 MAX() → Finds maximum
4 MIN() → Finds minimum
5 COUNT() → Counts numbers

You might also like