slide1 n.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
FUNCTIONS : AVERAGE(number1,number2,…) COUNT (number1,number2,…) COUNTIF( range,criteria ) PowerPoint Presentation
Download Presentation
FUNCTIONS : AVERAGE(number1,number2,…) COUNT (number1,number2,…) COUNTIF( range,criteria )

Loading in 2 Seconds...

play fullscreen
1 / 1

FUNCTIONS : AVERAGE(number1,number2,…) COUNT (number1,number2,…) COUNTIF( range,criteria ) - PowerPoint PPT Presentation


  • 82 Views
  • Uploaded on

FUNCTIONS : AVERAGE(number1,number2,…) COUNT (number1,number2,…) COUNTIF( range,criteria ) LARGE( array,k ) MAX(number1,number2,…) MIN(number1,number2,…) RANK( number, ref, order) ROUND(number, num_digits ) SMALL( array,k ) SUM(number1,number2,…) SUMIF( range,criteria,sum_range )

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 'FUNCTIONS : AVERAGE(number1,number2,…) COUNT (number1,number2,…) COUNTIF( range,criteria )' - tyrell


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
slide1

FUNCTIONS:

AVERAGE(number1,number2,…)

COUNT (number1,number2,…)

COUNTIF(range,criteria)

LARGE(array,k)

MAX(number1,number2,…)

MIN(number1,number2,…)

RANK( number, ref, order)

ROUND(number, num_digits)

SMALL(array,k)

SUM(number1,number2,…)

SUMIF(range,criteria,sum_range)

HLOOKUP(lookup_value, table_array, row_index_no, type)

VLOOKUP(lookup_value, table_array, col_index_no, type)

FV(rate, nper, pmt, pv, type)

NPER (rate, pmt, pv, fv, type)

PMT(rate, nper, pv, fv, type)

PV(rate, nper, pmt, fv, type)

RATE(nper, pmt, pv, fv, type)

AND(logical1, logical2,…)

OR(logical1, logical2,…)

NOT(logical)

IF(logical_test,value_if_true, value_if_false)

FRAMES

VISION

DIOPTERS

GLASSES