1 / 18

MS-Excel XP

MS-Excel XP. Lesson 5. Exponentiation. A1  2 A2  3 A3 =A1^A2 B1 =2^4 2. ^ for exponentiation. ROUND Function. Round a number to a specified number of digits. A1  15.4876 A2  =ROUND(A1,3) A3 =ROUND(A1,2) A4 =ROUND(A1,1) A5 =ROUND(A1,0) B1 12.5 B2 =ROUND(B1,0)

amil
Télécharger la présentation

MS-Excel XP

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. MS-Excel XP Lesson 5

  2. Exponentiation • A1 2 A2 3 A3 =A1^A2 B1 =2^4 2. ^ for exponentiation

  3. ROUND Function • Round a number to a specified number of digits. • A1 15.4876 A2 =ROUND(A1,3) A3 =ROUND(A1,2) A4 =ROUND(A1,1) A5 =ROUND(A1,0) B1 12.5 B2 =ROUND(B1,0) B3 13.5 B4 =ROUND(B3,0) B5 =ROUND(12.875,2) B6 =ROUND(12.865,2)

  4. ROUND Function • Insert menu, Function menu item, • Select category as Math & Trig • Select ROUND function and click ok • Select values to num and num_digits fields • Click ok =ROUND(AVERAGE(A1:A5),0)

  5. INT Function • Rounds a number down to the nearest integer. • A1 12.25 A2 =INT(A1) A3 =INT(12.45) A4 =INT(13.689) 3. Insert menu, Function menu item, 4. Select category as Math & Trig 5. Select INT function and click ok 6. Select value to number field 7. Click ok

  6. MOD Function • Returns the remainder after a number is divided by a divisor. • A1 10 A2 3 A3=MOD(A1,A2) A4=MOD(5,2) A5 =MOD(3,4) A6 =MOD(4,3) 3. Insert menu, Function menu item, 4. Select category as Math & Trig 5. Select MOD function and click ok 6. Select values to number and divisor fields 7. Click ok

  7. IF Function • Checks whether a condition is met, and returns one value if TRUE, and another value if FALSE. =IF(CONDITION,TRUE Value, FALSE Value) A1 45 A2 50 A3 65 B1 =IF(A1>=50,”PASS”, “FAIL”) B2 to B3 drag formula in B1 • = equals to • <> not equals to • < less than • > greater than • <= less than or equals to • >= greater than or equals to

  8. IF Function • Insert menu, Function menu item • Select category as Logical • Select IF function and click ok • Select values to logical_test, value_if_true and value_if_false fileds • Click ok

  9. Nested IF Functions • A1 MARKS A2 40 A3 50 A4 60 A5 70 A6 80 A7 90 B1 GRADE B2=IF(A2>=75,”A”,IF(A2>=65,”B”,IF(A2>=55,”C”,IF(A2>=55,”S”,”F”)))) B3 to B7 drag formula in B2

  10. Nested IF Functions • A1 MARKS A2 40 A3 50 A4 60 A5 70 A6 80 A7 90 B1 GRADE B2=IF(A2<45,”F”,IF(A2<55,”S”,IF(A2<65,”C”,IF(A2<75,”B”,”A”)))) B3 to B7 drag formula in B2

  11. TODAY Function • Returns the current date formatted as a date. • A1 =TODAY() • A2 Select Insert menu Select Function menu item Select category as Date & Time Select TODAY function Click ok Click ok 4. You can formatting date in a cell using format cells option

  12. DATE Function • Returns the number that represents the date in MS-Excel date-time code. • =DATE(Year, Month, Day) • A1 =DATE(2006,6,12) A2=DATE(1979,11,7) A3 Select insert menu and function menu item Select category as Date & Time Select DATE function and click ok Select values to year, month, day fields Click ok

  13. DAY Function • Returns the day of the month, a number from 1 to 31 • A1 =DAY(TODAY()) A2=DAY(DATE(1979,11,7)) A3=DATE(1980,10,30) A4 Select insert menu and function menu item Select category as Date & Time Select DAY function and click ok Select value (A3) to serial_no field Click ok

  14. MONTH Function • Returns the month, a number from 1(January) to 12 (December) • A1 =MONTH(TODAY()) A2=MONTH (DATE(1979,11,7)) A3=DATE(1980,10,30) A4 Select insert menu and function menu item Select category as Date & Time Select MONTH function and click ok Select value (A3) to serial_no field Click ok

  15. YEAR Function • Returns the year of a date, an integer in the range 1900 to 9999 • A1 =YEAR(TODAY()) A2=YEAR (DATE(1979,11,7)) A3=DATE(1980,10,30) A4 Select insert menu and function menu item Select category as Date & Time Select YEAR function and click ok Select value (A3) to serial_no field Click ok

  16. WEEKDAY Function • Returns a number from 1 to 7, identifying the day of the week of a date • A1 =WEEKDAY(TODAY(),1) 1=Sunday B1 =WEEKDAY(TODAY(),2) 1=Monday A2=WEEKDAY (DATE(1979,11,7),1) B2=WEEKDAY (DATE(1979,11,7),2) A3=DATE(1980,10,30) A4 Select insert menu and function menu item Select category as Date & Time Select WEEKDAY function and click ok Select values (A3) to serial_no field and 1 or 2 to return_type field Click ok

  17. WEEKDAY Function Return type = 1 1=Sunday, 2:=Monday,…, 7=Saturday Return type = 2 1=Monday, 2=Tuesday,…………..,7=Sunday

  18. NOW Function • Returns the current date and time formatted as a date and time. • A1 =NOW() • A2 Select Insert menu Select Function menu item Select category as Date & Time Select NOW function Click ok Click ok 4. You can formatting time in a cell using format cells option

More Related