Lesson#2.2 - Excel Data Types and Mouse Pointers.pptx

Excel Data Types and Excel Mouse Pointers

1. EXCEL DATA TYPES AND MOUSE POINTERS Computer Education Grade 6

2. Different Types of Mouse Pointers Arrow Thick Cross Double Headed Thin Cross I - Beam

3. Different type of Data in MS Excel Microsoft Excel

4. Types of Data in MS Excel Label or Text Values or Numbers Formula Functions

5. Types of Data in MS Excel Label or Text Entries that have NO numerical value. It can be letters or combination of Letters, number or symbols It is align automatically on the left side of the cells

6. Types of Data in MS Excel Label or Text Example of Labels - USANT - Maria Clara - (09) – 2345 – 23 - Usant@2023

7. Types of Data in MS Excel Value or Number Numeric data used in calculation. Date can also be considered as value or number. It is align automatically on the right side of the cells

8. Types of Data in MS Excel Value or Number Examples - 56 - 25.50 - 35% - 10/2/2023

9. Types of Data in MS Excel Formula Used in performing calculations. Formula in MS Excel always start with equal (=) symbols.

10. Arithmetic Operators Plus (+) Addition = A1+A2 Minus (-) Subtraction = A1- A2 Asterisk (*) Multiplication = A1 * A2 Forward Slash (/) Division = A1 / A2

11. Types of Data in MS Excel Formula Examples = B4 + D4 = B1 - B2 = C3 * D2 = D6 / B1

12. Functions These are built-in formula that perform mathematical or logical operation The different MS Excel functions belong are Function library Group found in Formula Tab

13. Example of excel functions Function Name =Sum() =Average() =Min() =Max() =Count() =Product() =Proper() =Upper() =Lower() Examples =Sum(A3:B3) =Average(F1:F5) =Min(G1:G3) =Max(G6:G10) =Count(A1:B10) =ProductA2:A6() =Proper(A1) =Upper(B2) =Lower(C2)

14. Types of Data in MS Excel Label or Text Values or Numbers Formula Functions

15. Identify what type of data in MS Excel Iriga City 20.45 [phone] =A1+ C3 =sum(G2:H2) Label/Text Number/Value Label/Text Formula Functions

16. Identify what type of data in MS Excel Formula Number/Value Number/Value Label/Text Function =D3*G1 10/3/2024 98% USANT@2024 =Proper(A2)

17. Identify what type of data in MS Excel Number/Value Label/Text Number/Value Label/Text Function 10:45 Max(A3:A5) 7:30 A2+45 =Average(A1:b2)