Ms excel xp
This presentation is the property of its rightful owner.
Sponsored Links
1 / 18

MS-Excel XP PowerPoint PPT Presentation


  • 66 Views
  • Uploaded on
  • Presentation posted in: General

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)

Download Presentation

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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript


Ms excel xp

MS-Excel XP

Lesson 5


Exponentiation

Exponentiation

  • A1 2

    A2 3

    A3 =A1^A2

    B1 =2^4

    2.^ for exponentiation


Round function

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)


Round function1

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)


Int function

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


Mod function

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


If function

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


If function1

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


Nested if functions

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


Nested if functions1

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


Today function

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


Date function

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


Day function

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


Month function

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


Year function

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


Weekday function

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


Weekday function1

WEEKDAY Function

Return type = 1

1=Sunday, 2:=Monday,…, 7=Saturday

Return type = 2

1=Monday, 2=Tuesday,…………..,7=Sunday


Now function

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


  • Login