ms excel xp
Download
Skip this Video
Download Presentation
MS-Excel XP

Loading in 2 Seconds...

play fullscreen
1 / 18

MS-Excel XP - PowerPoint PPT Presentation


  • 118 Views
  • Uploaded on

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)

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about ' MS-Excel XP' - amil


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

ad