1 / 18

# MS-Excel XP - PowerPoint PPT Presentation

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)

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

## PowerPoint Slideshow about 'MS-Excel XP' - amil

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

Lesson 5

• A1 2

A2 3

A3 =A1^A2

B1 =2^4

2. ^ for exponentiation

• 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)

• 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)

• Rounds a number down to the nearest integer.

• A1 12.25

A2 =INT(A1)

A3 =INT(12.45)

A4 =INT(13.689)

4. Select category as Math & Trig

5. Select INT function and click ok

6. Select value to number field

7. Click ok

• 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)

4. Select category as Math & Trig

5. Select MOD function and click ok

6. Select values to number and divisor fields

7. Click ok

• 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

• 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

• A1 MARKS

A2 40

A3 50

A4 60

A5 70

A6 80

A7 90

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

• A1 MARKS

A2 40

A3 50

A4 60

A5 70

A6 80

A7 90

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

• Returns the current date formatted as a date.

• A1 =TODAY()

• A2

Select category as Date & Time

Select TODAY function

Click ok

Click ok

4. You can formatting date in a cell using format cells option

• 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 category as Date & Time

Select DATE function and click ok

Select values to year, month, day fields

Click ok

• 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 category as Date & Time

Select DAY function and click ok

Select value (A3) to serial_no field

Click ok

• 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 category as Date & Time

Select MONTH function and click ok

Select value (A3) to serial_no field

Click ok

• 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 category as Date & Time

Select YEAR function and click ok

Select value (A3) to serial_no field

Click ok

• 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 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

Return type = 1

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

Return type = 2

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

• Returns the current date and time formatted as a date and time.

• A1 =NOW()

• A2